Location
London

Hours
Full Time

Salary
Negotiable

About the Role
Mace combines construction expertise with consultancy to unlock potential in every person or project and redefine the boundaries of ambition. We are seeking a Data Analyst to support the compilation, assurance, analysis, and reporting of PDP Applications for Payment including time booking and charges, expenses, and subcontractors. The role involves reviewing existing data flows to improve consistency, identifying and developing solutions to enhance the efficiency of current processes and tools, and developing advanced analysis through dashboards. This position is London based and requires candidates to have the right to work in the UK. You will work closely with Water Infrastructure projects, applying your expertise to ensure data accuracy and insightful reporting.

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 within the role.

Experience
Proven experience within Water Infrastructure projects is essential. 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.

About you
Analytical mindset with attention to detail, ensuring data accuracy, consistency, and integrity throughout the reporting lifecycle. Ability to design robust, maintainable data models within Excel, with clear logic and documentation to support reuse and auditability. 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.

Qualifications
Right to work in the UK is mandatory. Relevant qualifications or certifications in data analysis, Excel, or related fields are advantageous but not explicitly required.