Data Migration Lead

CANAL & RIVER TRUST; United States; Hybrid; USD 61,000 - 75,000; Full time

Job summary

Canal & River Trust seeks a Data Migration Lead to own end-to-end data migration for ERP transformation. You will map, transform and validate data across source/target systems and collaborate with stakeholders to ensure data quality and timely delivery.

The role involves planning, ETL development, and engagement with business users, under a flexible remote-working model with hub visits to Leeds, Newark, and other hubs.

Qualifications

• Proven experience in data migration, ETL development or data engineering.
• 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.

Responsibilities

• Data Migration Planning: Develop and deliver end-to-end data migration strategy, plans and schedules for ERP transformation.
• Data Analysis & Discovery: Assess legacy data structures, volumes and dependencies with stakeholders to identify critical data sets.
• Data Mapping & Transformation: Lead data mapping and transformation to align source and target systems.
• ETL Development & Execution: Design and execute ETL processes using Azure technologies (Databricks, ADF, SQL).
• Data Quality & Cleansing: Profile, cleanse, standardise and validate data to improve quality.
• Testing & Validation: Plan and execute migration testing with business users and test teams.
• Documentation & Stakeholder Engagement: Maintain mapping specs and validation reports; update project stakeholders.

Skills

Data migration

ETL development

SQL

Azure Data Factory

Databricks

Python

PowerShell

Cloud platforms

Data governance

Stakeholder management

Education

Degree in Computer Science / IT / Data Management

Tools

Talend

Informatica

SSIS

Azure Data Factory

Job description

Data Migration Lead

Job Description

About the Trust

We're one of the UK’s biggest charities and we care for 2,000 miles of canals, rivers, docks and reservoirs because we believe life is better by water.We're looking for people who support our cause and want to make a difference for future generations. Could this be you?

Along with our waterways we also manage museums, archives and the country's third largest collection of historic buildings, as well as the nature and wildlife that calls our canals home. All of this enables us to provide wellbeing opportunities for millions of people each year.

Join Our Team: Data Migration Lead opportunity

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

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

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.

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).

Our values

We care passionately for our waterways, and as importantly, for those who look after and use them. We are committed to building a diverse and inclusive workforce where everyone can thrive. We are striving to represent the diverse communities that we are a part of and welcome applicants from across all sectors of the community.

We want everyone to have the opportunity to perform at their best during our recruitment process. If you require any reasonable adjustments - whether for a disability, neurodiversity, or health condition - please let us know what you need and how we can support you. We’ll work with you to make any necessary changes.

All of our jobs can be considered on a part time, flexible or job share basis.

We operate a Guaranteed Interview Scheme for disabled applicants who meet the minimum criteria for the role. You are considered disabled under the Equality Act 2010 if you have a physical or mental impairment that has a substantial and long-term negative effect on your ability to carry out normal day-to-day activities. We recognise not everyone who is classified as disabled under the Equality Act personally identifies this way, or with this definition of disability. Please do not let this discourage you from applying under the scheme.

At Canal & River Trust, we are committed to fair, transparent, and ethical recruitment practices. As part of our hiring process, we may use AI to analyse applications and support us work more efficiently. However, all hiring decisions – without exception – are made by our hiring managers.

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

Find out more about us on our website: https://canalrivertrust.org.uk/about-us

Job Details

• Pay Type: Salary
• Hiring Min Rate: 51,000 GBP
• Hiring Max Rate: 51,000 GBP