Lead Data Engineer

Data Engineering Lead required by our client an international educational establishment to provide the technical engine for the Value Management Office automating the visibility of portfolio performance and benefit realization across the organization. It is responsible for building and maintaining the “Value Dashboard,” ensuring that data from disparate systems (Finance, Project Management, and Operations) is integrated to provide a real-time view of strategic ROI. The role holder defines technical standards for value-tracking tools and creates automated data objects that link project outputs to the organisation’s strategic objectives., ·Automated Value Pipeline: Design and implement complex data flows that connect operational systems (e.g., Jira, Azure DevOps), financial systems (e.g., SAP) and other systems to automate benefit tracking.

·Executive Dashboarding: Build and maintain high-fidelity interactive dashboards (Power BI/Tableau) that visualize OKRs, KPIs, and actual vs. forecasted ROI.

·Integration Architecture: Apply knowledge of systems integration to create a “Single Source of Truth” for portfolio prioritization and resource allocation.

·Value-Drift Monitoring: Engineering automated alerts and reporting systems that flag when an initiative’s value case begins to erode based on real-time data.

·Stakeholder Collaboration: Partner with the Portfolio Lead, Product Manager and Financial Analyst to translate complex business case metrics into scalable data models.

·Data Quality Governance: Adhere to best practices and standards to ensure that performance data surfaced to senior leadership is accurate, audited, and compliant.

·Full-Stack Analytics Engineering: Mastery of the lifecycle from data ingestion (ETL/ELT) to front-end visualization.

·Business Systems Analysis: Ability to map technical project metadata to financial value metrics.

·Stakeholder Communication: Experience in translating technical data structures into presentable, intuitive interfaces for non-technical senior leaders.

·Complex System Design: Applying design skills to environments where data is highly fragmented across different business units.

Role specific knowledge and experience

Minimum / essential

·Experience in data modelling, metadata management, design, coding, testing and delivery of data engineering solutions.

·Experience in supporting large change projects / programmes covering digital transformation and multiple technology architecture domais.

·Advanced proficiency in Power BI and/or Microsoft Fabric to create professionalgrade executive dashboards.

·Experience with ETL tools, scripts, and data storage methods (Data Warehousing / Data Lakes) used for performance analytics.

·Experience with cloud technologies such as SaaS, IaaS, PaaS etc. and / or multi cloud infrastructure and network capabilities (Azure, AWS, public / private cloud, etc).

·Experience in Cyber Security best practices and regulations.

·Professional Qualification and Certification

·Microsoft certified Data Engineer

Desirable

·Experience in a VMO, PMO, or Strategy-led data function.

·Background in financial modelling or commercial performance analytics.

·Microsoft Certified: Fabric Analytics Engineer Associate or Power BI Data Analyst Associate

·Line management experience.

The roles are offered on a permanent basis, and can be based anywhere in the UK and offer a salary £38,000 - £46,000 (plus £3,300 for London based candidates where applicable.

The successful candidate will also enjoy a first-class benefits including attractive pension scheme (employer contributions up to 22%) and 32 days holiday plus bank holidays package. Please forward your CV to our Consultant Elaine Hallworth for further information.

True