Data Analyst - Water Infrastructure Analytics & Dashboards

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 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