Data Migration Analyst

Amtis - Digital, Technology, Transformation; West Midlands; On-site; GBP 42,000 - 62,000; Full time

Job summary

Amtis - Digital, Technology, Transformation is seeking an experienced Data Migration Analyst to support a programme of complex data migration and integration activities. You will cover the full migration lifecycle from understanding legacy data and mapping rules through ETL, testing, reconciliation and post-migration support.

The role requires proven experience in data migration or data integration, strong data mapping and ETL expertise, and hands-on work with migration tools.

Qualifications

• Proven experience in a Data Migration or Data Integration role.
• Strong understanding of data mapping, ETL and data transformation.
• Experience with data migration tools and complex system migrations.

Responsibilities

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

Skills

Data migration

Data integration

ETL

Python

Excel

Tools

Python

Excel

Data migration tools

Job description

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

This is a hands‑on role covering the full migration lifecycle, from understanding legacy data and defining mapping rules through to ETL, testing, reconciliation and post‑migration support.

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