Data Lead

Balfour Beatty VINCI; Birmingham; On-site; GBP 40,000 - 60,000; Full time

Benefits offered by this job

Flexible working available

Travel allowance

Family friendly leave policies

Health risk assessments

Access to employee assistance programmes

Job summary

A leading construction firm is seeking a P2P Data Lead in Birmingham to enhance their operations on a major infrastructure project. The role requires advanced proficiency in Power BI, experience in workflow automation, and strong data preparation skills. The successful candidate will lead BI reporting, design data models, and ensure data quality. They will work within a diverse team on one of the UK's largest construction efforts, promoting equal opportunities and varied work environments.

Qualifications

• Advanced proficiency in Power BI, including complex data preparation and visualisation.
• Expertise in integrating data from diverse sources such as ERP systems and cloud services.
• Ability to design and deploy automated workflows for data synchronisation.

Responsibilities

• Lead enterprise-level Power BI reporting to track PTP KPIs.
• Design and maintain scalable data models using Power Query and DAX.
• Deliver process automation solutions with Power Automate and Power Apps.

Skills

Power BI proficiency

DAX measures development

Power Platform expertise

Data preparation and transformation

Advanced Microsoft Excel capability

Tools

Power Query

Microsoft Forms

Oracle

AP systems

SQL

Job description

Overview

Are you looking to progress your career by working on Britain’s biggest construction project?

Balfour Beatty VINCI is working with a range of organisations to design and build 90km West Midlands stretch of HS2 - Britain’s new high speed railway. Our work is essential to enable HS2 trains to travel between London and Birmingham as well as continue their journey up to Manchester. It’s an incredibly exciting time to join us - we’re at peak construction with work really ramping up on a broad range of assets including bridges, tunnels and viaducts. Plus you’d join 9,000 people across 72 nationalities working on this exciting section of HS2 across the region.

We currently have an exciting opportunity to join our team as a P2P Data Lead within the Finance and Systems Function. This role will be based on site in Birmingham.

Role Responsibilities

Responsibilities

• Lead enterprise-level Power BI reporting to track and analyse key PTP KPIs (RFT, POT, invoice ageing, unmatched invoices, supplier performance), supporting insight-driven decision-making.
• Design, build, and maintain scalable data models using Power Query, DAX, and robust data architecture principles.
• Develop and manage consolidated datasets integrating data from Oracle, AP systems, query tools, and Site Support sources.
• Own and deliver process automation solutions using Power Automate, Power Apps, and Microsoft Forms to streamline workflows and reduce manual effort.
• Prepare, transform, and integrate data from multiple systems, identifying data quality issues and leading remediation activities.
• Establish and maintain high data quality standards to improve invoice matching, reduce rework, and support audit and compliance requirements.

Experienced required

• Advanced proficiency in Power BI, including complex data preparation, modelling, visualisation, and dashboard management.
• Strong capability in developing advanced DAX measures, KPIs, calculations, and interactive reports.
• Expertise in the Microsoft Power Platform, including Power Automate workflow automation, Power Apps development, and Microsoft Forms design.
• Ability to design and deploy automated workflows for approvals, alerts, escalations, data synchronisation, and process controls.
• Proven experience connecting to and integrating data from diverse sources such as ERP systems, AP platforms, SharePoint, Excel, SQL, and cloud services.
• Strong data preparation and transformation skills using Power Query (M language), ensuring clean, structured, and reliable datasets.
• Experience designing scalable data models, managing relationships, hierarchies, KPIs, and DAX-based business logic.
• Ability to produce clear, insightful data visualisations and apply analytical reasoning to identify trends, anomalies, root causes, and improvement opportunities.
• Advanced Microsoft Excel capability, including Power Query, data modelling, complex formulas, and Power Platform integrations.

Other requirements

Please note candidates will need to have a current valid right to work in the UK to be considered for this role.

Benefits

• Flexible working available for some roles
• Travel allowance for eligible candidates
• Family friendly leave policies
• Health risk assessments
• Access to employee assistance programmes
• Access to annual flu vaccinations

About Balfour Beatty VINCI

Balfour Beatty VINCI is a long-established joint venture between two powerhouses for the delivery of critical infrastructure across rail, transport and other iconic projects in the UK and beyond. We started working together over 30 years ago to deliver the Channel Tunnel, as members of the TransManche Link consortium. In the Midlands, it is Balfour Beatty VINCI’s role to design and build the route, ready for tracks and signalling to be installed. Our work with HS2 Balfour Beatty VINCI have been awarded a 90km section of the HS2 project from Long Itchington in Warwickshire to the centre of Birmingham and then on to Handsacre in Staffordshire.

Overall, we will be building the following across all our sites:

• 9.3km of viaducts
• 2 twin bore tunnels and 2 cut and cover tunnels
• 28 underbridges and 11 underpasses

Diversity and Inclusion

Balfour Beatty VINCI (BBV) is delivering equal opportunities for everyone that is part of the team and for people that are yet to join us. We are an inclusive employer and welcome people from all backgrounds to come and join our team, including people with different physical abilities and neurodiversities. We are working to represent the communities Balfour Beatty VINCI works in through our workforce. We have embedded Equality, Diversity and Inclusivity (ED&I) Champions across our sites and are guided by strong accreditations that ensure we demonstrate our ability to support our people effectively. We care about being inclusive and that means we encourage applications from people with diverse set of backgrounds and experiences. BBV is a Disability Confident Leader and we welcome applications from candidates with a disability.

We recognise and respect that people work in different ways and we are open to discussing what flexibility you may need during the recruitment process, balanced against our project requirements.