Hybrid Data Migration Analyst: Data Mapping & Quality

Mi-Case; Northern (KY); Hybrid; USD 110,000 - 120,000; Full time

Job summary

Mi-Case is seeking a Data Analyst to map legacy data to Mi-Case requirements and develop conversion rules, with thorough documentation of data transformation steps. The role requires clear communication with the Project Manager, SMEs, developers, and QA to ensure data quality during migration.

Key duties include collaborating with application developers and SMEs to gather requirements, analyzing data structures, tracking progress, and resolving migration issues.

Qualifications

• Bachelor’s degree in Computer Science, Information Technology, or related field.
• 4+ years of data analysis or related field with data migration focus.
• Proficient in SQL and database querying for extraction and validation.
• Excellent communication and cross-functional collaboration.
• Experience with data migration tools and methodologies (preferred).

Responsibilities

• Collaborate with Mi-Case Application Developers, Legacy System SMEs, and stakeholders to gather, document, and analyze data migration requirements.
• Analyze and map data structures from legacy systems to target platforms, making certain that data mapping specifications and transformation rules are precise.
• Document the steps for data transformation, cleansing, and validation to uphold high standards of data quality and integrity.
• Track migration requirements, mapping rules, and progress through tools like DevOps, keeping stakeholders fully informed.
• Serve as the main point of contact for clients regarding data migration queries, delivering clear and consistent communication to manage expectations and keep the process aligned.
• Log migration errors and any records that weren’t transferred, and investigate these issues to resolve them for future migration runs.
• Offer ongoing support to Project Managers, SMEs, developers, data engineers, and quality analysts by regularly communicating migration progress, updates, and troubleshooting any issues that arise.

Skills

SQL

Data migration

Data analysis

Communication skills

Project coordination

Detail-oriented

Cross-functional teamwork

Education

Bachelor's degree in Computer Science/Information Technology

Tools

ETL Tools

Job description

Mi-Case is seeking a Data Analyst to map legacy data to Mi-Case requirements and develop conversion rules, with thorough documentation of data transformation steps. The role requires clear communication with the Project Manager, SMEs, developers, and QA to ensure data quality during migration.

Key duties include collaborating with application developers and SMEs to gather requirements, analyzing data structures, tracking progress, and resolving migration issues.