JOB-ID-910667 Data, AI & Analytics Engineering

Enterprise Data Migration Architect

Apply Now
Back to all jobs

The Opportunity

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

What you'll do

  • Architect and lead enterprise-wide data migration programs from Oracle, SQL Server, DB2, AS400/Mainframe, PostgreSQL, and MySQL to AWS.
  • Define migration strategies including data mapping, transformation, reconciliation, validation, cutover, and rollback planning.
  • Design cloud-native data platforms using AWS, Databricks, and Snowflake.
  • Build and optimize ETL/ELT pipelines using AWS Glue, DMS, Lambda, Redshift, EMR, and Spark.
  • Implement data quality, lineage, governance, observability, and security frameworks.
  • Lead technical teams and collaborate with business stakeholders to ensure successful migration delivery.
  • Drive performance optimization, cost efficiency, and compliance within insurance data environments.

What you'll bring

  • Deep expertise in enterprise data architecture and cloud data transformation.
  • Proven ability to lead complex data migration programs from strategy through production deployment.
  • Strong hands-on experience with Databricks, Snowflake, AWS, Spark, and large-scale data processing.
  • Strong stakeholder management and technical leadership capabilities.
  • Experience working in highly regulated Insurance P&C environments.
  • Ability to mentor engineering teams and influence architecture decisions at enterprise level.

AI Fluency Expected

At Myridius, we expect AI fluency across all roles. This means the ability to effectively and responsibly use AI-enabled tools to improve productivity, quality, analysis, decision-making, documentation, testing, delivery, and problem-solving within one's function. All candidates should be comfortable working with AI as a day-to-day enabler while applying sound judgment, critical thinking, and accountability for outcomes.

Good to Have

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

Non-Negotiable Skills

Domain & Experience

  • 10+ years of enterprise data architecture and data migration experience.
  • Mandatory Insurance P&C domain experience.
  • Proven end-to-end migration delivery experience.
  • Production migration experience (not limited to PoCs or support roles).

Cloud & Data Platforms

  • AWS (S3, Glue, DMS, Lambda, Redshift, EMR).
  • Databricks and/or Snowflake expertise.
  • Modern cloud data architecture and Lakehouse implementation.

Data Migration

  • Data Mapping & Transformation.
  • CDC (Change Data Capture) and Incremental Loads.
  • Data Reconciliation & Validation Frameworks.
  • Cutover & Rollback Planning.
  • Performance Tuning and Optimization.

Technical Skills

  • Strong SQL.
  • Python or Scala.
  • PySpark and Spark Optimization.
  • ETL/ELT development.

Data Modeling

  • Star Schema.
  • Dimensional Modeling.
  • Data Vault.
  • Lakehouse / Medallion Architecture.

Governance & Security

  • Data Lineage & Metadata Management.
  • Data Quality & Observability.
  • Security Controls & Access Governance.
  • Cloud Cost Optimization.

Ready to make an impact?

Submit your application today and join the Myridius team.

Apply for this Position