Data Migration Lead

Location: Midlands
Contract: 12 months

Our client, a progressive Midlands based local authority, is seeking an experienced Data Migration Lead to support a major transformation programme. This role will focus on the migration of complex datasets from legacy housing systems, including Capita Open Housing, into a new target platform.

The Role

As the Data Migration Lead, you will take ownership of the end to end data migration process. Working closely with business stakeholders, technical teams, and system suppliers, you will ensure the accurate, secure, and efficient migration of data into the new environment.

Key Responsibilities

• Engage with SMEs, business leads, and users to define and document data migration requirements
• Develop a comprehensive data migration strategy aligned with the target system supplier's approach
• Create and manage the data migration plan in line with the overall programme delivery schedule
• Conduct audits of existing data sources and collaborate with stakeholders to define migration business rules
• Identify and address data quality issues to ensure successful migration outcomes
• Support ETL processes and work closely with supplier data migration consultants
• Lead and coordinate testing activities, including unit testing, data validation, and user acceptance testing (UAT)
• Ensure compliance with data protection standards when handling personal data
• Work collaboratively across project workstreams to support delivery

Key Skills and Experience

• Proven experience as a Data Migration Lead on complex transformation programmes
• Experience with legacy housing systems, ideally Capita Open Housing
• Strong knowledge of ETL processes and frameworks
• Proficiency in SQL, scripting, and data extraction techniques
• Experience working with multiple data sources migrating into one or more target systems
• High attention to detail, with a focus on data accuracy and integrity
• Strong problem solving skills with a pragmatic, solution focused approach
• Experience in local government or public sector environments is advantageous
• Solid understanding of data governance and data protection principles

What's on Offer

• £600 per day (Outside IR35)
• 12 month contract on a high-profile transformation programme
• Opportunity to lead a critical workstream and engage with senior stakeholders
• Hybrid working arrangements