Data Migration Lead

Data Migration Lead

Data Migration, Data governance standards, Data migration strategy, ETL, Exasol, Databricks, SQL, Data models, Data Engineering

• Warrington – 3 days per week on-site requirement
• 6 months initial contract
• £500 per day via Umbrella

We are seeking a Data Migration Lead to oversee the delivery of data migration projects within our Technology Services. This role is crucial for ensuring the successful migration of data in line with our IT project goals and compliance with data governance standards.

Day-to-Day of the Role:

• Define and implement the Data Migration Strategy in alignment with the overall migration strategy of the organisation.
• Collaborate with Partners and business teams to support the creation of conceptual, logical, and physical data models, ensuring a robust change control process is in place.
• Develop code and processes to create target data structures in Exasol/Databricks, working closely with the Data Services Team.
• Transform source data to the target model using source to target mapping documents provided by the Delivery Partner.
• Conduct audits and reconciliation of the extract and transform phases to ensure all data created/migrated is fit for purpose and meets system requirements.
• Manage data anonymization for environments below Pre Production to safeguard personal and sensitive data.
• Oversee all data migration cycles, including Mock, Dress Rehearsal, Cut Over Simulation, and Cut Over phases.
• Communicate with internal stakeholders and functional SMEs regarding data requirements, formats, processes, standards, and progress.
• Resolve data issues in collaboration with functional SMEs, ensuring data standards and model population are agreed upon and signed off for production data load.

Required Skills & Qualifications:

• Degree in a relevant discipline (e.g., Maths, Physics, Information Technology) or equivalent practical experience.
• Strong experience with data migration projects and a proven track record of successful delivery.
• Proficiency in SQL for data analysis, transformation, and structuring.
• Experience with tools such as Exasol and Databricks.
• Excellent people skills, with the ability to work independently and as part of a wider project team.
• Strong planning, coordination, and project management skills.
• Effective communication and stakeholder management abilities.

In the first instance, please submit your CV.