Data Migration Delivery Lead (Fusion experience)

Overview

The Data Migration Lead is responsible for planning, executing, and overseeing all data migration activities across the Transformation Programme. This role ensures data is accurately, securely, and efficiently migrated between systems, meeting business, technical, and regulatory requirements. The Data Migration Lead acts as the bridge between technical teams, business stakeholders, and vendors to ensure a seamless transition with minimal disruption. The role will also oversee and facilitate the provision of SGN production data to the programme (test and migration teams).

What you will do

• Strategy & Planning – Develop and own the end‑to‑end data migration strategy, including scope, timelines, approach, and success criteria.
• Strategy & Planning – Conduct data assessments to identify source systems, data quality issues, and transformation needs.
• Strategy & Planning – Define migration principles, standards, and best practices.
• Strategy & Planning – Plan and manage migration phases (extract, cleanse, transform, load, validate).
• Data Mapping & Transformation – Lead detailed data mapping between legacy and target systems.
• Data Mapping & Transformation – Define transformation and validation rules in collaboration with business SMEs and technical teams.
• Data Mapping & Transformation – Ensure data definitions, business logic, and metadata are documented and maintained.
• Execution & Quality Assurance – Oversee or perform data extraction, cleansing, transformation, and loading processes.
• Execution & Quality Assurance – Manage data quality initiatives, including profiling, cleansing, reconciliation, and validation.
• Execution & Quality Assurance – Conduct multiple migration cycles (test, UAT, dress rehearsals, go‑live).
• Execution & Quality Assurance – Resolve data issues, defects, and mismatches.
• Stakeholder Management – Work closely with business owners, system owners, vendors, and project managers.
• Stakeholder Management – Communicate progress, risks, decisions, and dependencies to stakeholders.
• Stakeholder Management – Facilitate workshops on data quality, mapping, and transformation.
• Risk & Governance – Identify and mitigate data migration risks and issues.
• Risk & Governance – Ensure compliance with information governance, data security, and regulatory standards.
• Risk & Governance – Create and maintain migration documentation, including plans, logs, and data dictionaries.
• Team Leadership – Lead and coordinate data migration analysts, developers, and testers.
• Team Leadership – Provide guidance and technical expertise to internal and external teams.
• Team Leadership – Support end-user readiness through data insights and training materials where required.

What you will need

Essential

• Proven experience leading large‑scale data migration programmes, Oracle Fusion essential.
• Strong knowledge of ETL processes, tools, and data structures.
• Expertise in data quality, cleansing, and validation methodologies.
• Ability to interpret complex data sets and resolve data issues efficiently.
• Experience working with relational databases, SQL, and integration technologies.
• Excellent communication, documentation, and stakeholder engagement skills.
• Strong project planning skills, including risk and dependency management.

Desirable

• Experience with cloud platforms (Azure, AWS, GCP).
• Knowledge of master data management (MDM) principles.
• Experience working in regulated industries.
• Familiarity with Agile and Waterfall delivery methodologies.
• Understanding of information governance, GDPR, and data protection.

Not sure you meet every requirement? Research shows some people – particularly women and those from underrepresented backgrounds – may hesitate to apply unless they meet every criteria. At SGN, we value diverse backgrounds, experiences and perspectives. If this role interests you but you’re not sure you tick every box, we’d still love to hear from you. You might be just who we’re looking for – now or in the future.

Why SGN?

SGN is a leader in pioneering research and development toward a net‑zero energy system. Our cutting‑edge technologies and innovative thinking are driving change in the gas industry, all while keeping people safe and warm. SGN is an award‑winning employer, including CCA Gold Awards for 'Great Places to Work' and 'Inclusivity and Accessibility'.

If you require any accommodations or support during the application process, reach out to us. We're here to help ensure an inclusive and accessible experience for everyone.