Data Migration Lead - Strategy, ETL & Data Quality

Jobtailor; High Wycombe; On-site; GBP 70,000 - 97,000; Full time

Job summary

Biffa is seeking a Data Migration Lead to define and own the data migration strategy, standards, and plans for large-scale migrations across SaaS, Dayforce, and D365 systems.

You will lead analytics, data cleansing, mapping, and quality reporting, partnering with Finance to validate migrated data and explain financial impacts. A strong leadership background and Azure data tools experience are essential.

Qualifications

• Hands-on experience delivering large-scale data migrations in medium-sized or larger organisations.
• Advanced T-SQL programming and performance tuning abilities.
• Skilled in SSIS or Azure Data Factory for data migration.
• Excellent communication skills and ability to explain technical challenges to non-technical colleagues.
• Ability to translate technical migration findings into financial-impact language for Finance audiences.
• Extensive experience transforming data through integrations.
• Experience with project management and workflow tools such as Azure DevOps.
• Skills in technical report-building and data quality reporting.

Responsibilities

• Define and own data migration strategy and standards, including cleansing approaches and required technologies.
• Create and maintain data migration plans covering cycles, resourcing, timelines, and project alignment.
• Oversee or manage data extraction, transformation, and loading activities.
• Lead data analysis and profiling to identify gaps, quantify issues, and develop data quality reporting tools.
• Partner with Finance teams to validate migrated data against source-system financial records and explain discrepancies.
• Document data issues, gaps, mappings, business rules, and risks, and validate them with stakeholders.
• Conduct data due diligence and mapping sessions for organisations Biffa plans to acquire.
• Manage a team of data migration analysts and provide development and progression plans.
• Collaborate with the Data Architect, Product Teams, business stakeholders, Finance teams, and third parties.
• Develop reusable migration patterns and data cleansing, mapping, and migration tools for SaaS, legacy, Dayforce, and D365 systems.

Skills

Data migration

Advanced T-SQL

Data profiling

Data mapping

Data quality reporting

Project management

Data integration

Stakeholder communication

Analytics mindset

Financial data validation

Education

Bachelor’s degree in Computer Science or related

Azure data platform certifications

Tools

SSIS

Azure Data Factory

Power BI

Azure DevOps

Microsoft Dynamics 365

Power Platform

Dayforce

Job description

Biffa is seeking a Data Migration Lead to define and own the data migration strategy, standards, and plans for large-scale migrations across SaaS, Dayforce, and D365 systems.

You will lead analytics, data cleansing, mapping, and quality reporting, partnering with Finance to validate migrated data and explain financial impacts. A strong leadership background and Azure data tools experience are essential.