Other Service Line - Architect - GENART

Ipolarity LLC
  • Carmel, IN
  • Instant Apply
8 days ago

Job Description

Max vendor####/hr
Remote is ok

Role Overview
We are seeking experienced Data Archival professionals to lead the design and implementation of an enterprise-grade archival solution on Platform 3 (Archon). Product-specific training on Archon will be provided; the role demands strong foundations in enterprise data archival, ETL design, and data-platform architecture. Scope spans end-to-end delivery from source-system discovery and retention-rule design, through platform setup, ETL build, archival execution, validation, and operational handover. Candidates will work across Production and Non-Production environments, deliver Warm and Cold archival tiers (with de-identification), and align the solution to enterprise security and compliance standards.
Key Responsibilities
Solution Architecture & Design
Define end-to-end archival architecture on Platform 3 (Archon), including Archon Data Store (ADS), Archon ETL, and Archon Analyzer components.
Design Warm Archive, Cold Archive (de-identified), and Data Bunker tiers in line with retention, legal-hold, and WORM compliance requirements.
Translate business retention, privacy, and regulatory policies into archival rules, data classification, tier-mapping logic, and de-identification/tokenization strategies.
Produce reference architecture, data flow, integration, and security design artifacts aligned to the customer's System Security Plan (SSP).
Define retrieval patterns predefined SQL/reports via the Archon UI, distributed query (Trino/Spark) and API-based access where required.
Implementation & Delivery
Lead Platform 3 (Archon) setup and configuration across Production and Non-Production environments, including DR (and HA where in scope).
Design and oversee build of archival ETL pipelines using Archon native ETL extraction, transformation, indexing, and load into ADS.
Drive source-system connectivity, schema discovery, and dependency mapping using Archon Analyzer.
Own pilot execution on a defined data subset, then scale-up to full archival of in-scope source systems.
Lead data validation, reconciliation, volumetric verification, and source-system archival sign-off.
Performance, Monitoring & Issue Resolution
Develop monitoring dashboards and operational reports for archival jobs, ETL pipelines, and storage tiers.
Troubleshoot and resolve issues across Archon ETL pipelines, archival workflows, source-system connectivity, and retrieval performance.
Define SLAs, alerting thresholds, and run-book remediation steps for common failure modes; drive root-cause analysis for Sev1/Sev2 issues.
Governance, Compliance & Stakeholder Management
Ensure archival design meets regulatory, audit, and information-governance requirements applicable to the customer's industry.
Partner with customer Architecture, Security, Compliance, Database Administrators (DBAs), application owners, IT infrastructure teams, and SMEs; represent delivery in design and architecture reviews.
Define monitoring, runbooks, documentation, and knowledge-transfer artifacts; support warranty and operational handover.
Provide technical guidance and structured training to stakeholders DBAs, application owners, operations, and business users on archival processes, retrieval workflows, and post-archival access patterns.
Identify and manage technical risks; drive Change Control where scope or assumptions shift.
Required Technical Skills
Note: Platform 3 (Archon) product training will be provided. Prior Archon experience is desirable but not mandatory; strong fundamentals in data archival, ETL, and lakehouse / data-platform architecture are essential.
Data, Cloud & Integration
Strong SQL and relational database expertise DB2, Oracle, SQL Server (and ideally mainframe / AS-400 data sources).
Solid grounding in data warehousing, data lakehouse, and ELT/ETL design patterns; familiarity with Parquet/ORC, Iceberg/Delta, and metadata-driven ingestion.
Experience with Azure cloud storage (Blob, ADLS Gen2) for archival workloads tiering, lifecycle policies, and cost optimization; AWS S3 exposure is a plus.
Working knowledge of authentication / authorization patterns (SSO, SAML/OIDC), encryption in transit and at rest (AES-256, KMS), and secure credential handling.
Comfort with REST APIs, file-based and CDC-based extraction patterns, and integration with downstream consumers (e.g., MuleSoft, iPaaS).
Governance, Compliance & Security
Strong understanding of data retention, legal hold, audit trails, and information lifecycle management.
Working knowledge of regulatory frameworks relevant to archival GLBA, SOX, HIPAA, GDPR, NAIC Model Regulation #672, state record-retention requirements, and PII/PHI handling.
Experience implementing WORM compliance, chain-of-custody controls, and role-based access for archived data.
Prior Archival / Decommissioning Implementation Experience
Candidates must be able to demonstrate hands-on delivery on at least one preferably multiple prior archival or application decommissioning programs. Specifically:
End-to-end delivery of one or more enterprise archival / decommissioning programs (preferably 2+ for Senior Architect).
Experience archiving from at least two of the following source-system families: mainframe (AS/400, COBOL/DB2, VSAM), legacy ERP (SAP ECC, PeopleSoft, JD Edwards, Siebel, Lotus Notes), legacy policy administration / closed-block insurance systems, healthcare EHR, custom RDBMS-based applications.
Demonstrable volume handled ideally TB-scale archival, with clear evidence of volumetric estimation, throughput tuning, and reconciliation.
Prior use of one or more archival tools Archon / Platform 3 (strongly preferred), Informatica ILM, OpenText InfoArchive, Solix EDMS, Archive360, IBM Optim, or equivalent. Cross-tool experience (e.g., migrating off legacy archival tools onto Archon) is a strong plus.
Experience defining and operationalising retention rule sets, legal-hold workflows, and de-identification rules in production.
Track record of successful pilot-to-scale transitions, including go/no-go criteria, defect triage, and sign-off governance.
Exposure to post-archival application retirement / decommissioning sequencing including infrastructure shutdown, license recovery, and audit closure.
Soft Skills
Strong written and verbal communication able to author design documents, runbooks, and present to customer architecture forums.
Stakeholder management across business, application, security, and compliance teams.
Structured problem-solving with the ability to operate independently in ambiguous, multi-stakeholder environments.
Preferred Qualifications
Hands-on or familiarity with Platform 3 (Archon) components Archon Data Store (ADS) lakehouse, Archon native ETL, Archon Analyzer (source-system discovery), Archon Data Bunker (air-gapped isolation, tokenization), and Archon UI / Trino-Spark-based retrieval.
Insurance domain experience, preferably Life & Annuity (L&A) and closed-block administration.
Exposure to modern Life & Annuity policy administration platforms (e.g., Verisk FAST, Oracle OIPA, LifePRO) as archival source systems.
Certification in Archon, Informatica ILM, or equivalent archival / ETL tooling.
Exposure to Gartner-recognised archival platforms and broader information-governance tooling (Collibra, Alation) is a plus.

