Data Migration Lead

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

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

Shell 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 CRT.

recruitment@canalrivertrust.org.uk . 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) . 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