Data Migration Lead

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 workingpattern. This role isbased 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 canreasonably commute to one of our main hubs below. The regularity& flexibility of travel will be discussed further atinterview 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.

Contact & Application

If you have any questions, feel free to reach out to us atCRT.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).