AWS Data Migration Lead

Transcend Softech LLC; St. Louis (MO); On-site; USD 120,000 - 160,000; Full time

Job summary

Transcend Softech LLC is seeking a Data Migration Development Lead to drive large-scale data migration solutions on AWS. This onsite, long-term contract role combines hands-on technical leadership with migration architecture, data engineering, QA, and production cutover execution.

You will design, build, and optimize end-to-end data migrations using AWS services and modern data frameworks, mentoring teams and coordinating with stakeholders for successful migration outcomes.

Qualifications

• 8+ years in data engineering, ETL/ELT, or data migration.
• 3+ years leading technical teams or migration workstreams.
• Strong expertise in AWS services, Python, SQL, and PySpark.

Responsibilities

• Lead end-to-end data migration design, development, and implementation.
• Build scalable ETL/ELT and migration frameworks using AWS services.
• Design data extraction, transformation, cleansing, validation, loading, and reconciliation.
• Develop high-volume migration pipelines with AWS Glue, S3, Lambda, Step Functions, DMS, Redshift, and RDS/Aurora.
• Establish CI/CD pipelines and Infrastructure as Code using Terraform, CloudFormation, or AWS CDK.
• Lead code reviews, technical design reviews, and mentor migration developers.

Skills

AWS services

Python

SQL

PySpark

ETL/ELT

Data migration

Agile delivery

Tools

Terraform

CloudFormation

AWS CDK

Job description

Location: St Louis, MO (Onsite)

Long Term Contract

Job Description: Data Migration Development Lead (AWS) - CPQ Data migration

Unable to provide sponsorship for this role

We are seeking a Data Migration Development Lead to drive the design, development, and delivery of large-scale data migration solutions using the AWS platform. This role combines hands-on technical leadership with responsibility for migration architecture, data engineering, quality assurance, and production cutover execution.

Key Responsibilities

• Lead end-to-end data migration design, development, and implementation.
• Build scalable ETL/ELT and migration frameworks using AWS services.
• Design data extraction, transformation, cleansing, validation, loading, and reconciliation processes.
• Develop high-volume migration pipelines using AWS Glue, S3, Lambda, Step Functions, DMS, Redshift, and RDS/Aurora.
• Implement automated data quality, audit, reconciliation, and monitoring controls.
• Support multiple migration cycles including testing, mock conversions, and production cutovers.
• Develop migration runbooks, restart/recovery procedures, and operational controls.
• Establish CI/CD pipelines and Infrastructure as Code using Terraform, CloudFormation, or AWS CDK.
• Lead code reviews, technical design reviews, and mentor migration developers.
• Collaborate with architects, business stakeholders, and application teams to ensure successful migration outcomes.

Required Qualifications

• 8+ years of experience in data engineering, ETL/ELT, or data migration.
• 3+ years of experience leading technical teams or migration workstreams.
• Strong expertise in AWS services, Python, SQL, and PySpark.
• Experience with data quality frameworks, reconciliation, and large-scale production migrations.
• Strong knowledge of relational databases, data modeling, and performance optimization.
• Experience in Agile delivery environments with strong troubleshooting and analytical skills.