Data Migration Lead | Power Retail

Everforth Apex
Houston, TX, United States
2 days ago
Apply on www.dice.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Working hours
Regular working hours
Job source

Tech stack

Amazon Web Services Amazon S3 Business Analytics Applications Data Analysis Cloud Database Databases Data Validation Data Cleansing Data Integration Extract Transform Load (ETL) Data Migration Database Queries
+10 more
PostgreSQL Microsoft SQL Server SQL Azure Operational Databases Power BI Data Ingestion Database Migration AWS Glue Operational Systems Databricks

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.

Apply on www.dice.com
Prepare application

Good distractions

Loading talks and stories from around this role…