Data Migration Analyst

Lorien; Greater London; Hybrid; GBP 52,000 - 68,000; Full time

Job summary

Lorien is seeking a Data Migration Engineer to join a major global transformation programme in London. The role focuses on hands-on data migration preparation including mapping, cleansing and validation to support migration and go-live activities.

You will work with data owners and SMEs, applying structured migration methodology, and contribute to documentation and handover at project closure. Hybrid work pattern begins onsite in London with ongoing remote work.

Qualifications

• Hands-on data migration preparation across multiple domains.
• Experience in mapping rules and load-ready data preparation.
• Ability to identify and resolve data quality issues and exceptions.

Responsibilities

• Mapping source data against target models and applying mapping rules.
• Cleansing and preparing data to a load-ready standard.
• Identify and resolve data-quality issues and exceptions, support data validation.

Skills

Data Mapping

Data Cleansing

Data Validation

Tools

SQL

Python

Power Query

Job description

Data Migration Engineer – | Outside IR35

Location: London – onsite 1 day per week for the initial month, then remote

Contract: 5 months

I’m currently recruiting for Data Migration Engineer to join a major global transformation programme for a large multi-site UK organisation.

The programme is replacing the organisation’s core ERP and middle-office platforms, with data migration being a critical part of the transformation. We’re looking for experienced analysts who can take ownership of the hands-on data preparation, mapping, cleansing and validation activities required ahead of the migration and upcoming go-live.

Key Responsibilities

You will be involved in:

• Mapping source data against target data models and applying agreed mapping rules
• Cleansing and preparing data to a load-ready standard
• Identifying and resolving data-quality issues and exceptions
• Supporting data validation and reviewing migration outputs with relevant SMEs
• Documenting mapping rules, transformations and data decisions
• Working across multiple data domains and applications
• Liaising with data owners, application owners and operational SMEs to resolve queries
• Following a structured data migration methodology and working to agreed delivery timelines
• Supporting the final handover of migration activity and documentation

• Strong experience in Data Mapping, Data Cleansing and Data Validation
• SQL and/or Python
• Power Query
• experience working with structured datasets and data migration processes
• Ability to work independently and pick up established processes quickly

Experience with any of the following would be highly beneficial:

• ERP implementation or transformation programmes
• Data-quality tools
• Large-scale or multi-site organisations
• Experience working across multiple applications or data domains

This is not a general Business Analyst role and it isn't purely a data validation/SME position. The focus is on hands-on data migration preparation, taking source data through mapping, cleansing and preparation so it is ready for migration.