MWCIA - Minnesota Workers Compensation Insurers Association, Inc.

Senior Data Migration & Validation Analyst

MWCIA - Minnesota Workers Compensation Insurers Association, Inc. Minneapolis, Minnesota, United States

Insurance · 11-50 employees

6 d ago
Senior (5-10 yrs) Temporary United States
Create a free account to apply — email only, no card. You can also save this posting or score it against your profile with AI.

About the role

The analyst will execute end-to-end data migration, validation, and reconciliation from legacy systems to the Voyageur platform. They will also perform database modeling, investigate data quality issues, and provide evidence-based recommendations for migration readiness.

What they look for

SQL Data Migration Data Validation Data Reconciliation Database Modeling Microsoft SQL Server Oracle Azure Data Factory Data Quality Analysis Technical Troubleshooting Azure SQL Git Azure DevOps Agile Scrum Data Integration

Requirements

Candidates must have a bachelor's degree in a relevant field and extensive hands-on experience with complex data migration and SQL development. Strong analytical skills and the ability to independently troubleshoot database structures and data integrity issues are essential.

Full description

About the Role

The Senior Data Migration & Validation Analyst 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.

Key Responsibilities — What You'll Do

Data Migration, 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.

Database Modeling & Data Quality

  • Create, interpret, and evaluate conceptual, logical, and physical entity relationship models.
  • Compare source and target database structures 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 teams to resolve defects and perform regression testing.
  • Identify opportunities to improve data quality, validation efficiency, and long-term reliability.

Migration Readiness & Production Support

  • 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.

Required Skills & Capabilities — What You'll Bring

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:

Advanced SQL & Database Expertise

  • 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.

Data Migration, 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.

Analytical Thinking & Technical Problem-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.

Data Integration & Development Practices

  • 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 lifecycle 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 nontechnical 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.
  • Experience 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.