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. This 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. The successful candidate will work primarily on Water Infrastructure projects and be based in London. We are only considering candidates with the right to work in the UK.

Our values include Safety first - Going home safe and well: championing a safe, diverse, and inclusive working environment with a focus on wellbeing; Client focus - Deliver on our promise: owning the quality of deliverables and building long-term client relationships; Integrity - Always do the right thing: influencing positive industry outcomes while aligning with compliance obligations; and Create opportunity - For our people to excel: fostering a continuous improvement culture and inspiring development. Mace is an inclusive employer welcoming applications from a diverse range of candidates. We encourage applications even if you do not meet all criteria, as you may be suitable for this or other roles. We are open to discussing part-time, flexible, and hybrid working options where suitable within the role.

Experience
Proven experience within Water Infrastructure projects. 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 integrating Excel-based data flows into Power BI, including use of Power Query and shared data models. Desirable skills in building Power BI dashboards and visualisations, presenting complex data clearly for stakeholders and decision-making. Right to work in the UK is essential.

Qualifications
No specific qualifications are stated; however, advanced Excel and data analysis skills are required. A positive attitude and willingness to learn are valued.