Data Analyst - Water Infrastructure

Mace; Greater London; Hybrid; GBP 45,000 - 65,000; Full time

Job summary

Mace is seeking a Data Analyst to support compilation, assurance, analysis and reporting of PDP Applications for Payment, including time booking, expenses and subcontractors. London-based, with flexibility for hybrid working.

You will review existing data flows to improve consistency, identify and develop solutions, and deliver enhanced analysis through dashboards using Excel and Power BI. Strong data modelling and data quality discipline is required, with hands-on experience in Power Query and

Qualifications

• Advanced Excel skills with large datasets across inter-linked spreadsheets.
• Understanding of data structuring and validation to prevent downstream errors.
• Experience using automation and scripting (Excel formulas, Power Query M language, VBA) to manipulate data.

Responsibilities

• Support compilation, assurance, analysis and reporting of PDP Applications for Payment including time booking, expenses and subcontractors.
• Review data flows to improve consistency and develop solutions for efficiency.
• Develop enhanced analysis through dashboards and automated workflows.

Skills

Advanced Excel

Data structuring

Automation scripting

Power Query

Power BI

Data modelling

Data storytelling

Tools

Power Query

M language

VBA

Power BI

Job description

Mace combines construction expertise with consultancy to unlock potential in every person or project and redefine the boundaries of ambition. Our values shape the way we consult and define the people we want to join us on our journey.

Data Analyst to support compilation, assurance, analysis and reporting of PDP Applications for Payment including time booking and charges, expenses, subcontractors. Reviewing existing data flows to improve consistency, identifying and developing solutions for improving efficiency of current processes and tools together with developing enhanced analysis through dashboards.

Successful candidates must have experience within Water Infrastructure projects, London Based, only considering candidates with right to work in the UK.

You’ll Need To Have

• AdvancedMicrosoft Excelskills, including working confidently across multiple inter‑linked spreadsheets and large datasets.
• Strong understanding ofdata structuring and validation in Excel, with the ability to identify and correct inconsistencies in source data to prevent downstream errors.
• Experience usingautomation and scripting(e.g. Excel formulas, Power Query M language, VBA or equivalent) to manipulate, cleanse, reconcile, and compare data from multiple sources.
• Proven capability in buildingautomated data transformation and reporting workflows using Excel Power Query, including refreshable queries and repeatable processes.
• Ability to designrobust, maintainable data modelswithin Excel, with clear logic and documentation to support reuse and auditability.
• Analytical mindset with attention to detail, ensuring data accuracy, consistency, and integrity throughout the reporting lifecycle.
• Desirable experience inintegrating Excel-based data flows into Power BI, including use of Power Query and data models shared between tools.
• Desirable skills inbuilding Power BI dashboards and visualisations, presenting complex data clearly for stakeholders and decision‑making.

Our values

Safety first - Going home safe and well:

We champion a safe, diverse and inclusive working environment, understanding the importance of wellbeing in every team.

Client focus - Deliver on our promise:

We own the quality of deliverables, strategic outcomes and build long term relationships with our clients.

Integrity - Always do the right thing:

We influence positive outcomes within our industry, while always aligning with our compliance obligations.

Create opportunity - For our people to excel:

We champion a continuous improvement culture throughout all activities, inspiring our people and teams to develop.

Mace is an inclusive employer and welcomes interest from a diverse range of candidates.

We are also open to discussing part time, flexible, and hybrid working options if suitable with-in the role.