Numbers & Facts

LocationCarmel, IN

Skills

  • Amazon Simple Storage Service (S3)unmatched
  • Annuitiesunmatched
  • Application Programming Interface (API)unmatched
  • Applications Securityunmatched
  • Authenticationunmatched
  • Bug Tracking/Defect Managementunmatched
  • Business Solutionsunmatched
  • Centers for Disease Control and Prevention (CDC)unmatched
  • Cloud Computingunmatched
  • Cloud Storageunmatched
  • Cobol Programming Languageunmatched
  • Communication Skillsunmatched
  • Computer Securityunmatched
  • Cost Controlunmatched
  • Cryptographyunmatched
  • Data Qualityunmatched
  • Data Warehousingunmatched
  • Database Administrationunmatched
  • Database Extract Transform and Load (ETL)unmatched
  • Design Documentunmatched
  • Design Patterns Programming Methodologiesunmatched
  • Enterprise Protectionunmatched
  • HCL/Lotus Notesunmatched
  • HIPAA (Health Insurance Portability and Accountability Act)unmatched
  • Healthcareunmatched
  • IBM AS-400 Serverunmatched
  • IBM DB2unmatched
  • IBM Product Familyunmatched
  • Identify Issuesunmatched
  • Informaticaunmatched
  • Information Technology & Information Systemsunmatched
  • Insuranceunmatched
  • J D Edwardsunmatched
  • Legalunmatched
  • Machine Toolunmatched
  • Mainframe Computerunmatched
  • Maintain Complianceunmatched
  • Medical Record Systemunmatched
  • Metadataunmatched
  • Microsoft SQL Serverunmatched
  • Microsoft Windows Azureunmatched
  • Oracleunmatched
  • Oracle Databaseunmatched
  • Peoplesoftunmatched
  • Performance Analysisunmatched
  • Policy Developmentunmatched
  • Presentation/Verbal Skillsunmatched
  • Privacy Regulationsunmatched
  • Problem Solving Skillsunmatched
  • Production Systemsunmatched
  • REST (Representational State Transfer)unmatched
  • Reconciliationunmatched
  • Regulationsunmatched
  • Regulatory Complianceunmatched
  • Relational Databases (RDBMS)unmatched
  • Reporting Dashboardsunmatched
  • Risk Managementunmatched
  • Root Cause Analysisunmatched
  • SAP ECC (fka SAP R/3 and SAP ERP)unmatched
  • SQL (Structured Query Language)unmatched
  • SQL Databasesunmatched
  • Sarbanes-Oxley Act (SOX)unmatched
  • Security Architectureunmatched
  • Security Assertion Markup Language (SAML)unmatched
  • Security Complianceunmatched
  • Security Designunmatched
  • Service Level Agreement (SLA)unmatched
  • Siebelunmatched
  • Single Sign-On (SSO)unmatched
  • Systems Administration/Managementunmatched
  • Technical Leadershipunmatched
  • User Interface/Experience (UI/UX)unmatched
  • Wormsunmatched
  • Writing Skillsunmatched

Level up your application

Professional resume templates

Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

Free resume templates

Resume Builder

Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

Resume Builder