Data Migration Lead – Data Transformation

Jobtailor; Greater London; On-site; GBP 70,000 - 110,000; Full time

Job summary

Jobtailor is seeking a Data Migration Lead to drive complex transformation programmes in the UK. You will analyse data models, define mappings, and support migration design with governance and QA. The role requires hands-on data quality work, testing, and collaboration with architects and delivery teams.

You will help shape sequencing, cutover planning and post-migration monitoring, ensuring data integrity across platforms. UK-based with onsite presence 2 days per week.

Qualifications

• Strong experience leading data migration on complex transformation programmes.
• Proven ability to analyse source and target data models.
• Hands-on data mappings and reconciliation rules.
• Experience addressing data quality in large datasets.
• Involvement in migration testing, validation and issue resolution.
• Understanding of sequencing, cutover and deployment.

Responsibilities

• Analyse source and target data structures to understand differences, dependencies and risks.
• Define and document data mapping, transformation and reconciliation rules.
• Support the Business Architect in performing detailed data analysis to inform migration design.
• Identify data quality issues and support the definition and execution of data cleansing and remediation plans.
• Contribute to the definition of the overall data migration approach, including sequencing, dependency management and cutover considerations.
• Produce clear migration specifications, validation rules and test data to support delivery and testing.
• Support data migration testing activities, including reconciliation, issue investigation and resolution.
• Assist in specifying data reporting and data quality requirements for migration and post-migration states.
• Provide input into operational data ownership, controls and post-migration monitoring arrangements.
• Work within programme governance structures, supporting mobilisation and ongoing delivery.

Skills

Data migration lead

Data mapping and transformation

Data quality analysis

Migration testing

Stakeholder collaboration

Cutover planning

Job description

Responsibilities

• Analyse source and target data structures to understand differences, dependencies and risks
• Define and document data mapping, transformation and reconciliation rules
• Support the Business Architect in performing detailed data analysis to inform migration design
• Identify data quality issues and support the definition and execution of data cleansing and remediation plans
• Contribute to the definition of the overall data migration approach, including sequencing, dependency management and cutover considerations
• Produce clear migration specifications, validation rules and test data to support delivery and testing
• Support data migration testing activities, including reconciliation, issue investigation and resolution
• Assist in specifying data reporting and data quality requirements for migration and post-migration states
• Provide input into operational data ownership, controls and post-migration monitoring arrangements
• Work within programme governance structures, supporting mobilisation and ongoing delivery

Requirements

• Strong experience working as a Data Migration Lead or similar role on complex transformation programmes
• Proven experience analysing source and target data models and supporting migration design
• Hands-on experience defining data mappings, transformation logic and reconciliation rules
• Experience identifying and addressing data quality issues within large or complex datasets
• Practical involvement in data migration testing, validation and issue resolution
• Understanding of migration sequencing, cutover planning and deployment considerations
• Strong analytical and problem-solving skills, with attention to detail
• Ability to collaborate effectively with architects, delivery teams and business stakeholders
• Comfortable operating in environments with multiple systems, datasets and dependencies
• Experience contributing to data-led or platform-based transformation initiatives
• UK-based and able to travel onsite 2 days per week
• Experience working on large-scale data transformation or system replacement programmes
• Exposure to data governance, data ownership or post-migration monitoring models