Data Archival & Application Decommissioning Consultant

Job Title: Data Archival & Application Decommissioning ConsultantLocation: Carmel, INWork Arrangement: RemoteEmployment Type: ContractDuration: 12 monthsDomain: IT ServicesPay Rate: $60.00/hr W2 | $75.00/hr C2CApplication Deadline: Nov 15th 2026SKILLS REQUIREDPrimary (Must-Have):• Enterprise Data Archival & Application Decommissioning• Architecture & Design (Warm Archive, Cold Archive, Data Bunker)• ETL / ELT Pipeline Design & Relational Databases (DB2, Oracle, SQL Server)• Cloud Storage & Lifecycle Management (Azure ADLS Gen2, AWS S3)• Data Retention, Governance & Compliance (WORM, Legal Hold, GLBA, SOX, HIPAA)Secondary (Good to Have):• Platform 3 (Archon) Suite (ADS, Native ETL, Analyzer, Data Bunker)• Legacy Source Systems (Mainframe AS/400, SAP ECC, PeopleSoft)• Distributed Query Engine (Trino, Spark)• Insurance Domain Experience (Life & Annuity, Closed-Block Administration)POSITION OVERVIEWThe Lead Enterprise Data Archival Architect will join the Enterprise Data & Architecture department, reporting to the Director of Data Infrastructure. The selected candidate will lead the design, implementation, and execution of end-to-end data archival solutions on Platform 3 (Archon). In this role, you will solve critical enterprise challenges around legacy data risk, regulatory compliance, and storage cost optimization by establishing warm/cold archival tiers, defining retention and legal hold rules, and managing secure application decommissioning across production and non-production environments.ROLES & RESPONSIBILITIES• Define end-to-end data archival architectures, including data store design, ETL pipelines, and source-system discovery across production and non-production tiers.• Design and oversee the build of native archival ETL pipelines to drive extraction, transformation, indexing, and load operations from legacy source systems into warm and cold storage tiers.• Translate business retention, legal-hold, and regulatory compliance requirements into platform-enforced data classification, de-identification, and WORM-compliant storage rules.• Lead source-system connectivity, schema discovery, data validation, volumetric verification, and final reconciliation for application decommissioning.• Partner with cross-functional IT, Security, DBA, and Compliance teams to deliver design artifacts, develop monitoring dashboards, and manage operational handover.BENEFITSMedical | Dental | Vision | 401(k)EEOC Compliance:We are an equal opportunity employer, and all qualified applicants will receive consideration for employment.DISCLAIMERAI Usage Policy: Pacer Group uses AI to assist in screening applications. Final hiring decisions are made by human recruiters based on qualifications and experience.