Data Migration Lead

Colonial Group; United Kingdom; Hybrid; GBP 51,000 - 59,000; Full time

Benefits offered by this job

Competitive pension

Increased holiday entitlement

Employee benefits package

Job summary

Canal & River Trust is seeking a Data Migration Lead to plan, coordinate and execute the migration of data from legacy systems to a new ERP platform. You will guide discovery, mapping, transformation, cleansing and validation using Azure tools to ensure data integrity throughout the lifecycle.

You will drive data preparation, migration and cutover activities for the ERP transformation while collaborating with business stakeholders, data owners and project teams to minimise disruption and

Qualifications

• Proven experience in data migration, ETL development or data engineering in large-scale transformations.
• Strong knowledge of data structures, databases, mapping, transformation and cleansing.
• Experience designing ETL processes with Databricks, ADF, Talend, Informatica, SSIS or equivalents.
• Strong SQL and data analysis skills for extraction, validation and reconciliation.
• Experience with ERP/CRM migrations and data governance and security principles.

Responsibilities

• Plan and deliver end-to-end data migration strategies and schedules for ERP transformations.
• Assess legacy data structures, volumes and dependencies with stakeholders to define migration requirements.
• Lead data mapping and transformation to align source and target systems.
• Design and execute ETL using Azure tools (Databricks, ADF, SQL).
• Drive data profiling, cleansing, standardisation and validation to improve quality.
• Coordinate testing and validation with business users and QA teams.
• Monitor risks and resolve migration issues to meet timelines and quality.
• Maintain migration documentation and provide progress updates to stakeholders.

Skills

Data migration

ETL development

Data analysis

SQL

Azure Databricks

Azure Data Factory

Data cleansing

Data governance

Stakeholder engagement

Python/PowerShell

Education

Degree-level qualification in Computer Science / IT / Data Management or related discipline

Tools

Azure

Databricks

ADF

SQL Server

Oracle

MySQL

Job description

Join Our Team: Data Migration Lead opportunity

Navigate your future and lock in your career as we keep our canals open and alive.

The Data Migration Specialist is responsible for planning, coordinating and executing the migration of data from legacy systems to new platforms, ensuring the accuracy, integrity and completeness of data throughout the migration lifecycle. You will lead data discovery, mapping, transformation, cleansing and validation activities, leveraging Azure-based tools such as Databricks, Azure Data Factory (ADF) and SQL to support efficient and controlled data migration. Working closely with business stakeholders, data owners, developers and project teams, you will ensure data is prepared, tested and successfully migrated in line with business requirements, governance standards and project timelines.

A significant focus of the role will be supporting the data preparation, migration and cutover activities associated with the organisation's ERP transformation programme, helping to ensure a smooth transition to the new enterprise platform while minimising business disruption. Throughout your time with the Trust, you will also have opportunity to develop skills on unique projects in other areas of BI.

Working Hours & Location

This role follows 37 hours, Monday to Friday working pattern. This role is based working from home, with a requirement to attend our main hub spaces from time to time for team working and collaborative meetings. It is important that you can reasonably commute to one of our main hubs below. The regularity & flexibility of travel will be discussed further at interview stage.

Relevant Hubs: Leeds, Newark, Ellesmere Port, Burnley, Birmingham, Gloucester.

Role Overview

You will lead the planning and delivery of end-to-end data migration activities for the ERP transformation programme, ensuring data is accurately extracted, cleansed, transformed and migrated from legacy systems to the new platform while maintaining data quality, integrity and business continuity.

Key Responsibilities

• Data Migration Planning: Develop and deliver the end-to-end data migration strategy, plans and schedules to support the successful implementation of the ERP transformation programme.


• Data Analysis & Discovery: Assess legacy system data structures, volumes and dependencies, working with stakeholders to identify critical data sets and define migration requirements.


• Data Mapping & Transformation: Lead data mapping and transformation activities, ensuring data is accurately aligned between source and target systems and meets business requirements.


• ETL Development & Execution: Design and execute data extraction, transformation and loading (ETL) processes using Azure technologies, including Databricks, Azure Data Factory (ADF) and SQL.


• Data Quality & Cleansing: Drive data profiling, cleansing, standardisation and validation activities, resolving inconsistencies, duplicates and incomplete records to improve data quality.


• Testing & Validation: Collaborate with business users, data owners and test teams to plan and execute migration testing, including system integration testing and user acceptance testing (UAT).


• Risk & Issue Management: Monitor, troubleshoot and resolve migration issues, proactively managing risks and ensuring activities are delivered to agreed timelines and quality standards.


• Documentation & Stakeholder Engagement: Maintain migration documentation, including mapping specifications, transformation rules and validation reports, while providing regular progress updates to project stakeholders and business leaders.

About You

This role is ideal for someone with a passion for data accuracy, a keen eye for detail, and a collaborative spirit to ensure successful data migration projects. If you're experienced in moving complex datasets and ensuring their quality, we want to hear from you!

Skills & Qualifications

Technical:

• Proven experience in data migration, ETL development or data engineering, ideally within large-scale transformation or ERP programmes.


• Strong knowledge of data structures, database systems, data mapping, transformation and cleansing techniques.


• Experience designing and executing ETL processes using tools such as Databricks, Azure Data Factory (ADF), Talend, Informatica, SSIS or similar.


• Strong SQL and data analysis skills, with the ability to write complex queries for data extraction, validation and reconciliation.


• Experience working with enterprise databases and cloud platforms, including SQL Server, Oracle, MySQL, Azure and AWS.


• Familiarity with ERP, CRM or other enterprise application migrations, along with an understanding of data governance, security and quality principles.


• Experience with scripting languages such as Python or PowerShell and relevant Azure or data engineering certifications would be advantageous.

General:

• Strong analytical and problem-solving skills, with the ability to identify and resolve data quality and migration issues.


• Excellent communication and stakeholder management skills, with the ability to engage effectively with both technical and non-technical audiences.


• Demonstrated ability to work collaboratively across business, technology and project teams to achieve successful outcomes.


• Highly organised with strong attention to detail and a commitment to data accuracy and integrity.


• Ability to manage multiple priorities, work independently and deliver to agreed deadlines in a fast-paced project environment.


• Understanding of project delivery frameworks such as Agile and Waterfall, with experience contributing to complex transformation programmes.


• Degree-level qualification in Computer Science, Information Technology, Data Management or a related discipline, or equivalent relevant experience.

Contact & Application

If you have any questions, feel free to reach out to us at [e-mail]. We encourage early applications as we may close the vacancy once we receive enough suitable candidates.

What We Offer

In addition to your annual base salary of £51,000, a competitive pension scheme, increasing holiday entitlement, and a range of employee benefits. For a full breakdown of our benefits, check out our brochure here: EVP - 1 (https://canalrivertrust.pagetiger.com/cqhhihy/1).