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 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).
Data Migration Lead employer: CANAL & RIVER TRUST
Join the Canal & River Trust as a Craft Operative and become part of a dedicated team that makes a tangible difference to our beautiful canal network. With a strong focus on employee growth, we offer competitive salaries, a robust pension scheme, and increasing holiday entitlement, all within a supportive work culture that values practical skills and a passion for the outdoors. Based in Crickhowell, you'll enjoy the unique advantage of working in a picturesque location while contributing to the preservation of our heritage and environment.
