Power BI Developer - Construction, Rail & Civil Engineering

Department:

Commercial / Project Controls / Digital & Data

Reports To:

Head of Project Controls / Digital Transformation Manager

Location:

Working from home

Employment Type:

Contract - (Outside IR35)

Role Overview

We are seeking an experienced Power BI Developer to support major infrastructure, rail, and civil engineering projects by delivering high-quality business intelligence and data analytics solutions.

The successful candidate will work closely with Project Managers, Commercial Managers, Planners, and Senior Leadership teams to transform complex cost, programme, and operational data into clear, actionable dashboards that support performance improvement, cost control, and strategic decision-making.

Key Responsibilities

1. Reporting & Dashboard Development

• Design, develop, and maintain interactive dashboards and reports
• Produce reporting for:
• Cost Value Reconciliation (CVR)
• Earned Value Management (EVM)
• Programme performance (SPI / CPI)
• Resource and plant utilisation
• Risk and opportunity registers
• Health & Safety KPIs
• Develop executive-level portfolio dashboards across multiple projects
• Automate monthly reporting packs and board reports
• Ensure dashboards are visually clear, accurate, and aligned with business KPIs

2. Data Integration & Modelling

• Integrate data from ERP, planning, commercial, and site systems
• Develop and maintain robust data models
• Create advanced DAX measures and calculations
• Optimise report performance and data refresh processes
• Ensure data accuracy, governance, and consistency across systems

3. Project Controls & Commercial Support

• Support cost forecasting and trend analysis
• Monitor project margins, cash flow, and cost-to-complete
• Provide scenario modelling and performance insights
• Support change management and commercial reporting requirements
• Assist in developing standardised reporting frameworks across projects

Technical Skills & Experience

• Advanced Power BI development experience (Desktop & Service)
• Strong knowledge of DAX and Power Query (M language)
• Proficiency in SQL and relational databases
• Experience working with construction, rail, or civil engineering datasets
• Understanding of:
• Project controls processes
• Earned Value Management principles
• Programme performance metrics
• Commercial reporting structures
• Experience integrating with Excel and enterprise systems
• Exposure to cloud-based data environments (desirable)

Qualifications

• Degree in Data Analytics, Engineering, Construction Management, or related discipline
• Minimum 3+ years' experience in Business Intelligence within construction, rail, or infrastructure sectors
• Relevant Microsoft certification (e.g., Power BI Data Analyst) desirable

Key Competencies

• Strong commercial awareness
• Analytical and problem-solving mindset
• Ability to interpret engineering and programme data
• Excellent stakeholder engagement skills
• High attention to detail and data accuracy
• Ability to manage multiple project deadlines

Desirable Experience

• Experience on major infrastructure frameworks
• Familiarity with NEC or JCT contracts
• Knowledge of project lifecycle reporting (tender through to handover)
• Experience supporting multi-project or portfolio-level reporting

If you are interested in hearing more please contact John Baker or Kat Oxlade

Fusion People are committed to promoting equal opportunities to people regardless of age, gender, religion, belief, race, sexuality or disability. We operate as an employment agency and employment business. You'll find a wide selection of vacancies on our website.