Senior Data Migration Engineer, Azure & Dataverse

Main Digital

United States

Remote

USD 120,000 - 170,000

Full time

5 hours ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Main Digital is seeking a Senior Data Migration Engineer to lead the technical execution of a complex data migration, enabling IBM BPM and DB2 decommissioning. This hands-on consulting role requires ownership of migration design, delivery, and cross‑team collaboration in a client-facing setting.

You will analyze legacy data, build and validate pipelines, and drive production readiness and stabilization. Strong Azure Data Factory and DB2 skills are essential, with experience in Dataverse/Dynamics

Qualifications

  • Strong hands-on experience extracting and analyzing IBM DB2 data using SQL.
  • Demonstrated experience parsing XML and transforming nested or semi-structured source data into structured staging tables or files.
  • Strong experience designing, developing, deploying, and troubleshooting Azure Data Factory (ADF) pipelines.
  • Experience using Azure SQL and/or Azure Blob Storage as part of staging and migration architectures.
  • Hands-on experience migrating data into Microsoft Dataverse/Dynamics 365, including data loading, deployment, troubleshooting, and production support.
  • Experience defining detailed source-to-target mappings, including column mappings, data-type conversions, transformation rules, keys, relationships, and load sequencing.
  • Demonstrated experience with migration testing, data validation, reconciliation, and data-quality issue resolution.
  • Experience supporting production cutovers, go-live activities, troubleshooting, and post-production stabilization.

Responsibilities

  • Analyze DB2 source data, database structures, and XML content to determine extraction requirements and develop reliable extraction logic.
  • Partner with application teams to investigate and resolve source-data questions, inconsistencies, and undocumented data behaviors.
  • Transform XML and other source data into structured staging tables or files, including handling nested structures, data-type conversions, inconsistent source values, and other data-quality complexities.
  • Design, build, deploy, monitor, and troubleshoot Azure Data Factory pipelines using Azure SQL and/or Azure Blob Storage for staging and Microsoft Dataverse for target loading.
  • Work with target-solution owners to develop and document source-to-target column mappings, transformation rules, keys, entity relationships, dependencies, and load sequencing.
  • Establish validation and reconciliation processes to confirm migration completeness and accuracy.
  • Investigate missing records, failed loads, mapping discrepancies, reconciliation differences, and data-quality issues and drive them through resolution.
  • Execute migration testing across lower environments and coordinate the approved use of appropriately masked production data when production-representative test data is required.
  • Validate migration results and resolve defects before production deployment.
  • Support production migration planning, cutover readiness, go-live execution, reconciliation, troubleshooting, and post-go-live stabilization.
  • Coordinate technical dependencies including environment readiness, service principal permissions, Azure Key Vault access, connectivity, and prerequisites for pipelines.
  • Collaborate across teams to resolve migration design decisions and technical dependencies.
  • Create and maintain migration mappings, technical documentation, validation procedures, and repeatable migration processes.
  • Proactively communicate migration risks, blockers, dependencies, data-quality concerns, and recommended solutions to Main Digital and client stakeholders.

Skills

IBM DB2 data extraction
XML parsing and data transformation
Azure Data Factory pipelines
Azure SQL / Azure Blob Storage
Dataverse / Dynamics 365 data loads
Source-to-target mapping design
Migration testing & data validation
Production cutovers & go-live support
Azure Key Vault & service principal
Cross‑team collaboration & client‑faci

Tools

Azure Data Factory
Azure SQL
Azure Blob Storage
Dataverse/Dynamics 365

Job description

Main Digital is seeking a Senior Data Migration Engineer to lead the technical execution of a complex data migration supporting a client's IBM BPM and DB2 decommissioning initiative. This is a hands‑on consulting role for an experienced data engineer who can take ownership of migration design and delivery while working effectively across client application, business, and platform teams.

WHAT YOU’LL DO:

Reporting to our Delivery Operations Manager, as a Full‑Time Specialist on our team, you will work remotely, and serve as a hands‑on technical owner for data migration activities across the client engagement. You will work directly with client and consulting teams to analyze legacy data, establish migration designs, build and deploy pipelines, validate migrated information, and resolve issues through production stabilization.

You will be expected to operate independently, bring structure to areas where requirements or designs are still evolving, and translate migration requirements into technically sound, executable solutions. Success in this role requires strong engineering depth as well as the ability to communicate clearly with technical and non‑technical stakeholders in a client‑facing consulting environment.

QUALIFICATIONS:
  • Strong hands‑on experience extracting and analyzing IBM DB2 data using SQL.
  • Demonstrated experience parsing XML and transforming nested or semi‑structured source data into structured staging tables or files.
  • Strong experience designing, developing, deploying, and troubleshooting Azure Data Factory (ADF) pipelines.
  • Experience using Azure SQL and/or Azure Blob Storage as part of staging and migration architectures.
  • Hands‑on experience migrating data into Microsoft Dataverse/Dynamics 365, including data loading, deployment, troubleshooting, and production support.
  • Experience defining detailed source‑to‑target mappings, including column mappings, data‑type conversions, transformation rules, keys, relationships, and load sequencing.
  • Demonstrated experience with migration testing, data validation, reconciliation, and data‑quality issue resolution.
  • Experience supporting production cutovers, go‑live activities, troubleshooting, and post‑production stabilization.
  • Familiarity with service principal authentication and Azure Key Vault access within Azure‑based data solutions.
  • Experience working with appropriately masked production data through approved processes for migration and lower‑environment testing.
  • Ability to independently work through incomplete or evolving requirements, identify unresolved technical decisions, and drive those decisions to resolution across multiple teams.
  • Strong client‑facing communication and collaboration skills, with the ability to explain technical migration issues, risks, dependencies, and recommendations clearly.
  • IBM BPM experience is helpful but not required.
