Data Migration Lead

We are seeking an experienced Data Migration Lead to take ownership of complex data migration activities as part of a major systems transformation programme. The successful candidate will be responsible for leading the end-to-end migration of data from multiple legacy systems into a modern target platform, ensuring accuracy, integrity, and full reconciliation across all datasets.

This role requires strong technical expertise in SQL, ETL processes, and data transformation, combined with the ability to work closely with business stakeholders, SMEs, and third-party suppliers to define and deliver migration requirements.

The environment includes large-scale housing, financial, and operational datasets, often originating from multiple legacy systems with varying levels of data quality and structure.

• Lead the full lifecycle of data migration activities from legacy systems to target platforms
• Analyse and profile complex datasets across multiple source systems
• Design and implement data migration strategies, processes, and execution plans
• Develop and maintain data mapping specifications and transformation logic
• Ensure alignment with supplier-led migration frameworks and delivery schedules

• Work with SMEs and business users to gather and define data migration requirements
• Analyse legacy data structures and define business rules for migration
• Contribute to the development of target data models and architecture
• Identify gaps, inconsistencies, and structural issues in legacy datasets

• Design and implement ETL processes using SQL Server, SSIS, or equivalent tools
• Extract, transform, cleanse, and load data from multiple legacy systems
• Write and optimise SQL scripts, stored procedures, and data transformation logic
• Ensure high performance and scalability of migration processes

• Identify and resolve data quality issues, duplicates, and inconsistencies
• Define and enforce data validation and cleansing rules
• Ensure all migrated data meets required quality, integrity, and compliance standards
• Support GDPR and data protection requirements when handling personal data

• Lead unit testing, system integration testing (SIT), and user acceptance testing (UAT) of data loads
• Produce detailed reconciliation reports comparing legacy vs target systems
• Support defect resolution and reprocessing of data loads where required
• Ensure full auditability of migration outputs

• Act as primary interface between business SMEs, technical teams, and suppliers
• Facilitate workshops to define data definitions, mapping rules, and migration scope
• Communicate complex technical issues in a clear, business-friendly manner
• Provide regular progress updates and risk/issue reporting

• Proven experience as a Data Migration Lead or Senior Data Migration Specialist
• Strong background in migrating data from legacy systems into enterprise platforms
• Advanced knowledge of SQL and relational databases (SQL Server preferred)
• Experience with ETL processes and data transformation techniques
• Strong experience in data mapping, profiling, and cleansing
• Experience working with multiple legacy data sources and complex datasets
• Ability to work independently and lead migration workstreams
• Strong stakeholder management and SME engagement experience

• Experience in housing, public sector, or asset management systems
• Knowledge of systems such as Capita Open Housing, Dynamics 365, Unit4, SAP
• Experience with SSIS, Oracle, DB2, or PostgreSQL
• Understanding of financial data structures (GL, AR/AP, fixed assets, tenancy data)
• Experience contributing to data architecture and target system design

• Detail-oriented with a strong focus on data accuracy and integrity
• Logical and methodical approach to complex problem solving
• Comfortable working in high-pressure, delivery-focused environments
• Strong communicator with both technical and non-technical stakeholders
• Proactive, self-directed, and solution-focused mindset

• Successful migration of data from multiple legacy systems into target platform
• Fully reconciled datasets with zero critical data loss
• Clear, validated data mapping and transformation logic
• Strong stakeholder confidence in data quality and migration outcomes
• Smooth transition through testing, UAT, and go-live phases