Data Migration Manager

Marc Daniels; Milton Keynes; On-site; GBP 70,000 - 110,000; Full time

Job summary

Marc Daniels is seeking a Data Migration Lead to own strategy and delivery of large-scale data migrations across multiple platforms. You will lead extraction, transformation and loading, ensure data quality and reconciliations with finance, and work with third-party partners.

The role requires strong technical leadership, knowledge of T-SQL, SSIS/ADF, and Power BI, plus the ability to translate technical issues into business impact. Based in the UK, this is a senior, transformative position.

Qualifications

• Significant hands-on experience delivering large-scale data migrations within a medium or large organisation.
• Strong T-SQL programming and performance-tuning experience.
• Hands-on experience with SSIS and/or Azure Data Factory.
• Extensive experience of data transformation and integrations.
• Strong data analysis, profiling and data-quality experience.
• Experience communicating technical findings to non-technical stakeholders.
• Experience translating technical findings into financial and commercial impacts.

Responsibilities

• Define and own the overall Data Migration strategy, standards and approach.
• Develop migration plans with cycles, resources and timelines.
• Lead data extraction, transformation and loading across multiple systems.
• Analyze and profile data to identify gaps, quality issues and risks.
• Develop data cleansing, mapping and transformation approaches.
• Create and maintain data quality reporting and migration documentation.
• Work with Finance to validate migrated data against source records and resolve discrepancies.
• Coordinate with third-party delivery partners and oversee their migration activities.
• Support data due diligence and migration planning as part of wider business change.
• Lead and develop a team of Data Migration Analysts.

Skills

T-SQL

SSIS

Azure Data Factory

Power BI

Azure DevOps

Microsoft Dynamics 365

Power Platform

Data profiling

Data quality

Leadership

Project management

Education

Degree in Computer Science or related

Tools

T-SQL

SSIS

Azure Data Factory

Power BI

Azure DevOps

Microsoft Dynamics 365

Power Platform

Job description

Job Description

Data Migration Lead

About the Role

We are working with a large, complex organisation undergoing a significant programme of technology transformation, including the introduction of new SaaS platforms, the consolidation of legacy systems and ongoing business change.

As Data Migration Lead, you will take ownership of the organisation's data migration strategy and delivery, ensuring data is accurately extracted, transformed, cleansed, mapped and loaded into new business systems.

This is a highly technical and commercially important role, working across multiple business functions and transformation programmes. You will work closely with technical teams, Finance and wider business stakeholders to ensure data quality, integrity and reconciliation throughout the migration lifecycle.

Key Responsibilities

• Define and own the overall Data Migration strategy, standards and approach.


• Develop and maintain detailed migration plans, including migration cycles, resources and timelines.


• Lead data extraction, transformation and loading activities across multiple systems.


• Analyse and profile data to identify gaps, quality issues and potential risks.


• Develop data cleansing, mapping and transformation approaches.


• Create and maintain data quality reporting and migration documentation.


• Work closely with Finance teams to validate migrated data against source-system financial records and investigate discrepancies.


• Translate technical data issues into clear business and financial impacts for non-technical stakeholders.


• Document data issues, mappings, business rules, risks and transformation requirements.


• Work with third-party delivery partners and oversee their migration activities.


• Support data due diligence and migration planning as part of wider business change and acquisition activity.


• Facilitate data reconciliation and testing activities, ensuring appropriate data extracts are available.


• Lead and develop a team of Data Migration Analysts, providing direction, support and progression.


• Identify and introduce new technologies and tools to improve the efficiency and quality of data migration delivery.

About You

You will have significant hands‑on experience delivering large-scale data migrations within a medium or large organisation, with a strong technical understanding of data extraction, transformation and loading.

You will ideally have:

• Strong T‑SQL programming and performance‑tuning experience.


• Hands‑on experience with SSIS and/or Azure Data Factory.


• Extensive experience of data transformation and integrations.


• Strong data analysis, profiling and data‑quality experience.


• Experience working with complex stakeholder groups to identify data gaps and define transformation requirements.


• The ability to communicate technical issues clearly to non‑technical audiences.


• Experience translating technical findings into financial and commercial impacts.


• Experience introducing new data technologies or toolsets.


• Experience using project/workflow tools such as Azure DevOps.


• Experience with Power BI or similar technical reporting tools.


• Familiarity with Microsoft Dynamics 365 and the Power Platform would be advantageous.


• Understanding of business systems such as Finance, Invoicing, CRM and HR systems.


• Previous experience managing or mentoring data migration professionals.


• Strong project management skills and the ability to work to demanding deadlines.

Technical Environment

The role will involve working across a range of data and business technology platforms, with particular relevance to:

T‑SQL | SSIS | Azure Data Factory | Power BI | Azure DevOps | Microsoft Dynamics 365 | Power Platform

What You'll Need

• Degree-level qualification or equivalent experience in Computer Science, Data, Technology or a related discipline.


• Relevant technical certifications in Azure data platforms would be beneficial.


• Strong analytical and problem‑solving skills.


• Excellent attention to detail and commitment to technical documentation and data standards.


• Ability to operate independently while collaborating effectively across technical and business teams.


• Strong leadership, influencing and stakeholder‑management skills.


• Ability to understand both the strategic, long‑term impact of technology decisions and the immediate delivery requirements.


• A commercially minded approach, with the ability to understand the financial implications of technology and data decisions.

JBRP1_UKTJ