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