Insight Data Analyst

Skillset: Power BI (expert), Data Visualisation, Data Modelling, DAX, SQL, Reporting, Insight Generation, The role sits within the Programme Management Office (PMO), supporting the delivery of complex infrastructure programmes through high-quality data, reporting, and insight.

We are seeking a Senior Power BI Data Analyst to lead the development of impactful dashboards and reporting solutions that provide transparency on performance, risks, and delivery progress.

This role is focused on turning programme data into clear, actionable insights, supporting senior stakeholders in informed decision-making.

Key Responsibilities

• Lead the design and delivery of Power BI dashboards and reporting solutions aligned to PMO and programme needs

• Develop and maintain data models to enable accurate, consistent, and scalable reporting

• Create clear, intuitive visualisations that communicate programme performance, trends, and risks

• Own the end-to-end reporting lifecycle from requirements gathering through to delivery and optimisation

• Work closely with PMO, project controls, and delivery teams to define KPIs and reporting standards

• Translate complex datasets into meaningful insights and narratives for senior stakeholders

• Develop DAX measures and calculations to support advanced analytics

• Promote best practice in Power BI development, usability, and performance optimisation

• Support and enable self-service reporting across the programme where appropriate

• Monitor and improve data quality and consistency across multiple sources

• Produce regular and ad hoc reporting packs for governance forums and leadership

• Provide benchmarking, trend analysis, and forward-looking insights

management using a reporting tool

• Understand the Client and Joint Venture Partners’ Environment and Sustainability Policies, Processes and statutory requirements as they affect the company’s operations and ensure that the requirements, as applicable within their discipline, are implemented on the project., In addition to the above discipline role, the Senior Data Analyst must carry out their duties in accordance with the SCS JV Core Values:

About us:

The role will work on the HS2 project. HS2 is the UK’s new high speed rail network. It will be a catalyst for economic growth across Britain, freeing up space on the existing railways and connecting 8 out of the UK’s 10 biggest cities with fast, reliable and frequent high speed services

You’ll be a welcomed member of the wider team, with opportunities to take on additional responsibility, join one of our networks for women, military or LGBT+ staff, and participate in cultural and social events with the local community (e.g. as a STEM ambassador).

Your personal and professional development is important to us. We welcome a discussion about how we can support you with further study, or professional membership or attainment for example.

HS2 - working with Skanska, Costain and STRABAG, closely monitors job applications, to ensure an inclusive recruitment process. To ensure we are able to maintain this, and to recruit a diverse workforce, we require candidates to complete the diversity form as part of their application so we are able to monitor and improve our approach to diversity. Please note, all responses are anonymous and we will not share any of your data with other parties. All data will be held securely, (as stated within the Data Protection Act 1998) and will be reported to HS2.

It is an SCSJV requirement that all employees, Design House, and Supply Chains must implement and comply with the requirements of ISO 9001:2015 Quality Management System, ISO 14001:2015 Environmental Management System with guidance for use”, OHSAS 18001:2017 Occupational Health and Safety Management Systems and ISO/IEC 27001:2013 Information Security Management System, Policies, Plans, Procedures and Processes, and statutory requirements as they affect the Joint Venture ‘s operations and ensure that the requirements, as applicable within their discipline, are effectively implemented on the project. Develop a culture of safety on the project through the absolute commitment to the Zero Accidents target and ethos, and develops a wider awareness of quality, environmental issues and demonstrates commitment to achieve continual improvement and Zero tolerance.

• Strong experience delivering Power BI dashboards and reporting solutions in a complex environment

• Advanced capability in DAX, Power Query (M), and data modelling techniques

• Proven ability to translate business requirements into effective reporting and visualisations

• Experience working with large and complex datasets

• Strong understanding of reporting for programme / project environments (PMO, project controls, performance reporting)

• Excellent stakeholder engagement and communication skills

• Ability to present insights clearly to non-technical audiences and senior leadership

• Strong attention to data quality, accuracy, and detail

Working hours: Weekdays

Contract: Permanent

Flexible working: We welcome you to ask about the flexibility you need. This might be part-time, remote working, or compressed hours for example. Anyone who applies for a role can ask about flexibility at interview. In return, we will explore what is possible for the role.