Power BI Developer

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., 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

• 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), * 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