Data Migration Analyst

Amtis Professional Ltd; Birmingham; Hybrid; GBP 54,000 - 66,000; Full time

Job summary

Amtis Professional Ltd is seeking a Data Migration Analyst in the West Midlands on a hybrid basis. The role supports a programme of complex data migration and integration activities with responsibilities spanning end-to-end data movement and quality validation.

You will analyse source data, define mappings, and develop migration test plans while working closely with business users, technical teams, and vendors to ensure successful execution and governance.

Qualifications

• Proven experience in Data Migration or Data Integration roles.
• Strong SQL skills and data transformation knowledge.
• Experience with complex system integration or migration projects.

Responsibilities

• Support end-to-end data migration from legacy to new environments.
• Analyse source-system data and identify quality issues.
• Define and document mappings between legacy and target systems.
• Extract, transform and load data per migration requirements.
• Translate business needs into technical data mappings and rules.
• Develop and execute migration test plans and scripts.
• Reconcile migrated data for completeness and accuracy.
• Troubleshoot migration issues and support post-migration activity.
• Maintain documentation of mappings, transformations and quality checks.
• Collaborate with business users, technical teams, vendors and stakeholders.

Skills

SQL

Data mapping

ETL

Data analysis

Python

Excel

Tools

ETL Tools

SQL Server

Job description

Data Migration Analyst

West Midlands

Hybrid Working

Up to £60,000

Permanent – Full-time opportunity

We’re recruiting for an experienced Data Migration Analyst to support a programme of complex data migration and integration activities.

What you’ll be doing

• Supporting end-to-end migration of data from legacy into new environments
• Analysing source-system data and identifying data quality issues
• Defining and documenting mappings between legacy and target systems
• Extracting, transforming and loading data in line with migration requirements
• Translating business requirements into technical data mappings and rules
• Developing and executing migration test plans and scripts
• Reconciling migrated data to ensure completeness and accuracy
• Troubleshooting migration issues and supporting post-migration activity
• Maintaining clear documentation covering mappings, transformations and quality checks
• Working closely with business users, technical teams, vendors and programme stakeholders
• Contributing to migration strategy, planning and execution

What we’re looking for

• Proven experience in a Data Migration or Data Integration role
• Strong understanding of data mapping, ETL and data transformation
• Experience working on complex system integration or migration projects
• Strong SQL skills
• Experience using data analysis tools such as Excel, Python or similar
• Experience with data migration tools
• Ability to understand system architecture, data structures and integration points
• Strong data analysis and problem-solving skills
• A track record of maintaining data integrity throughout migrations
• Ability to manage multiple workstreams and work to tight deadlines
• Experience with data governance frameworks, cloud-based data environments and CRM/platform migrations would also be beneficial.