Data Archival & Application Decommissioning Consultant

Job Title: Data Archival & Application Decommissioning Consultant

Location: Carmel, IN

Work Arrangement: Remote

Employment Type: Contract

Duration: 12 months

Domain: IT Services

Pay Rate: $60.00/hr W2 | $75.00/hr C2C

Application Deadline: Nov 15th 2026

SKILLS REQUIRED

Primary (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 OVERVIEW

The 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.

BENEFITS

Medical | Dental | Vision | 401(k)

EEOC Compliance:

We are an equal opportunity employer, and all qualified applicants will receive consideration for employment.

DISCLAIMER

AI Usage Policy: Pacer Group uses AI to assist in screening applications. Final hiring decisions are made by human recruiters based on qualifications and experience.