Mace
Data Analyst - Water Infrastructure
Get notified of more jobs like this · No spam, ever
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
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.
Job Title: Data Analyst
Role Summary: Support the compilation, assurance, analysis, and reporting of PDP Applications for Payment, including time booking and charges, expenses, and subcontractors. Review existing data flows to improve consistency, identify and develop solutions for improving efficiency of current processes and tools, and develop enhanced analysis through dashboards.
Location: London-Based
Required Criteria:
- Experience within Water Infrastructure projects.
- Right to work in the UK.
Key Requirements:
- Advanced Microsoft Excel Skills:
- Confidently work across multiple inter-linked spreadsheets and large datasets.
- Data Structuring and Validation:
- Strong understanding of data structuring and validation in Excel.
- Ability to identify and correct inconsistencies in source data to prevent downstream errors.
- Automation and Scripting:
- 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.
- Power Query and Reporting Workflows:
- Proven capability in building automated data transformation and reporting workflows using Excel Power Query, including refreshable queries and repeatable processes.
- Data Models in Excel:
- Ability to design robust, maintainable data models within Excel, with clear logic and documentation to support reuse and auditability.
- Analytical Mindset:
- Attention to detail, ensuring data accuracy, consistency, and integrity throughout the reporting lifecycle.
- Power BI Integration:
- Desirable experience in integrating Excel-based data flows into Power BI, including use of Power Query and data models shared between tools.
- Power BI Dashboards and Visualizations:
- Desirable skills in building Power BI dashboards and visualizations, presenting complex data clearly for stakeholders and decision-making.
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
Our Values:
Get help with your application
Your very own career expert that helps elevate your application to the next level.
- 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.
Inclusivity and Flexibility:
- 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 organization.
- We are also open to discussing part-time, flexible, and hybrid working options if suitable within the role.
Job Posting Tags:
- #LI-Onsite
- #LI-HC1
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills
Location