Insight Data Analyst

SCS Railways; Greater London; On-site; GBP 65,000 - 90,000; Full time

Benefits offered by this job

Flexible working

Excellent benefits package

Job summary

SCS Railways is seeking a data analytics specialist to transform disparate project and financial data into proactive insights for senior stakeholders on HS2-related work in London.

You will combine cost, schedule, risk, and progress data with forecasts and scenarios, delivering concise narratives and executive-ready briefings that drive action. Strong Excel, Power BI, and communication skills are essential.

Qualifications

• Proven ability to model and interpret data using Excel, with advanced formulas and Power Query.
• Strong storytelling with data to explain trends and recommendations to senior audiences.
• Experience applying analytics in fast-paced project environments and influencing outcomes.
• Working knowledge of BI tools and data visualization for leadership reporting.

Responsibilities

• Analyse large, multi-source datasets (cost, schedule, risk, change, progress) to uncover trends, drivers, and anomalies.
• Perform time-series, regression, variance and sensitivity analyses; translate results into clear recommendations.
• Create fit-for-purpose visuals (e.g., small-multiple charts, run-charts, control charts) to evidence findings - no “dashboard factory.”
• Define and track leading KPIs and thresholds; set up alerts and watchlists for emerging risks.
• Partner with PMO/Project Controls/Finance to align insights with the reporting cycle and governance forums.
• Improve data quality and consistency; shape simple data models that make recurring analysis faster.

Skills

Advanced Excel

Power BI

Storytelling with data

Data analysis

Stakeholder communication

Tools

Primavera P6

SQL

Python

R

Azure

Job description

The following content displays a map of the jobs location - London

Competitive with excellent benefits package

Location:

London

Closing Date:

13/11/2026

Function:

Projectwide Services

Function:

Projectwide Services

Team:

Job Introduction

Purpose

Turn disparate project and financial data into clear, proactive insight -linking trends, early warnings, and predictive signals to decisions made by senior stakeholders and the leadership team. You’ll work with and around existing reporting requirements, adding analysis that explains the “why” and “what next,” not just the “what.”

Key Outcomes

• Early warning: Detect leading indicators of cost/schedule variance, risk exposure, and delivery slippage before they surface in monthly reporting.
• Predictive view: Build light‑weight forecasts and scenarios that quantify impact and recommend mitigations.
• Decision support: Deliver concise, executive‑ready narratives (one‑pagers, briefings) that drive action.

What You’ll Do

• Analyse large, multi‑source datasets (cost, schedule, risk, change, progress) to uncover trends, drivers, and anomalies.
• Perform time‑series, regression, variance and sensitivity analyses; translate results into clear recommendations.
• Create fit‑for‑purpose visuals (e.g., small-multiple charts, run‑charts, control charts) to evidence findings - no “dashboard factory.”
• Define and track leading KPIs and thresholds; set up alerts and watchlists for emerging risks.
• Partner with PMO/Project Controls/Finance to align insights with the reporting cycle and governance forums.
• Improve data quality and consistency; shape simple data models that make recurring analysis faster.

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.

The Ideal Candidate

What You’ll Bring

• Strong analytical toolkit: advanced Excel (modelling, Power Query, complex formulas), sound statistics, and storytelling with data.
• Working knowledge of Power BI for light modelling/visuals (deep dashboard development not required).
• Ability to join the dots across data, context, and delivery realities; crisp written and verbal communication for senior audiences.
• Experience operating in fast‑paced project environments and influencing through evidence.

Nice to Have (Desirable, not essential)

• Project Controls background (EV, cost & schedule analytics, trends, PMB, WBS) and/or Finance (budgeting, forecasting, variance).
• Ability to interpret Primavera P6 outputs (logic, slippage, float) and link schedule signals to cost/risk.
• Exposure to major infrastructure programmes.
• SQL and/or basic Python/R for heavier analysis or repeatable workflows
• Demonstrable experience in the development of reports and dashboards to a diverse set of stakeholders in a fast paced environmen
• Highly skilled in mainstream BI tools (including but not limited to Power BI
• Understand and promote data qualit
• Knowledge or experience with Extract Transform Load (ETL
• Knowledge with Azure integration services

About The Company

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

The Skanska | Costain | STRABAG (SCS JV) is delivering the HS2 London Tunnels Contract. Scope of works includes twin-bored tunnels (TBM), SCL tunnels, shaft sinking, bridge demolition and reconstruction, services diversions, earthworks and the construction of site compounds.

You’ll be a welcomed member of the wider team, with opportunities to take on additional responsibility, join our EDI Champions program or support 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 2018 and UK GDPR) 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.

We are an equal opportunity employer and value diversity at our company. we do not discriminate on the basis of age, disability, sex, race, religion or belief, gender reassignment, marriage/civil partnership, pregnancy/maternity, or sexual orientation

SCS Railways is a Disability Confident Leader. We want to encourage disabled people to apply for our roles and have an opportunity to display your skills, talent, and abilities. We will ensure that a fair and proportionate number of disabled applicants that meet the minimum criteria for this position will be offered an interview.

Please see the disability confident commitments:

To be considered for an interview under this scheme you have:

• A physical or mental impairment, which has a substantial and long-term effect (over 12 months) adverse effect on your ability to carry out normal day-to-day activities
• Demonstrated in your application and pre-interview stage that you meet the minimum job criteria and person specification for the role