Senior Data Migration & Validation Analyst

MWCIA - Minnesota Workers Compensation Insurers Association, Inc.

Minneapolis (MN)

On-site

USD 90,000 - 130,000

Full time

7 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

MWCIA - Minnesota Workers Compensation Insurers Association, Inc. seeks a Senior Data Migration & Validation Analyst to ensure data integrity as we migrate from legacy systems to Voyageur.

You will perform hands-on validation, reconciliation, and data-quality analysis across complex data sets. You’ll develop advanced SQL queries, validate source-to-target mappings, and build repeatable reconciliation processes while collaborating with business and IT teams to minimize migration risk and support

Qualifications

  • Bachelor’s degree or equivalent with hands-on data migration experience.
  • Advanced SQL development and database analysis experience.
  • Experience with relational databases, data modeling, reconciliation, and data quality.
  • Ability to investigate and resolve complex technical data issues independently.

Responsibilities

  • Independently execute end-to-end validation and reconciliation of data migrating from legacy systems into Voyageur.
  • Profile source data to identify inconsistencies, gaps, anomalies, and potential migration risks.
  • Validate source-to-target data mappings, transformations, and business rules.
  • Develop, execute, troubleshoot, and optimize advanced SQL queries for data analysis, validation, and reconciliation.
  • Perform record-count reconciliation, automated field-level comparisons, and exception reporting.
  • Reconcile critical insurance data, including premium, loss, exposure, and payroll information.
  • Validate CST-to-UST transformations and related requirements.
  • Develop repeatable validation procedures and automated reconciliation solutions.
  • Support mock migrations, identify defects, and verify corrective actions.

Skills

Advanced SQL
Data validation
Data reconciliation
Problem solving
Communication

Education

Bachelor’s degree in CS/IT/Data Science

Tools

Azure Data Factory
Azure SQL
Git
Azure DevOps

Job description

AbouttheRole

TheSeniorDataMigration&ValidationAnalyst plays a critical role in ensuring the integrity, reliability, and readiness of business-critical data as MWCIA transitions from legacy Spectrum, MPS, and MUSR systems into Voyageur.

This position is responsible for hands‑on data validation, reconciliation, data‑quality analysis, technical troubleshooting, and migration readiness support throughout the project lifecycle.You’ll independently analyze complex data structures, develop advanced SQL queries, validate source-to-target mappings, investigate discrepancies, and develop repeatable reconciliation processes.

You’ll also work closely with business owners, technical teams, and project partners to translate findings into meaningful recommendations that support informed decisions and successful implementation. This is a highly hands‑on individual contributor position; not primarily a project management or coordination role. The successful candidate must be comfortable personally developing queries, analyzing database structures, reconciling data, investigating defects, and executing complex technical validation activities.

Your work will directly contribute to reducing migration risks, maintaining operational continuity, and building a reliable data foundation for MWCIA’s future.

KeyResponsibilities—WhatYou’llDo
DataMigration,Validation&Reconciliation
  • Independently execute end-to-end validation and reconciliation of data migrating from legacy systems into Voyageur.
  • Profile source data to identify inconsistencies, gaps, anomalies, and potential migration risks.
  • Validate source-to-target data mappings, transformations, and business rules.
  • Develop, execute, troubleshoot, and optimize advanced SQL queries for data analysis, validation, and reconciliation.
  • Perform record‑count reconciliation, automated field-level comparisons, and exception reporting.
  • Reconcile critical insurance data, including premium, loss, exposure, and payroll information.
  • Validate CST-to-UST transformations and related requirements.
  • Develop repeatable validation procedures and automated reconciliation solutions.
  • Support mock migrations, identify defects, and verify corrective actions.
DatabaseModeling&DataQuality
  • Create, interpret, and evaluate conceptual, logical, and physical entity‑relationship models.
  • Compare source and target database structure to identify mapping gaps, structural differences, and potential data‑integrity risks.
  • Identify modeling issues involving missing keys, ambiguous relationships, circular dependencies, and incorrectly assigned attributes.
  • Test referential integrity, duplicate keys, orphaned foreign keys, relationship cardinality, and missing required values.
  • Evaluate schema security models and applicable data‑access requirements.
  • Investigate data‑quality issues, identify root causes, and develop or recommend corrective solutions.
  • Collaborate with technical and business team storesolvedefects and perform regression testing.
  • Identify opportunities to improve data quality, validation efficiency, and long‑term reliability.
MigrationReadiness&ProductionSupport
  • Execute validation activities supporting migration readiness and production acceptance.
  • Evaluate reconciliation results, identify outstanding risks, and provide evidence‑based recommendations for go/no-go decisions.
  • Support production cutover validation, reconciliation, and signoff coordination.
  • Monitor data quality following implementation and assist with post‑production issue resolution.
  • Support legacy‑system decommissioning by validating data completeness, accuracy, and traceability.
  • Maintain requirements, technical documentation, validation evidence, testing results, operational runbooks, and audit records.
  • Partner with Data Services, IT, Quality Assurance, business owners, and external vendors to support successful project outcomes.
