Data Migration Lead | Power Retail
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Role details
Tech stack
+10 more
Job description
We are seeking an experienced Data Migration Lead to help lead a large-scale cloud database modernization initiative involving the migration of transactional and analytical data workloads into AWS.
This is a hands-on technical leadership role for someone who has personally led an enterprise database migration from discovery through production cutover and stabilization. You will help define the migration approach, establish repeatable processes, guide Data Engineers through execution, and remain directly involved in solving complex migration and data challenges.
The environment is actively being built, so this is an opportunity to help shape how the migration is executed rather than simply maintaining an established platform. The ideal candidate is comfortable operating with ambiguity, making technical recommendations, and improving existing approaches when a better solution is available.
The role is expected to be approximately 50% hands-on technical execution and 50% technical leadership. What You’ll Do
- Lead the end-to-end execution of large-scale database and data migration initiatives.
- Develop and continuously improve migration runbooks, playbooks, standards, and repeatable processes.
- Plan and lead mock migrations, production migrations, validation, cutover, and post-migration stabilization.
- Provide day-to-day technical direction and oversight to Data Engineers performing migration work.
- Review and validate migration designs, engineering approaches, and implementation work.
- Define how migrations will be prepared, executed, validated, troubleshot, and transitioned into production.
- Identify migration risks, architectural issues, data-quality concerns, and technical dependencies before they impact production.
- Participate in architecture and design discussions and provide recommendations based on previous migration experience.
- Work across transactional and analytical data environments, ensuring data moves reliably between operational systems and downstream analytics platforms.
- Support data cleansing, transformation, reconciliation, and source-to-target validation.
- Help establish best practices as the new AWS-based environment continues to evolve., This role will also work closely with an analytical environment built around Databricks. Candidates should understand:
- Data ingestion into Databricks
- Data cleansing and transformation
- Data modeling within a Medallion Architecture
- Movement of data between transactional databases and analytical platforms
- Large-scale analytical and compute workloads
- Downstream reporting and consumption through tools such as Power BI
Preferred AWS Technology Experience
Experience with several of the following is highly desirable:
- Amazon Aurora PostgreSQL
- AWS Database Migration Service (DMS)
- AWS Schema Conversion Tool (SCT)
- AWS Glue
- Amazon S3
- AWS-based data integration and migration patterns
Direct experience leading a SQL Server/Azure SQL Amazon Aurora PostgreSQL migration would be especially valuable. What Will Make You Successful
The strongest candidate will be able to speak directly to a major migration they personally led and explain:
How they assessed the existing environment, designed the migration, converted schemas, moved and cleansed data, conducted mock migrations, validated results, managed cutover, resolved production issues, and stabilized the new environment.
We’re looking for someone who has done this work end to end, not simply managed a team responsible for it. Why This Opportunity
This is an opportunity to join a growing cloud data modernization initiative at a formative stage. You’ll work across AWS, Aurora PostgreSQL, Databricks, SQL Server/Azure SQL, and Power BI while helping establish the migration standards and architecture that the broader environment will follow.
For someone who enjoys both technical problem-solving and technical leadership, this role offers the chance to remain hands-on while having significant influence over how a large-scale migration is executed.
Requirements
- Significant experience leading enterprise-scale database migration or modernization programs.
- Demonstrated ownership of migrations through the full lifecycle, including:
- Discovery and current-state assessment
- Migration architecture and design
- Schema conversion
- Source-to-target mapping
- Data movement and transformation
- Mock migrations
- Data validation and reconciliation
- Production cutover
- Troubleshooting and stabilization
- Strong hands-on experience with AWS data and database technologies.
- Strong understanding of transactional/operational databases and how they differ from analytical data platforms.
- Experience migrating data from SQL Server and/or Azure SQL into PostgreSQL-based environments.
- Hands-on experience with data cleansing, transformation, and data-quality validation.
- Strong SQL skills and the ability to troubleshoot migration issues directly rather than relying solely on engineering teams.
- Ability to lead engineers while remaining comfortable working directly in the technical details.
About the company
Everforth Apex is a world-class IT services company that serves thousands of clients across the globe. When you join Everforth Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRateds Best of Staffing in Talent Satisfaction in the United States and Great Place to Work in the United Kingdom and Mexico.
Everforth Apex uses a virtual recruiter as part of the application process. Click for more details. By applying for this job, you agree to receive calls, AI-generated calls, text messages, or emails from Everforth Apex and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You can access our privacy policy at, UnitedHealthcare creates and publishes the Transparency in Coverage Machine-Readable Files on behalf of Everforth Apex Systems.
Apply for this position
This job is hosted externally. Click below to view the full posting and apply.
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Loading talks and stories from around this role…