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