Project Controls Data & Reporting Analyst

AtkinsRéalis; Greater London; Hybrid; GBP 45,000 - 65,000; Full time

Job summary

AtkinsRéalis is seeking a data modelling and dashboard support professional to help build and maintain data models, dashboards and performance reporting within the Project Controls function. You will work with senior team members to deliver high-quality insights that support decision-making on complex projects, with opportunities to deepen Power BI capabilities.

The role covers data modelling, dashboard delivery, KPI collation, and reporting packages, including monthly project reviews.

Qualifications

• Demonstrable experience transforming and organising data sets using Power Query or similar tools.
• Experience developing structured data models incorporating fact and dimension tables, with the ability to define and manage relationships within Power BI.
• Proficiency in data manipulation and analysis, preferably with exposure to DAX for calculations and insights.
• Experience creating or supporting the development of Power BI dashboards, with an understanding of translating data into visual insights.
• Strong Advanced Excel skills including formulas, pivot tables, visualisation techniques, and automation.
• Knowledge of the Microsoft Power Platform (Power Apps, Power Automate, Power BI) to support workflow creation, data capture and visualisation.
• Experience working within a Project Controls environment on large or complex construction or infrastructure programmes.
• Understanding of schedule, cost and risk management principles.
• Previous involvement in a Project Controls team within a major project setting.
• Awareness of transport, energy, infrastructure or construction sectors, including familiarity with NEC contract environments.

Responsibilities

• Assist in developing and maintaining structured data models that underpin interactive dashboard visualisations.
• Support the delivery of dashboards that highlight performance trends and areas of concern through clear, actionable insights.
• Contribute to root cause analysis by preparing, organising, and validating data used in reporting outputs.
• Develop an understanding of construction project controls processes and help document business processes with digitalisation in mind.
• Work with senior team members to ensure reporting inputs adhere to agreed processes and quality standards.
• Assist in preparing periodic and ad-hoc reports, ensuring accuracy, consistency, and timely submission.
• Help collate KPIs and progress data related to time, cost, risk, change, and quality.
• Contribute to development and implementation of performance measurement systems, such as Earned Value Management (EVM).
• Help integrate schedule, cost, scope, quality, risk and change data to provide a holistic view of project health.
• Participate in continuous improvement of reporting tools and data processes within the Project Controls community.

Skills

Power BI

Advanced Excel

DAX

Power Query

Power Platform knowledge

Project Controls experience

Data manipulation

Data analysis

Schedule, cost & risk understanding

Tools

Power BI

Power Apps

Power Automate

Excel

Job description

Overview

In this role, you will support the development and maintenance of data models, dashboards, and performance reporting within the Project Controls function. Working closely with senior team members, you will contribute to producing high‑quality insights that enable effective decision‑making across the project. This position offers the opportunity to build deeper capability in Power BI, project controls processes, and data analysis within a fast‑paced project environment.

Overview

In this role, you will support the development and maintenance of data models, dashboards, and performance reporting within the Project Controls function. Working closely with senior team members, you will contribute to producing high‑quality insights that enable effective decision‑making across the project. This position offers the opportunity to build deeper capability in Power BI, project controls processes, and data analysis within a fast‑paced project environment.

A pre‑screening technical test will be required as part of the recruitment process.

Your role

Data Modelling & Dashboard Support

• Assist in developing and maintaining structured data models that underpin interactive dashboard visualisations.
• Support the delivery of dashboards that highlight performance trends and areas of concern through clear, actionable insights.
• Contribute to root cause analysis by preparing, organising, and validating data used in reporting outputs.

Project Controls Process Support

• Develop an understanding of construction project controls processes and help document business processes with digitalisation in mind.
• Work with senior team members to ensure reporting inputs adhere to agreed processes and quality standards.

Reporting & Performance Insights

• Support the preparation of periodic and ad‑hoc reports, ensuring accuracy, consistency, and timely submission.
• Assist in compiling the monthly project review pack and ensuring information flows effectively to senior stakeholders.
• Help collate KPIs and progress data related to time, cost, risk, change, and quality.

Performance Measurement & Integration

• Contribute to the development and implementation of performance measurement systems, such as Earned Value Management (EVM), under guidance from senior team members.
• Help integrate schedule, cost, scope, quality, risk, and change data to create a holistic view of project health.
• Provide initial interpretation of monthly reporting outputs to support timely decision‑making.

Continuous Improvement

• Participate in sharing lessons learned and identifying opportunities to improve reporting, tools, and data processes within the Project Controls community.

About You

• Demonstrable experience in transforming and organising data sets using Power Query or similar tools.
• Experience in developing structured data models incorporating fact and dimension tables, with the ability to define and manage relationships within Power BI.
• Competency in data manipulation and analysis, preferably with exposure to DAX for calculations and insights.
• Experience in creating or supporting the development of Power BI dashboards, with an understanding of how to translate data into meaningful visual insights.
• Strong skills in Advanced Excel, including formulas, pivot tables, visualisation techniques, and automation to support robust reporting and analysis.
• Knowledge of the Microsoft Power Platform (Power Apps, Power Automate, Power BI) to support workflow creation, data capture, and visualisation.
• Experience working within a Project Controls environment on large or complex construction or infrastructure programmes.
• Understanding of schedule, cost, and risk management principles.
• Previous involvement in a Project Controls team within a major project setting.
• Awareness of the transport, energy, infrastructure, or construction sectors, including familiarity with NEC contract environments.

Rewards & benefits

Explore the rewards and benefits that help you thrive – at every stage of your life and your career. Enjoy competitive salaries, employee rewards and a brilliant range of benefits you can tailor to suit your own health, wellbeing, financial and lifestyle choices. Make the most of a myriad of opportunities for training and professional development to grow your skills and expertise. And combine our hybrid working culture and flexible holiday allowances to balance a great job and fulfilling personal life.

About AtkinsRéalis

We're AtkinsRéalis, a world‑class engineering services and nuclear organization. We connect people, data and technology to transform the world's'infrastructure and energy systems. Together, with our industry partners and clients, and our global team of consultants, designers, engineers and project managers, we can change the world. We're committed to leading our clients across our various end markets to engineer a better future for our planet and its people.

Additional information

Security clearance

This role may require security clearance and offers of employment will be dependent on obtaining the relevant level of clearance. If this is necessary, it will be discussed with you at interview. The vetting process is delivered by United Kingdom Security Vetting (UKSV) and may require candidates to provide proof of residency in the UK of 5 years or longer. If applying to this role please do not make reference to (in conversation) or include in your application or CV, details of any current or previously held security clearance.

We are committed to creating a culture where everyone feels that they belong - a place where we can all be ourselves, thrive and develop to be the best we can be. So, we offer a range of family friendly, inclusive employment policies, flexible working arrangements and employee resource groups to support all employees. As an Equal Opportunities Employer, we value applications from all backgrounds, cultures and ability.