Data Analyst and Power Bi
Posted 1 day ago by Long O Donnell Associates Limited
Negotiable
Undetermined
Undetermined
DH1, Old Durham, County Durham
Summary: The Power BI & Data Analyst is responsible for advanced Power BI development, data management, and performance reporting to support the organisation's Capital Programme and regulatory reporting cycles. This role involves developing and maintaining reporting solutions while ensuring data accuracy and insight across various levels. Collaboration with PMO colleagues and cross-functional teams is essential to enhance data quality and streamline reporting processes. The ideal candidate will possess strong analytical skills and experience in capital delivery.
Key Responsibilities:
- Develop, enhance, and futureproof Power BI dashboards and reporting architecture.
- Translate user needs into effective dashboards and refine existing visuals.
- Collect, clean, transform, and model data from multiple sources.
- Conduct exploratory data analysis to identify trends and opportunities.
- Produce accurate monthly reporting packs, dashboards, and presentations.
- Ensure quality assurance of all reporting outputs across PMO frameworks.
- Identify opportunities for improving data quality and reporting processes.
- Share knowledge and mentor colleagues in BI development and data analysis.
- Contribute to the development of integrated project controls tools.
Key Skills:
- 3–5+ years’ experience in Power BI development and performance reporting.
- Data transformation, manipulation, and visualisation skills.
- Proficiency in BI and Microsoft tools (Power BI, Excel, SharePoint, PowerPoint).
- Ability to work with large datasets and deliver actionable insights.
- Experience in fast-paced environments managing competing priorities.
- AI, Machine Learning, RPA experience (desirable).
- PowerApp and SharePoint development experience (desirable).
- Degree in business management, data/analytics, or related fields (desirable).
- Familiarity with SQL or Python for data analysis (desirable).
Salary (Rate): undetermined
City: Old Durham
Country: United Kingdom
Working Arrangements: undetermined
IR35 Status: undetermined
Seniority Level: undetermined
Industry: IT
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).