Senior Data Migration Engineer

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.

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., Essential

• 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)
• Python
• Azure SQL DBs
• Azure Data Lake and Lakehouse architectures
• ETL and ELT pipeline development
• Azure DevOps, Git and CI/CD practices
• Microsoft Fabric (Good to have)
• Strong understanding of:
• Data modelling
• Metadata management
• Data lineage
• Master and reference data
• Complex relational data structures
• Proven experience across the full data migration lifecycle, including :
• Migration strategy and scope
• Data discovery and inventory
• Data quality and cleansing
• Data mapping and transformation
• Migration preparation and execution
• Validation and reconciliation
• Strong 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 organisation
• Experience 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.