Enterprise Data Migration Architect

About the Role

We are looking for an Enterprise Data Migration Architect with deep, hands-on expertise in large-scale data migrations and modern cloud data platforms. This is a senior technical leadership role within our Insurance P&C data transformation program, responsible for architecting and owning the end-to-end migration of legacy data systems to a modern cloud-native ecosystem on AWS.

You will work at the intersection of architecture, delivery, and governance — defining migration strategies, leading technical execution, and driving outcomes that directly impact business operations. This is a production delivery role, not advisory or POC-only.

What You Will Do

Data Migration Architecture & Leadership

• Own end-to-end design and execution of enterprise data migrations from legacy platforms (Oracle, SQL Server, DB2, AS400/Mainframe, PostgreSQL, MySQL) to modern cloud targets on AWS

• Define and govern migration strategy including data mapping, transformation logic, reconciliation frameworks, cutover planning, rollback procedures, and performance tuning

• Lead large-scale incremental and CDC-based migration pipelines ensuring zero-loss data fidelity

• Drive validation, quality assurance, and sign-off processes across source and target systems

Cloud Data Platform & Architecture

• Design and implement scalable data architectures on AWS — leveraging Databricks or Snowflake as the primary analytical platform

• Build and optimize ETL/ELT pipelines using AWS-native services: S3, Glue, DMS, Lambda, Redshift, EMR

• Architect Lakehouse, Data Vault, Star Schema, and Dimensional models aligned to Insurance P&C business domains

• Optimize Spark workloads for cost, performance, and reliability in production environments

Governance, Observability & Security

• Implement data lineage, observability, and data quality frameworks throughout the migration lifecycle

• Define and enforce data security, access controls, and compliance standards aligned with Insurance regulatory requirements

• Drive cloud cost optimization strategies across data services

Stakeholder Management & Delivery Governance

• Partner with business, product, and engineering stakeholders to define scope, priorities, and delivery milestones

• Communicate architecture decisions, risks, and migration status to senior leadership and client stakeholders

• Lead and mentor cross-functional engineering teams through complex delivery programs

Non-Negotiable Requirements

Candidates must demonstrate all of the following to be considered.

Area Requirement

Experience 10+ years in enterprise data architecture and large-scale data migration programs

Vertical Insurance P&C domain experience — mandatory

Migration Depth Proven E2E migrations: mapping, reconciliation, validation, cutover, rollback, and performance tuning

Modern Platform Strong hands-on expertise in Databricks or Snowflake

Cloud Strong exposure to Amazon Web Services and its database/analytics services

Production Delivery Real production migration experience — not only POC or support roles

Technical Skills

Languages & Frameworks

• Strong SQL, Python or Scala, PySpark

• Spark optimization for production-scale workloads

ETL/ELT & Pipelines

• AWS Glue, ADF, Informatica, dbt, or equivalent

• CDC / incremental load patterns, reconciliation and validation frameworks

AWS Services

• S3, Glue, DMS, Lambda, Redshift, EMR — hands-on experience preferred

Legacy Databases

• Oracle, SQL Server, DB2, PostgreSQL, MySQL — working knowledge required

• AS400 / Mainframe familiarity preferred

Data Architecture Patterns

• Star Schema, Dimensional Modeling, Data Vault

• Lakehouse / Medallion Architecture

• Cutover planning, rollback strategy, data validation at scale

Governance & Security

• Data lineage, metadata management, observability tooling

• Cloud cost optimization, security controls, and access governance

Nice to Have

• Experience with Purview, Collibra, or equivalent data catalog / governance tooling

• Familiarity with Insurance regulatory data requirements (IRDAI or equivalent)

• CI/CD and DataOps practices — Azure DevOps, Jenkins, or similar

Why This Role

• Lead one of the largest Insurance P&C data transformation programs in the region

• Work with a modern tech stack — Databricks, Snowflake, AWS — at enterprise scale

• Direct influence over architecture decisions from day one

• Collaborative, delivery-focused culture with senior engineering and business stakeholders

• AS400/Mainframe migration experience.
• Informatica, dbt, ADF experience.
• Purview, Collibra, or other Data Governance tools.
• Insurance regulatory compliance knowledge (IRDAI or equivalent).
• CI/CD and DataOps experience (Azure DevOps, Jenkins).
• Experience managing large transformation programs across multiple business units.