Insight Data Analyst: Predictive Insights for Projects

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

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.