RequiredSkills&Capabilities—WhatYou’llBring

At MWCIA, we recognize that technical knowledge is important, but the ability to apply that knowledge effectively is what creates meaningful results.

We’re looking for someone who can demonstrate the following capabilities:

AdvancedSQL&DatabaseExpertise
  • Independently develop, troubleshoot, and optimize complex SQL queries to investigate data issues and deliver accurate validation results.
  • Design, develop, maintain, and optimize solutions within Microsoft SQL Server environments.
  • Interpret Oracle database structures and relational data models.
  • Evaluate complex database schemas, entity relationships, and structural dependencies.
  • Apply database normalization principles and sound data‑design practices to support integrity, scalability, and performance.
DataMigration,Validation&Reconciliation
  • Independently execute complex data migration, validation, and reconciliation activities.
  • Analyze source-to-target mappings, transformation logic, and business rules.
  • Develop and implement effective data‑quality checks, automated comparisons, and exception reporting.
  • Identify and resolve data discrepancies, completeness issues, and integrity concerns.
  • Evaluate whether migrated data is accurate, traceable, and suitable for operational and analytical use.
AnalyticalThinking&TechnicalProblem-Solving
  • Analyze complex data relationships and identify structural or logical inconsistencies.
  • Investigate technical issues, determine root causes, and develop effective solutions.
  • Apply sound judgment when evaluating data risks, validation evidence, and implementation readiness.
  • Balance technical accuracy, business requirements, and project priorities.
  • Demonstrate strong analytical reasoning, attention to detail, and accountability for technical results.
DataIntegration&DevelopmentPractices
  • Apply Azure Data Factory or comparable data‑integration technologies to support data movement, transformation, and automation.
  • Understand Azure SQL troubleshooting and diagnostic practices.
  • Apply software development life‑cycle principles and use tools such as Git and Azure DevOps.
  • Understand CI/CD practices and Agile or Scrum delivery methodologies.
  • Develop repeatable, efficient technical solutions that support consistency and reliability.
Communication&Collaboration
  • Communicate complex technical findings clearly to technical and non‑technical stakeholders.
  • Translate data structures, validation results, and reporting logic into understandable business information.
  • Collaborate effectively across technical teams, business functions, and external partners.
  • Proactively identify and communicate risks, dependencies, recommendations, and progress.
  • Seek feedback, share knowledge, and adapt to changing priorities.
  • Work independently while maintaining accountability to shared team and organizational goals.
Education&Experience
Required
  • Bachelor’s degree in Computer Science, Information Technology, Data Science, or a related discipline, or an equivalent combination of education and relevant professional experience.
  • Demonstrated hands‑on experience with complex data migration and validation.
  • Advanced SQL development and database analysis experience.
  • Experience working with relational databases, data modeling, data reconciliation, and data‑quality processes.
  • Demonstrated ability to investigate and resolve complex technical data issues independently.
Preferred
  • Experience working with complex, high‑volume, business‑critical datasets.
  • Experience supporting enterprise technology modernization, system conversions, or legacy‑system retirement.
  • Experience within insurance, workers’ compensation, financial services, or another data‑intensive industry.
  • Experienced developing automated validation and reconciliation solutions.

We recognize that valuable experience comes through different career paths. Candidates with equivalent qualifications and demonstrated technical capabilities are encouraged to apply.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Data Migration & Validation Specialist
Senior Data Migration & Validation Specialist

MWCIA - Minnesota Workers Compensation Insurers Association, Inc. • Minneapolis (MN)

On-site
USD 90,000 - 130,000
Manager Data Engineer
Manager Data Engineer

TechDigital Group • Detroit (MI)

On-site
USD 140,000 - 180,000
Data Architect - MSI
Data Architect - MSI

Baldwin • United States

Remote
USD 130,000 - 190,000
Business Systems Consultant (Data & Analytic Solutions)
Business Systems Consultant (Data & Analytic Solutions)

Mutual of Omaha • United States

Remote
USD 76,000 - 134,000
401(k) plan with company match
Senior Data Platform Engineer - Cloud, Data Vault & AI
Senior Data Platform Engineer - Cloud, Data Vault & AI

TechDigital Group • Detroit (MI)

On-site
USD 150,000 - 190,000
Data Migration Engineer
Data Migration Engineer

Applied Systems • United States

Remote
USD 60,000 - 90,000
Medical, dental, and vision coverage
Holiday and vacation time
Wellness days
+1
Data Migration Analyst
Data Migration Analyst

TechDigital Group • St. Louis (MO)

On-site
USD 80,000 - 110,000
Data Governance Analyst - USA
Data Governance Analyst - USA

tezo • Seattle (WA)

Remote
USD 110,000 - 170,000
Principal Data Engineer
Principal Data Engineer

TechDigital Group • Detroit (MI)

On-site
USD 150,000 - 190,000
Lead Data Test Engineer
Lead Data Test Engineer

Ampcus, Inc • Chantilly (VA)

On-site
USD 110,000 - 130,000