Enterprise Data Migration Architect

Role description

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

Skills

About RCG Global Services
At Myridius, we transform the way businesses operate. Formerly known as RCG Global Services, our more than 50 years of expertise now drive a new vision—propelling organizations through the rapidly evolving landscapes of technology and business. We offer tailored solutions in AI, data analytics, digital engineering, and cloud innovation, addressing the unique challenges each industry faces. Our integration of cutting-edge technology with deep domain knowledge enables businesses to seize new opportunities, drive significant growth, and maintain a competitive edge in the global market. Our commitment is not just to meet expectations but to exceed them, ensuring measurable impact and fostering sustainable innovation. The success of Myridius is directly tied to the breakthroughs achieved by our clients. Together, we co-create solutions that not only solve today’s challenges but also anticipate future trends. At Myridius, we go beyond typical service delivery. We craft transformative outcomes that help businesses not just adapt, but thrive in a world of continuous change. Discover how Myridius can elevate your business to new heights of innovation. Visit us at www.myridius.com and start leading the change.