Senior Data Archival Consutlant

Job Title: Senior Data Archival Architect / Lead

Location : Remote

Note: Strong fundamentals in data archival, ETL, and lakehouse/data-platform architecture are essential, Data, Cloud & Integration

Job Description:

• Bachelor's degree or Master’s Degree in Computer science, or a related field, with a minimum of 10+ years of experience.
• 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
• Excellent communication and collaboration skills