Fusion People Ltd
City, London
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.
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.
MOTT MACDONALD
Do you want to work for a company whose purpose is to improve society by considering social outcomes, and to transform businesses, communities, and opportunities for it's employees? Mott MacDonald is a global consultancy whose people do exactly that. You could be just the right applicant for this job Read all associated information and make sure to apply. As Project Controller you will demonstrate a passion to work collaboratively with our client teams to deliver their complex projects to time, cost and quality with a commitment to safety. What you will contribute to the team; Analytical skills to prepare and critically evaluate performance measures (inc. earned value) and trends across multiple datasets Ability to focus on key issues, and drive out mitigating or recovery actions across the project Experience of implementing robust project controls processes and toolsets in relevant industries Candidate Specification Required for the position of Project Controller; Knowledge and proficiency with Primavera (P6) or Microsoft Project and/or other planning and resourcing software; Create and maintain project schedules that support and align with project requirements; Reduce uncertainty on projects by adapting project methodology; Project reporting including monitoring of KPIs; Educated to degree level and/or hold a project controls or management qualification (e.g. APMG Planning and Controls, EVM, PMQ, Prince2) Hold MOD security clearance (SC) or higher Flexibility to travel and work in different sectors and clients Preferred, but not required Support project managers in maintaining effective and timely change management processes Monitor and consolidate project plans PMO experience Knowledge or and experience using PowerBI Demonstrate some project controls and delivery experience; Demonstrable knowledge and application of project control methodologies; Ability to effectively analyse project schedule and cost performance Knowledge and experience applying earned value management Risk management and reporting including the use of ARM If you meet 80% or more of what we're looking for, please still apply. We understand not everyone will meet all the requirements, but you might have skills we didn't know we need. Job Profile About the business unit The Advisory and Programme Delivery (APD) unit delivers management services in all the sectors that Mott MacDonald operate in the Built Environment, Defence, Energy, Water, Transportation and, Education, Health and Care. The Unit delivers services to projects ranging in scale and complexity up to £20bn, through the technical disciplines of Programme Management, Project Management, Project Controls, Scheduling, Cost Management, Estimating, Infrastructure Finance, Management Consulting, Digital Consulting and Education, Health and Care Management. How to apply To apply for this role, please complete our 15-minute application via our website. Our talent acquisition coordinators aim to provide feedback within 5 working days with the outcome of your application. More information about our application process can be found here. If you have any questions regarding your application or the role, please reach out to the dedicated recruiter listed who will be more than happy to help. Mott MacDonald is Work180 accredited - which means we actively support and encourage women to join our work force! Benefits we offer: Pension matched up to 7% Life insurance An annual professional institution subscription Continuous development opportunities - because we want you to thrive Agile/flexible working - because life isn't 9-5 Enhanced parental leave; shared parental leave policies - for parents and care givers Annual company performance bonus scheme - Subject to company performance Flexible benefits that suit you, including cycle to work & interest free season ticket loans . The opportunity to make a difference; learn more about our social outcomes Other Information Equality, diversity and inclusion We put equality, diversity and inclusion at the heart of our business, seeking to promote fair employment procedures and practices to ensure equal opportunities for all. We encourage individual expression in our workplace and are committed to creating an inclusive environment where everyone feels they have the opportunity to contribute. If you have a disability and would prefer to apply in a different format or would like us to make reasonable adjustments to enable you to apply or attend an interview, please contact us at and we will talk to you about how we can assist. Agile working At Mott MacDonald, we believe it makes business sense for you and your manager to choose how you can work most effectively to meet your client, team and personal commitments. We embrace agility, flexibility and trust. More about Mott MacDonald We're a global engineering, management and development consultancy. Our purpose is to improve society by considering social outcomes in everything we do, relentlessly focusing on excellence and digital innovation, transforming our clients' businesses, our communities and employee opportunities. A fundamental part of this is respecting each person's differences and striving to meet their needs. Our values: progress, respect, integrity, drive, excellence
Do you want to work for a company whose purpose is to improve society by considering social outcomes, and to transform businesses, communities, and opportunities for it's employees? Mott MacDonald is a global consultancy whose people do exactly that. You could be just the right applicant for this job Read all associated information and make sure to apply. As Project Controller you will demonstrate a passion to work collaboratively with our client teams to deliver their complex projects to time, cost and quality with a commitment to safety. What you will contribute to the team; Analytical skills to prepare and critically evaluate performance measures (inc. earned value) and trends across multiple datasets Ability to focus on key issues, and drive out mitigating or recovery actions across the project Experience of implementing robust project controls processes and toolsets in relevant industries Candidate Specification Required for the position of Project Controller; Knowledge and proficiency with Primavera (P6) or Microsoft Project and/or other planning and resourcing software; Create and maintain project schedules that support and align with project requirements; Reduce uncertainty on projects by adapting project methodology; Project reporting including monitoring of KPIs; Educated to degree level and/or hold a project controls or management qualification (e.g. APMG Planning and Controls, EVM, PMQ, Prince2) Hold MOD security clearance (SC) or higher Flexibility to travel and work in different sectors and clients Preferred, but not required Support project managers in maintaining effective and timely change management processes Monitor and consolidate project plans PMO experience Knowledge or and experience using PowerBI Demonstrate some project controls and delivery experience; Demonstrable knowledge and application of project control methodologies; Ability to effectively analyse project schedule and cost performance Knowledge and experience applying earned value management Risk management and reporting including the use of ARM If you meet 80% or more of what we're looking for, please still apply. We understand not everyone will meet all the requirements, but you might have skills we didn't know we need. Job Profile About the business unit The Advisory and Programme Delivery (APD) unit delivers management services in all the sectors that Mott MacDonald operate in the Built Environment, Defence, Energy, Water, Transportation and, Education, Health and Care. The Unit delivers services to projects ranging in scale and complexity up to £20bn, through the technical disciplines of Programme Management, Project Management, Project Controls, Scheduling, Cost Management, Estimating, Infrastructure Finance, Management Consulting, Digital Consulting and Education, Health and Care Management. How to apply To apply for this role, please complete our 15-minute application via our website. Our talent acquisition coordinators aim to provide feedback within 5 working days with the outcome of your application. More information about our application process can be found here. If you have any questions regarding your application or the role, please reach out to the dedicated recruiter listed who will be more than happy to help. Mott MacDonald is Work180 accredited - which means we actively support and encourage women to join our work force! Benefits we offer: Pension matched up to 7% Life insurance An annual professional institution subscription Continuous development opportunities - because we want you to thrive Agile/flexible working - because life isn't 9-5 Enhanced parental leave; shared parental leave policies - for parents and care givers Annual company performance bonus scheme - Subject to company performance Flexible benefits that suit you, including cycle to work & interest free season ticket loans . The opportunity to make a difference; learn more about our social outcomes Other Information Equality, diversity and inclusion We put equality, diversity and inclusion at the heart of our business, seeking to promote fair employment procedures and practices to ensure equal opportunities for all. We encourage individual expression in our workplace and are committed to creating an inclusive environment where everyone feels they have the opportunity to contribute. If you have a disability and would prefer to apply in a different format or would like us to make reasonable adjustments to enable you to apply or attend an interview, please contact us at and we will talk to you about how we can assist. Agile working At Mott MacDonald, we believe it makes business sense for you and your manager to choose how you can work most effectively to meet your client, team and personal commitments. We embrace agility, flexibility and trust. More about Mott MacDonald We're a global engineering, management and development consultancy. Our purpose is to improve society by considering social outcomes in everything we do, relentlessly focusing on excellence and digital innovation, transforming our clients' businesses, our communities and employee opportunities. A fundamental part of this is respecting each person's differences and striving to meet their needs. Our values: progress, respect, integrity, drive, excellence
