The Role
Supports project controls data analysis, modelling, benchmarking, dashboard development, and periodic reporting for major infrastructure projects. Manages schedule, cost, risk, change, quality, and KPI data; develops performance measurement systems including Earned Value Management; performs root-cause and trend analysis; and presents insights to leadership. The role also contributes to digital transformation, workflow design, stakeholder management, and continuous improvement across the HS2 programme.
Summary Generated by Built In
Salary: c£40,530.60pa to £47,683.60pa (inclusive of a flexible benefits fund of 15%) depending on skills and experience. As well, we offer a range of competitive benefits - check them out in the Benefits section on our website.
HS2 Ltd endeavours to ensure everyone working for us and with us feels included, thrives and achieves their full potential. In practice, this means we are positive and inclusive about making adjustments, providing flexible working, encouraging our staff networks to flourish and providing personal and professional development opportunities.
As a Data Analyst at HS2 Ltd you will support the Senior Data Analyst by delivering accurate and timely data analysis, modelling, and reporting. Your work will generate valuable insights that inform investment decisions and drive performance improvements across the Data Intelligence Team.
About the Role
- Assist in the development of a comprehensive benchmarking database and contribute to the reporting process to deliver timely, accurate insights that support informed decision-making.
- Responsible for developing and maintaining robust data models that support interactive dashboard visualizations, enabling management to identify key issues and take informed action through root cause analysis evaluation.
- Analysing construction project control processes and interrogating client workflows to design and document business processes with a focus on digital transformation.
- Responsible for periodic and ad-hoc reporting, taking ownership for its quality, accuracy, and robustness, and ensure the monthly project review pack is compiled and presented to the leadership team on time.
- Support the Senior Project Controls Data Analyst to establish, monitor, and manage the Performance Measurement Baseline (PMB) and periodically collate KPIs & progress data related to time, cost, risk, change and quality to report to senior leaders of the project.
- Contribute to the development and implementation of a robust performance measurement system such as Earned Value Management and ensure its integration into periodic reporting frameworks.
- Support the integration of schedule, cost, scope, quality, change, and risk data to deliver a comprehensive view of project health and analyse the insights within the monthly reporting pack to enable timely and informed decision-making.
- Share lessons learned and best practice within the Project Controls community.
- Support the Senior Data Analyst in the production of regular and ad-hoc MI and progress reports at the relevant level (Contract, Phase or HS2 Programme).
- Manage large volumes of data and the analysis of performance data, identifying key trends and issues, articulating analysis through appropriate charts and summary narratives, to inform business decisions.
- Manage large volumes of cost data from both internal and external sources and will be responsible for converting this into meaningful intelligence.
- Actively promote and embed Equality Diversity and Inclusion (EDI) in all your work, and support and comply with all organisational initiatives, policies and procedures on EDI.
About You
Skills
- Membership of RICS, ACostE, ICES, or a similar relevant professional association, and degree qualified or equivalent experience, or achieved NVQ Level 2 in Project Controls. Additional certifications such as APM PFQ, PMQ, or EVM are highly desirable.
- Ability to develop an analysis of external influencing factors such as inflation and market trends.
- Proficient in Power BI and MS Excel, with experience working across varied complex datasets to develop interactive dashboards and extract meaningful business and performance insights.
Knowledge
- Knowledge of the Microsoft Power Suite of applications, able to use Power Apps, Power Automate and Power BI to build input forms, develop workflow processes and generate attractive & interactive visualisation.
- Working knowledge of schedule management, cost management and risk management principles.
- Ability to manage stakeholders and information flow in a matrix environment, possessing a strong aptitude toward working horizontally across business areas, providing specialist advice as required.
- Knowledge of transport, energy, major infrastructure, or construction projects (under NEC Forms of Contract), specifically surrounding client and consultancy.
- A continuous improvement mindset.
Type of Experience
- Proven experience in Project Controls and Data Analysis, delivering key products within large-scale infrastructure projects and applying hands-on methodologies to support successful project delivery.
- Proven experience in transforming and structuring large datasets using Power Query, and skilled in advanced data analysis with DAX (Data Analysis Expressions) for generating deep insights and calculations.
- Expertise in Advanced Excel, including complex formulas, pivot tables, data visualization, and automation to support robust data analysis and reporting.
We ask for a variety of detail in your online application, however we perform the first assessment of suitability for a role based solely on the information in your CV. In a further development of our efforts to create a more diverse workforce, your CV will be anonymised and personal information will be removed during the first stage of the application review. This removes bias from the process and makes it even more important that you attach an updated word version of your CV for each new application ensuring you include evidence directly related to the criteria in the job advert. Watch this video on how we remove bias in the recruitment process: Removing bias in the recruitment process - YouTube
Any applications received after the closing date will not be considered.
High Speed 2 (HS2 Ltd) will be the UK’s new high speed rail network. As well as improving capacity, the new scheme will shorten journey times between a number of Britain’s major population centres, boost the economy and create thousands of jobs.
HS2 Ltd will create a skills legacy and develop a diverse range of talent. We aim to be a leader in EDI practice by creating a safe & inclusive working environment for all our staff - living our values of Safety, Respect, Integrity and Leadership.
In practice, this means we are positive and inclusive about making adjustments, providing flexible working, encouraging our staff networks to flourish and providing personal and professional development opportunities.
HS2 Ltd is also a safety-critical organisation. Employees are required to ensure reasonable care of their own and others’ health and safety by taking personal responsibility for working to our ‘Safe at Heart’ programme principles and following safe working procedures at all times.
HS2 Ltd endeavours to ensure everyone working for us and with us feels included, thrives and achieves their full potential.
Skills Required
- Membership of RICS, ACostE, ICES, or a similar relevant professional association, plus a degree or equivalent experience, or NVQ Level 2 in Project Controls
- APM PFQ, PMQ, or Earned Value Management certification
- Ability to analyse external influencing factors such as inflation and market trends
- Proficiency in Power BI and Microsoft Excel
- Experience working with complex datasets to develop interactive dashboards and business insights
- Knowledge of Microsoft Power Apps, Power Automate, and Power BI
- Knowledge of schedule, cost, and risk management principles
- Ability to manage stakeholders and information flow in a matrix environment
- Knowledge of transport, energy, major infrastructure, or construction projects, including NEC Forms of Contract
- Proven experience in project controls and data analysis on large-scale infrastructure projects
- Experience transforming and structuring large datasets using Power Query
- Advanced data analysis skills using DAX
- Advanced Excel skills, including complex formulas, pivot tables, data visualisation, and automation
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
High Speed Two (HS2) Limited is responsible for developing and promoting the UK's new high-speed rail network. HS2 is Britain's new high-speed railway, designed to provide fast, reliable journeys between major cities while freeing capacity on the existing network for regional and freight services. The project also aims to widen access to jobs, drive investment, and support regional growth through an economic corridor.
