Senior Data Migration/Data Engineering Consultant (Azure)
Role Overview
We are seeking an experienced Senior Data Migration/Data Engineering Consultant to support a business-critical system implementation and data migration programme.
The consultant will plan, coordinate and execute end-to-end migration activities, covering data extraction, transformation, cleansing, loading, validation and reconciliation. This is a hands-on role requiring strong experience with Azure Data Factory, SQL & Advanced Excel, combined with the ability to manage high-pressure migration and production cutover events.
Key Responsibilities
- Develop and maintain detailed data migration, implementation and cutover runbooks.
- Plan and coordinate migration activities across technical teams, business stakeholders and third-party suppliers.
- Design, build and execute data migration pipelines using Azure Data Factory.
- Develop SQL scripts and queries for data extraction, transformation, profiling, validation and reconciliation.
- Analyse source and target data structures and produce source-to-target mappings.
- Identify data-quality issues and coordinate or perform cleansing and remediation activities.
- Use Advanced Excel & PowerBI, to support data analysis, migration tracking, automation and reporting.
- Perform pre and post migration validation to confirm data completeness and accuracy.
- Investigate migration errors, reconciliation differences and data-quality exceptions.
- Support mock migrations, dress rehearsals, production cutovers and post-go-live stabilisation.
- Track migration progress, risks, issues, dependencies and critical-path activities.
- Define contingency and rollback procedures and support go/no-go decision-making.
- Provide clear status updates to programme leadership and other stakeholders.
- Maintain accurate migration documentation, controls and audit evidence.
Essential Requirements
- Proven experience delivering complex enterprise data migrations projects
- Strong experience creating and executing detailed migration and cutover runbooks.
- At least 2-3 years of hands-on Azure Data Factory experience.
- At least 4+ years of strong SQL experience.
- At least two years of data-quality management and data-remediation experience.
- Strong experience in data profiling, cleansing, mapping, transformation, validation and reconciliation.
- Experience supporting migration rehearsals and production cutovers.
- Strong communication and stakeholder-management skills.
- Ability to remain organised, reliable and calm under significant pressure.
- Quality-driven approach with excellent attention to detail.