Data Migration Engineer

Snook Ltd, Headspace; City Of London, Glasgow; Hybrid; GBP 50,000 - 70,000; Full time

Job summary

A technology company based in the United Kingdom is seeking a Data Migration Engineer to lead a major migration project. This role involves hands-on SQL expertise, particularly with MySQL, to ensure effective and secure data transfer. The candidate will design ETL processes, engage with stakeholders, and implement data quality measures. This position offers a hybrid working model and an excellent benefits package.

Benefits

Private Medical Cover

25 days paid holiday

Group Pension Plan with contributions

Free LinkedIn Learning access

Qualifications

• Experience with large-scale data migration projects in the public sector.
• Solid understanding of ETL workflows and data quality frameworks.
• Ability to work independently and as part of a data team.

Responsibilities

• Design and execute ETL processes to migrate data.
• Write and optimize complex SQL queries for data extraction.
• Ensure data compliance with governance and security requirements.

Skills

SQL development skills

Problem-solving mindset

Stakeholder engagement

Knowledge of data transformations

Familiarity with case management systems

Education

NPPV3 Security Clearance

Tools

MySQL

Oracle

Azure Data Factory

Job description

Come join us and make a difference in the world!

Please note, ideally we would seek a candidate who can be hyrbid from Glasgow or London, but this role can be remote subject to location.

We are seeking an experienced Data Migration Engineer to support a large-scale migration project.The successful candidate will play a key role in designing, developing, and executing migration strategies to ensure data is transferred accurately, securely, and efficiently into the target environment.

This role requires a hands-on engineer with strong SQL expertise, particularly in MySQL, who can take ownership of migration tasks, proactively identify risks, and collaborate closely with technical and business stakeholders.

Key Responsibilities

• Design, develop, and execute ETL processes to migrate data from legacy systems to target platforms.
• Write and optimise complex SQL queries (preferably MySQL) to support data extraction, transformation, and validation.
• Apply the full data quality framework(accuracy, completeness, consistency, timeliness, validity, uniqueness, integrity) across all migration activities.
• Conduct data profiling, cleansing, and quality assurance checks to ensure accuracy and completeness of migrated data.
• Translate business and technical requirements into data transformation rules and implement them effectively.
• Provide clear feedback to QA data testers, ensuring test coverage and quality are maintained throughout.
• Raise and manage risks, issues, and blockers promptly, keeping all stakeholders fully informed.
• Collaborate with business analysts, developers, architects, and other stakeholders to ensure alignment with business needs.
• Provide clear documentation of migration processes, data mappings, data quality checks, and testing results.
• Support user acceptance testing (UAT) and resolve data-related issues promptly.
• Ensure migrations comply with data governance, security, and regulatory requirements.
• Work with case management software and related systems to understand data structures and workflows.

Qualifications

• Proven experience in public sectorlarge-scale data migration projects.
• Strong SQL development skillswithin MySQL environments.
• Solid understanding of data transformations and ETL workflows.
• Knowledge and application of data quality dimensionsin migration processes.
• Familiarity with case management systems and associated data structures.
• Strong problem-solving mindset, with the ability to take ownership and work independently.
• Experience in stakeholder engagement, risk reporting, and supporting QA testers.
• UK NPPV3 Security Clearancewith at least 12 months remaining.
• Ability to work effectively as part of a data team and with cross-functional stakeholders.
• Experience with Oracledatabases (alongside MySQL).
• Knowledge of data modelling, data warehousing, or data integration tools.
• Experience in working with agile project delivery methodologies.
• Ideally Azure and experience in Azure Data Factory for ETL.

Additional Information

We pride ourselves in offering an excellent benefits package, including an aboveaverage pension scheme. When you join the team at NEC Software Solutions, you are provided with the following:

• Private Medical Cover funded by NEC for Employees (with the option to add family members at an additional cost)
• 25 days paid holiday with the option to buy/sell
• 4 x basic salarylife assurance coverfunded by NEC (with the option to increase cover at an additional cost)
• A Group Pension Plan with fantastic employer contributionsup to a maximum of 8.5%
• A selection of flexible benefits to suit your individual needs
• All colleagues get free access to LinkedIn Learning. Over 15000 courses covering a huge breadth of subjects. Learn about what you like, when you like, how you like.

OTHER INFORMATION

• Candidates must be able to demonstrate a pre-existing right to work and travel within the UK. Documentary evidence will be required.
• All offers are subject to satisfactory vetting and reference checks. Depending on the nature of the role a DisclosureBarring Service (DBS) check may also be required.

NEC Software Solutions is an equal opportunities employer, welcoming applications from all communities.If you require any reasonable adjustments or have specific accessibility needs during the recruitment or interview process, please feel free to share these with us. We are committed to ensuring an inclusive and accommodating experience for all candidates.

Who We Are:

We’re NEC Software Solutions (part of global tech giant NEC Corporation). While you read this ad, our software is helping to dispatch ambulances, support families, keep trains on the move, locate missing people and even test the hearing of newborn babies.

Working with us, you’ll be helping our 3,000+ employees push the boundaries of what’s possible and support amazing public services.

We work with governments, hospitals, police forces, housing providers, local authorities and more. We help them pay financial support faster, speed up treatments for patients and respond to emergencies in the right way. The more we do, the more our customers can do for others. And together, we make a world of difference.

We’d love your help. And we’ll support you all the way.