Data Analyst - Water Infrastructure

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

• Advanced Microsoft Excel skills, including working confidently across multiple inter‑linked spreadsheets and large datasets.

• Strong understanding of data structuring and validation in Excel, with the ability to identify and correct inconsistencies in source data to prevent downstream errors.

• Experience using automation 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 building automated data transformation and reporting workflows using Excel Power Query, including refreshable queries and repeatable processes.

• Ability to design robust, maintainable data models within 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 in integrating Excel-based data flows into Power BI, including use of Power Query and data models shared between tools.

• Desirable skills in building 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. Even if you feel you do not fulfil all the criteria, please apply as you may still be the best candidate for this role or another role within our organisation.

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