RESPONSIBILITIES:
  • Analyze DB2 source data, database structures, and XML content to determine extraction requirements and develop reliable extraction logic.
  • Partner with application teams to investigate and resolve source‑data questions, inconsistencies, and undocumented data behaviors.
  • Transform XML and other source data into structured staging tables or files, including handling nested structures, data‑type conversions, inconsistent source values, and other data‑quality complexities.
  • Design, build, deploy, monitor, and troubleshoot Azure Data Factory pipelines using Azure SQL and/or Azure Blob Storage for staging and Microsoft Dataverse for target loading.
  • Work with target‑solution owners to develop and document source‑to‑target column mappings, transformation rules, keys, entity relationships, dependencies, and load sequencing.
  • Establish validation and reconciliation processes to confirm migration completeness and accuracy.
  • Investigate missing records, failed loads, mapping discrepancies, reconciliation differences, and data‑quality issues and drive them through resolution.
  • Execute migration testing across lower environments and coordinate the approved use of appropriately masked production data when production‑representative test data is required.
  • Validate migration results and resolve defects before production deployment.
  • Support production migration planning, cutover readiness, go‑live execution, reconciliation, troubleshooting, and post‑go‑live stabilization.
  • Coordinate technical dependencies including environment readiness, service principal permissions, Azure Key Vault access, connectivity, and other prerequisites required to execute migration pipelines successfully.
  • Collaborate across application, business, data, and platform teams to resolve migration design decisions and technical dependencies.
  • Support solutions that preserve historical data and enable continued access when full migration into the target application is not required.
  • Create and maintain migration mappings, technical documentation, validation procedures, runbooks, and repeatable migration processes throughout the engagement.
  • Proactively communicate migration risks, blockers, dependencies, data‑quality concerns, and recommended solutions to Main Digital and client stakeholders.
WHAT WE OFFER:

Celebrated by Inc. 5000 for our rapid growth and award‑winning workplace, Main Digital invites you to join our collaborative and forward‑thinking team. As a Certified Women‑Owned Small Business (WOSB), we champion diversity in tech. Our diverse teams combine management consulting expertise, innovative digital design, and advanced product engineering. Driven by our six core values, we lead in intelligent automation, platform technologies, and Agile methodologies to create unparalleled digital experiences. Join us as we empower people to create new possibilities through process and technology, re‑imagining the ways of work and enhancing experiences with digital transformation.

Main Digital is committed to the principles of equal employment. We are committed to complying with all federal, state, and local laws providing equal employment opportunities, and all other employment laws and regulations. It is our intent to maintain a work environment that is free of harassment, discrimination, or retaliation because of age, race, color, national origin, ancestry, religion, sex, sexual orientation (including transgender status, gender identity or expression), pregnancy (including childbirth, lactation, and related medical conditions), reproductive health decisions, marital status, personal appearance, matriculation, political affiliation, credit information, employment status, physical or mental disability, genetic information (including testing and characteristics), veteran status, uniformed servicemember status, status as a victim or family member of a victim of domestic violence, a sexual offense, or stalking, homeless status, or any other status protected by federal, state, or local laws.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Remote Azure Data Migration Engineer: Dataverse & DB2
Remote Azure Data Migration Engineer: Dataverse & DB2

Main Digital • United States

Remote
USD 120,000 - 170,000
Data Migration Lead
Data Migration Lead

Procentrix • Washington

On-site
USD 150,000 - 170,000
Full time
Full time

Main Digital LLC • McLean (VA)

On-site
USD 180,000 - 280,000
Staff Data Engineer, Core Migrations
Staff Data Engineer, Core Migrations

Rawlings Company • United States

Remote
USD 230,000 - 260,000
Remote-friendly
Medical, dental, vision
Flexible environment
+2
VP, Solutions Architecture & Delivery (Platforms-Based Solutions)
VP, Solutions Architecture & Delivery (Platforms-Based Solutions)

Main Digital • McLean (VA)

Hybrid
USD 250,000 - 350,000
Application Integration, SME
Application Integration, SME

Cayuse Holdings • Washington

On-site
USD 120,000 - 160,000
Medical, Dental and Vision Insurance
Flexible Spending Accounts
Short-Term and Long-Term Disability
+3
Application Engineer
Application Engineer

Gridiron IT • Washington

On-site
USD 150,000 - 160,000
Medical insurance
Dental insurance
Vision insurance
+4
Senior Data Engineer / Data Architect | Hybrid | Camp Murray, WA | Contingent
Senior Data Engineer / Data Architect | Hybrid | Camp Murray, WA | Contingent

Ares Enterprise • Washington

Hybrid
USD 120,000 - 180,000
Dataverse Data Architect
Dataverse Data Architect

LMI Consulting, LLC • Washington

On-site
USD 109,000 - 160,000
Data Migration Specialist
Data Migration Specialist

Pi Square Technologies • United States

Remote
USD 90,000 - 130,000