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

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

Data Migration Lead – Data Transformation

Key skills