Data Migration Lead

Job Purpose

Internal job title: Data Migration Lead

Advertised Salary: £45,000 - £50,000 (depending on experience).

Location: Remote working with hub allocated when required.

Looking for a new data migration opportunity that offers professional development, flexible working, creative autonomy, and prioritises wellbeing?

We are the charity who look after and bring to life 2,000 miles of waterways across England and Wales, because we believe that life is better by water. Every role across the Trust plays it's part in transforming our canals and rivers into spaces where local people want to spend time and feel better, bringing wellbeing benefits to millions. See how we make difference: (https://canalrivertrust.org.uk/about-us/how-we-make-a-difference)

The role

The Data Migration Lead is responsible for planning, coordinating, and executing the migration of data from legacy systems to new platforms, ensuring accuracy, integrity, and completeness of the data throughout the process. This role requires expertise in data analysis, mapping, transformation, and cleansing, along with strong technical skills and experience with various Azure ETL tools (Databricks, ADF, SQL etc). The ideal candidate will work closely with stakeholders, developers, and business units to ensure that data migration processes are executed efficiently and within project timelines.

A substantial focus of the role will be to support the data preparation and migration aspects of the ERP transformation project.

The highly engaged IT team has a defined information strategy, encompassing some very exciting projects using the latest technologies, all covering a very diverse business in an organisation that is doing something good in the world. This makes the work fun, and at the same time provides opportunities for self-development, challenge and variety.

Location

You will be offered on a remote working basis, with a requirement to attend our main hub spaces as and when required for team working and collaborative meetings.

Relevant hubs include: Leeds, Liverpool, Burnley, Newark, Birmingham, Milton Keynes, Gloucester, London.

The regularity & flexibility of travel will be discussed further at interview stage.

See our canal network here: (https://canalrivertrust.org.uk/enjoy-the-waterways/canal-and-river-network).

Knowledge, Skills/Qualifications & Experience

Read the full job advert here: Canal & River Trust - Data Migrations Lead - Full Job Advert

Key accountabilities:

• Data Migration Planning - Develop and execute data migration strategies and plans in collaboration with the project team. This will include assessing and analyse existing data structures, formats, and volumes in legacy systems to define migration requirements.
• Mapping data between old and new system; Collaborating with business and technical teams to understand data structures in both the source and destination systems.
• Data Extraction, Transformation, and Loading (ETL) - Perform data extraction from legacy systems, ensuring data integrity and completeness.
• Data Cleansing & Validation - Analyse data quality issues and design data cleansing procedures to resolve inconsistencies, duplicates, and incomplete records.
• Documentation & Reporting - Document the data migration process, including migration scripts, transformation rules, and validation reports.
• Collaboration - Work closely with data owners, developers, and IT teams to ensure a smooth data migration process.

About you

• Educational Background: Bachelor's degree in Computer Science, Information Technology, Data Management, or a related field.
• Experience:
  • 3+ years of experience in data migration, ETL development, or data engineering.
  • Proven experience with data migration projects involving large, complex datasets across multiple systems, ERP experience preferable
  • Strong technical skills, with the ability to write complex queries for data extraction and validation.
  • Experience with ETL tools such as Databricks, Talend, Informatica, SSIS or similar.
  • Experience with database management systems (e.g., SQL Server, Oracle, MySQL) and cloud-based databases (e.g., AWS RDS, Azure SQL).

• Technical Skills:
  • Solid understanding of data structures, data formats, and database systems.
  • Proficient in data mapping, transformation, and cleansing techniques.
  • Familiarity with data migration in ERP, CRM, or other enterprise applications.
  • Experience with scripting languages (Python, PowerShell, etc.) is a plus.
  • Knowledge of data governance and data security principles.

• Soft Skills:
  • Strong problem-solving and analytical skills.
  • Excellent communication and collaboration skills, with the ability to work effectively with technical and non-technical stakeholders.
  • Attention to detail and ability to maintain high standards of data accuracy.
  • Ability to work independently and manage multiple tasks in a fast-paced environment.

To apply: click on the "Apply for this job" button and follow the process - complete the application form & upload current CV.

If you have any questions about the role, please contact CRT.recruitment@canalrivertrust.org.uk

What We Offer

In addition to your salary of £45,000 - £50,000 depending on experience , you will benefit from a competitive contributory DC Pension scheme arrangement, great holiday entitlement and numerous other employee benefits, including several salary sacrifice benefits, all of which can be found here (https://canalrivertrust.org.uk/about-us/work-for-us/our-benefits). These include:

• 25 days paid holiday, plus paid Bank Holidays, increasing to 27 days plus Bank Holidays after 3 years
• Home working status with 'hub' facilities available if a need to work outside of home - flexibility. Monday to Friday working, no weekend working.
• Annual £200 personal learning & growth award to spend on any learning related activity - hobbies; aspirations etc.
• Free access to specialist counselling on a range of issues - health; financial; lifestyle; well-being; domestic & neighbourly matters.
• Access to a range of employee benefits including - store discounts; boating holiday discounts; holiday purchase scheme.
• 2 days paid volunteering leave, volunteering for local community project work.

At the Trust we care passionately for our waterways, and as importantly, for those who look after and use them. We strongly believe that a diverse workforce brings with it a diversity of ideas, thinking and ways of working which enhances what we do as a Trust. We are striving to represent the diverse communities that we are a part of and welcome applicants from across all sectors of the community.

All candidates will be treated on the basis of their merits, skills and abilities and solely by being assessed against the requirements for the job.

When you join the Canal & River Trust you become a member of an engaged team working to preserve our heritage for future generations. Come and share your passion and knowledge with a team that makes a difference to millions of people every day.

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