The Power BI & Data Analyst plays a key role. The role combines advanced Power BI development, data management, and performance reporting to support the organisation’s Capital Programme and regulatory reporting cycles.
The post holder will develop, maintain, and futureproof reporting solutions, ensuring accuracy, consistency, and insight across project, programme, and portfolio levels. They will work collaboratively with PMO colleagues and cross functional teams to enhance data quality, streamline reporting processes, and deliver clear, actionable insights.
We are seeking an experienced professional with strong analytical capability, excellent communication skills, and domain experience in capital delivery.
Key Accountabilities
Power BI Development & Reporting Architecture
* Develop, enhance, and futureproof Power BI dashboards and reporting architecture, ensuring alignment with regulatory cycles (e.g., AMP8).
* Ability to translate users needs (including gathering them) and converting into resilient, effective dashboards
* Design within common standards, workspaces, ensuring look/feel, UX is consistent
* Refine existing visuals, optimise data models, and improve resilience, performance, and usability of reporting solutions.
Data Management & Analysis
* Collect, clean, transform, and model data from multiple sources (e.g., OUA, APEX, other Databases/Data Warehouses, SharePoint, Excel, enterprise systems).
* Conduct exploratory data analysis to identify trends, anomalies, risks, and opportunities.
* Provide clear, evidence based insights to support strategic and operational decision making.
Performance Reporting & Assurance
* Produce accurate, timely monthly reporting packs, dashboards, and presentations.
* Ensure quality assurance of all reporting outputs, maintaining consistency across PMO reporting frameworks.
* Support compliance with management reporting frameworks across project, programme, and portfolio levels.
Continuous Improvement & Capability Building
* Identify opportunities to improve data quality, reporting processes, and analytical methods.
* Share knowledge, mentor colleagues, and promote best practice in BI development and data analysis.
* Contribute to the development of integrated project controls tools and future reporting roadmaps.
Experience Required:
Essential
3–5+ years’ experience in:
* Power BI development (data modelling, DAX, Power Query, report design).
* Performance reporting within a PMO, project, programme, or portfolio environment.
* Data transformation, manipulation, and visualisation for varied audiences.
* Using BI and Microsoft tools (Power BI, Excel, SharePoint, PowerPoint).
* Proven ability to work with large, complex datasets and deliver actionable insights.
* Experience producing management information to support decision making.
* Demonstrated ability to work in fast paced environments, managing competing priorities.
Useful / Desirable
* AI, Machine Learning, RPA experience
* PowerApp development / Sharepoint development.
* Experience in the UK water industry or regulated utilities.
* Experience with Oracle databases / data warehouses.
* Degree in business management, data/analytics, computer science, statistics, or project/programme disciplines.
* Experience across full project/programme delivery cycles.
* Experience developing new BI dashboards from scratch.
* Understanding of project controls concepts (cost, schedule, risk, benefits) – desirable.
* Familiarity with SQL or Python for data analysis – desirable (open source best practice addition)