Senior Data Migration Engineer

Role: Senior Data Migration Engineer Location: Sheffield (3 days a week) Employment: Fulltime Role Overview We are seeking an experienced Data Migration Specialist to deliver complex enterprise data migration projects. The successful candidate will have strong SQL and Azure Data Engineering expertise, with proven experience in planning and delivering end-to-end data migrations. This is a hands-on role requiring the ability to understand complex data models, metadata, data relationships and large-scale data structures. Key Responsibilities Data Migration Strategy & Planning Define the data migration strategy, scope, approach and delivery plan.Assess migration complexity, risks and dependencies.Support migration cutover and transition planning. Data Discovery & Inventory Analyse source systems and identify data required for migration.Perform data discovery, profiling and inventory assessments.Understand source and target data models, metadata, relationships and dependencies. Data Mapping & Transformation Define source-to-target data mappings.Develop data transformation rules and business logic.Work with business and technical stakeholders to validate mapping requirements.Handle complex relational and large-volume data structures. Data Quality & Cleansing Assess data quality and identify inconsistencies, duplicates and missing data.Define and implement data cleansing and remediation activities.Establish data quality controls and validation rules. Migration Preparation & Execution Design and build migration pipelines and processes.Execute trial migrations, production migrations and cutover activities.Monitor migration execution and resolve data-related issues.Maintain appropriate migration documentation and audit evidence. Validation & Reconciliation Define and execute data validation and reconciliation processes.Confirm the completeness and accuracy of migrated data.Investigate and resolve data discrepancies.Produce migration reports and evidence of successful migration. Essential Skills & Experience Strong experience in enterprise data migration and data engineering projects.Strong SQL skills, including complex queries, data analysis, transformation, validation and reconciliation.Hands-on experience with:Azure Data Factory (ADF)PythonAzure SQL DBsAzure Data Lake and Lakehouse architecturesETL and ELT pipeline developmentAzure DevOps, Git and CI/CD practicesMicrosoft Fabric (Good to have)Strong understanding of:Data modellingMetadata managementData lineageMaster and reference dataComplex relational data structuresProven experience across the full data migration lifecycle, including:Migration strategy and scopeData discovery and inventoryData quality and cleansingData mapping and transformationMigration preparation and executionValidation and reconciliationStrong analytical, troubleshooting and problem-solving skills.Ability to communicate effectively with both business and technical stakeholders. Preferred Experience Migration of legacy systems to Azure or Microsoft Fabric platforms.Previous experience of working on data migration for Governance, Risk and Compliance systems in a Financial Services organisationExperience working on large-scale cloud transformation programmes.Knowledge of data governance, data quality and metadata management frameworks.Experience working within complex or regulated organisations.Relevant Microsoft Azure or Fabric certification.