Data Migration Lead

Role: Data Migration Lead / Data Migration Specialist

Location: Helena, MT – Mostly remote with few onsite meeting expected

Duration: 12-18 months

Position Summary
The Data Migration Lead will plan, design, coordinate, and validate the migration of legacy MBOH data to the selected enterprise software solution(s). This position will be responsible for data discovery, mapping, cleansing, transformation, migration, reconciliation, governance, and data-quality activities.

Key Responsibilities

• Perform a comprehensive inventory and assessment of legacy data sources.
• Profile legacy data to identify quality issues, inconsistencies, duplicates, missing information, and transformation requirements.
• Develop detailed source-to-target data mapping specifications.
• Define field-level mappings, transformation rules, validation rules, and business rules.
• Establish data-quality standards, governance processes, reconciliation procedures, and migration controls.
• Develop and execute the overall data migration strategy and detailed migration plan.
• Coordinate data extraction, cleansing, transformation, and loading (ETL) activities.
• Work with business SMEs and software vendors to validate mapping and transformation requirements.
• Plan and execute trial/mock migrations.
• Reconcile migration results and validate data accuracy, completeness, and integrity.
• Identify, track, and resolve migration defects and data-quality issues.
• Support final production migration, cutover, reconciliation, and post-migration validation.
• Develop and maintain data lineage, migration audit trails, reconciliation results, and migration documentation.

Required/Preferred Qualifications

• 5+ years of experience with enterprise data migration, conversion, or integration initiatives.
• Strong experience with source-to-target mapping, ETL processes, data cleansing, transformation, validation, and reconciliation.
• Experience conducting multiple mock/trial migrations before production cutover.
• Strong SQL and data-analysis skills.
• Understanding of data governance, data quality, lineage, controls, and auditability.
• Experience migrating data from legacy platforms into modern enterprise systems.
• Experience with regulated/public-sector or financial data preferred.