Insight Data Analyst

Skanska Costain STRABAG JV; Greater London; On-site; GBP 42,000 - 65,000; Full time

Job summary

Skanska Costain STRABAG JV is delivering the HS2 London Tunnels Contract and seeks a data analyst to analyse multi-source data, build lightweight forecasts, and create executive-ready visuals for senior stakeholders in London.

You will partner with PMO and Finance to align insights with reporting cycles, improve data quality, and support decision-making within a fast-paced infrastructure programme.

Qualifications

• Advanced Excel with modelling, Power Query, and complex formulas.
• Sound knowledge of statistics and data storytelling.
• Working knowledge of Power BI for light modelling and visuals; deep dashboard development not required.
• Ability to connect data, context, and delivery realities.
• Clear written and verbal communication for senior audiences.
• Experience working in fast-paced project environments and influencing through evidence.

Responsibilities

• Analyse multi-source cost, schedule, risk, change, and progress data to uncover trends, drivers, and anomalies.
• Perform time-series, regression, variance, and sensitivity analyses, translating results into recommendations.
• Create fit-for-purpose visuals to evidence findings.
• Define and track leading KPIs and thresholds, and set up alerts and watchlists for emerging risks.
• Partner with PMO, Project Controls, and Finance to align insights with reporting cycles and governance forums.
• Improve data quality and consistency, and shape simple data models to speed up recurring analysis.
• Develop lightweight forecasts and scenarios that quantify impact and recommend mitigations.
• Deliver concise, executive-ready narratives, including one-pagers and briefings, that drive action.
• Implement applicable quality, EH&S, and information security requirements on the project.
• Develop a project safety culture, support the Zero Accidents target, and promote awareness of quality and environmental issues and continual improvement.

Skills

Advanced Excel

Power BI

Statistics

Data storytelling

Communication

Fast-paced

Stakeholder influence

Tools

SQL

Python

Job description

Описание:

The HS2 project is the UK's new high-speed rail network, connecting 8 of the UK's 10 biggest cities with fast, reliable and frequent services. The Skanska | Costain | STRABAG Joint Venture is delivering the HS2 London Tunnels Contract, including twin-bored tunnels, SCL tunnels, shaft sinking, bridge demolition and reconstruction, services diversions, earthworks, and site compounds.

Задачи:

• Analyse multi-source cost, schedule, risk, change, and progress data to uncover trends, drivers, and anomalies
• Perform time-series, regression, variance, and sensitivity analyses, translating results into recommendations
• Create fit-for-purpose visuals to evidence findings
• Define and track leading KPIs and thresholds, and set up alerts and watchlists for emerging risks
• Partner with PMO, Project Controls, and Finance to align insights with reporting cycles and governance forums
• Improve data quality and consistency, and shape simple data models to speed up recurring analysis
• Develop lightweight forecasts and scenarios that quantify impact and recommend mitigations
• Deliver concise, executive-ready narratives, including one-pagers and briefings, that drive action
• Implement applicable quality, environmental, health and safety, and information security requirements on the project
• Develop a project safety culture, support the Zero Accidents target, and promote awareness of quality and environmental issues and continual improvement

Требования:

• Advanced Excel skills, including modelling, Power Query, and complex formulas
• Sound knowledge of statistics and data storytelling
• Working knowledge of Power BI for light modelling and visuals; deep dashboard development is not required
• Ability to connect data, context, and delivery realities
• Clear written and verbal communication for senior audiences
• Experience working in fast-paced project environments and influencing through evidence
• Applicants considered under the Disability Confident scheme must have a substantial and long-term physical or mental impairment affecting day-to-day activities and demonstrate that they meet the minimum job criteria and person specification at the application and pre-interview stage

Будет плюсом:

• Project Controls or Finance background, Primavera P6, exposure to major infrastructure programmes, SQL, basic Python or R, report and dashboard development for diverse stakeholders, mainstream BI tools, data quality knowledge, ETL experience, Azure integration services

Условия:

Локация: Лондон

• Applicants may ask about part-time work or compressed hours; flexibility will be explored for the role
• Applicants must complete the diversity form as part of their application. Responses are anonymous, securely held, and reported to HS2 Employees, Design House, and Supply Chains must comply with the specified quality, environmental, occupational health and safety, and information security management systems, policies, plans, procedures, processes, and statutory requirements
• The employer offers opportunities to take on additional responsibility, join the EDI Champions program, or support the local community, for example as a STEM ambassador
• The employer welcomes discussions about support for further study, professional membership, or attainment