Data Migration Engineer

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.