At a Glance
- Tasks: Develop and enhance Power BI dashboards while managing data for impactful reporting.
- Company: Join a forward-thinking organisation focused on capital delivery and regulatory excellence.
- Benefits: Competitive salary, flexible working options, and opportunities for professional growth.
- Other info: Collaborative environment with a focus on continuous improvement and innovation.
- Why this job: Make a difference by transforming data into actionable insights that drive strategic decisions.
- Qualifications: 3-5 years of Power BI experience and strong analytical skills required.
The predicted salary is between 36000 - 60000 £ per year.
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.
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).
Data Analyst and Power Bi employer: Long O Donnell Associates Limited
Contact Detail:
Long O Donnell Associates Limited Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Analyst and Power Bi
✨Tip Number 1
Network like a pro! Reach out to your connections in the industry, attend meetups, and engage on platforms like LinkedIn. We can’t stress enough how personal connections can lead to job opportunities that aren’t even advertised.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your Power BI dashboards and data analysis projects. This gives potential employers a taste of what you can do and sets you apart from the crowd.
✨Tip Number 3
Prepare for interviews by practising common questions related to data analysis and Power BI. We recommend using the STAR method (Situation, Task, Action, Result) to structure your answers and highlight your achievements effectively.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, we love seeing candidates who are proactive about their job search!
We think you need these skills to ace Data Analyst and Power Bi
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the Data Analyst and Power BI role. Highlight your experience with Power BI development, data management, and performance reporting. We want to see how your skills align with what we’re looking for!
Showcase Your Projects: Include specific examples of projects where you've developed dashboards or improved reporting processes. This helps us understand your hands-on experience and how you can contribute to our team.
Be Clear and Concise: When writing your application, keep it clear and to the point. Use bullet points for key achievements and avoid jargon unless it's relevant. We appreciate straightforward communication!
Apply Through Our Website: Don’t forget to apply through our website! It’s the best way for us to receive your application and ensures you’re considered for the role. We can’t wait to hear from you!
How to prepare for a job interview at Long O Donnell Associates Limited
✨Know Your Power BI Inside Out
Make sure you’re well-versed in Power BI development, including DAX and Power Query. Prepare to discuss specific dashboards you've created and how they’ve improved reporting processes. Being able to showcase your technical skills with real examples will impress the interviewers.
✨Showcase Your Analytical Skills
Be ready to talk about your experience with data transformation and analysis. Think of a few instances where you identified trends or anomalies that led to actionable insights. This will demonstrate your ability to turn complex data into clear, evidence-based recommendations.
✨Communicate Clearly and Effectively
Since this role involves collaboration with cross-functional teams, practice explaining technical concepts in simple terms. Highlight your communication skills by discussing how you’ve worked with others to enhance data quality and streamline reporting processes.
✨Prepare for Scenario-Based Questions
Expect questions that assess your problem-solving abilities in real-world scenarios. Think about challenges you’ve faced in previous roles, especially in performance reporting or data management, and how you overcame them. This will show your capability to handle the fast-paced environment mentioned in the job description.