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