Data Engineering Lead - Value & Analytics

Location: London or Edinburgh

Working pattern: Hybrid working

Start date: ASAP

Employment type: Permanent

Salary: £38,000 - £46,000 (+ £3,300 London Weighting)

Level: Senior

The Opportunity

A leading international organisation specialising in education, cultural relations and global collaboration is looking for a Data Engineering Lead to join its Value Management function.

You will build the technical infrastructure that provides visibility of portfolio performance, strategic value and benefits realisation across a complex global organisation. Taking ownership of the data engineering and analytics capabilities behind the organisation's Value Dashboard, you will integrate financial, project and operational information into a consistent and automated view of performance.

Working with senior stakeholders across Digital and Technology, Finance, Portfolio Management and executive leadership, you will turn fragmented data into reliable evidence that supports investment, prioritisation and resource decisions.

The Role

You will provide the technical engine for the Value Management Office, designing and maintaining the pipelines, models and dashboards used to track portfolio performance, benefits realisation and strategic return on investment.

While portfolio and strategy teams define what value should be measured, you will own how the information is captured, integrated, automated and presented to leadership and board-level audiences.

Key Responsibilities

* Design and implement automated data pipelines connecting operational, financial and project management systems, including Jira, Azure DevOps and SAP

* Build and maintain executive dashboards using Power BI, Microsoft Fabric, Tableau or similar tools

* Visualise objectives, OKRs, KPIs, benefits and actual versus forecast return on investment

* Develop scalable data models that connect portfolio activity and project outputs to strategic objectives

* Create a trusted single source of truth for prioritisation, investment decisions and resource allocation

* Engineer automated alerts and reporting to identify declining value or performance

* Translate business-case and benefits metrics into reliable technical data models

* Manage the analytics engineering life cycle from ingestion and ETL or ELT through to Front End visualisation

* Define technical standards for value-tracking tools, data models and performance analytics

* Ensure leadership reporting is accurate, auditable, secure and compliant with governance requirements

* Promote data transparency and access to trusted performance information

* Connect information from fragmented business units and systems while maintaining consistent definitions and metadata

* Work with Portfolio, Product and Finance teams to improve the quality and automation of value reporting

* Design solutions that scale as organisational priorities, portfolio structures and reporting requirements change

* Maintain documentation covering data lineage, models, interfaces, controls and reporting standards

Essential Experience

* Strong experience in data modelling, solution design, metadata management, coding, testing and delivering data engineering solutions

* Advanced Power BI and/or Microsoft Fabric experience creating executive-level dashboards

* Experience with ETL or ELT tools, Scripting, data warehouses and data lakes

* Experience integrating fragmented data from operational, financial and project management systems

* Experience supporting major digital transformation or change programmes across multiple technology domains

* Strong cloud knowledge across Azure, AWS, SaaS, IaaS or PaaS environments

* Understanding of cyber security, data governance and regulatory requirements

* Strong business systems analysis skills and the ability to connect technical data to financial and strategic value

* Ability to present complex data through intuitive dashboards for non-technical senior stakeholders

* Excellent written and verbal communication skills

* Fluency in English

Desirable Experience

* Experience within a Value Management Office, PMO or strategy-led data function

* Experience in financial modelling, benefits realisation or commercial performance analytics

* Previous line management experience

* Experience within a large, international or highly complex organisation

* Microsoft Fabric, Power BI, Tableau, data engineering or related professional certification

* Degree or equivalent experience in Computer Science, Information Technology, Data Engineering or a related discipline

* Experience designing solutions in complex environments where data is distributed across multiple business units

* Ability to lead technical discussions, challenge assumptions and recommend pragmatic engineering approaches

Important Information

* Applicants must be a UK resident

* Applicants must have the unrestricted right to work in the UK

* No visa sponsorship is available for this role

* This position is offered on a hybrid basis, with no fully remote option

* A regular physical presence in the office is required for the success of the role

* The exact hybrid working pattern may vary depending on the selected office location

* Salt contact: Robert Sprigens - (see below)

The full job description will be discussed during a telephone call if the candidate is interested and considered suitable for the role.

*Rates depend on experience and client requirements