Power BI Project Officer

NHS; York; On-site; GBP 30,000 - 40,000; Full time

Job summary

A leading health organization in York is seeking a Power BI Project Officer to drive improvements in data insights and reporting. You will work collaboratively across teams, delivering projects to enhance strategic decision-making through Power BI. The ideal candidate has extensive experience with Power BI, strong communication skills, and the ability to manage complex workloads while ensuring compliance with data governance standards. This role offers meaningful opportunities to impact public health positively.

Benefits

27 days holiday + bank holidays

Life assurance at 2x salary

Competitive pension scheme

Employee Assistance Programme

Learning & development opportunities

Qualifications

• At least 2 years experience using Power BI to design and build reports.
• Experience in the NHS or related sectors.
• Strong technical skills and ability to manage a busy workload.

Responsibilities

• Deliver projects using Power BI from initiation to completion.
• Collaborate across teams to transform data into insights.
• Manage Compass Power BI Service and ensure compliance with governance standards.

Skills

Power BI expertise

Communication skills

Problem solving

Team collaboration

Education

Degree in relevant field

Microsoft PL300 Certification

Tools

Power Query

SQL

DAX

Python

Job description

Overview

Do you want to use data to spark improvement where it matters most and support teams across Compass to make it happen?

We are looking for a Power BI Project Officer to join our Finance and Corporate Services team, within our skilled Data Insights and Intelligence function. This role is central to how Compass makes strategy driven decisions, enabling us to provide timely and meaningful insights from health data.

You'll take the lead on delivering projects using Power BI, from initiation to completion and maintenance. This includes gathering data from a variety of sources, building and managing data models, and creating dashboards and reports that are easy to understand and use. Managing the Compass Power BI Service and Data Warehouse, ensuring accuracy, security and compliance with data governance standards.

Collaboration is at the heart of the role. You'll work with colleagues across Compass to turn data into clear, useful insights that can be shared widely. By making information easy to understand and accessible, you'll help teams use business intelligence data to spot opportunities, learn from successes and keep driving improvements in the way we work and deliver our services. You'll also support mandatory health information returns, helping ensure Compass delivers on national requirements.

This role is varied and rewarding, with your data and reporting skills making a real difference to the services we deliver and the lives we touch.

Main duties of the job

We are looking for someone with strong technical expertise and the ability to work collaboratively across teams. You will need:

• At least 2 years of experience using Power BI to design, build and maintain reports and dashboards
• Work experience in the NHS, local authority or voluntary, community and social enterprise (VCSE) sector
• Experience of managing a busy workload, balancing competing priorities and delivering to deadlines
• Strong technical skills, including experience with Power Query, DAX, SQL or Python, and knowledge of governance standards such as GDPR and Caldicott Guidelines
• Excellent personal skills, including clear communication, problem solving and the ability to explain technical concepts simply to non-technical audiences
• It would be helpful but not essential if you also bring experience of NHS reporting, completion of statutory health returns, or recognised project management or Microsoft certifications.

We are seeking someone who is curious, resilient and a collaborative team player, with both the technical know-how and personal qualities to make a real impact.

If you want to use your Power BI expertise to make a positive difference in health data insights and support meaningful change across Compass, we would love to hear from you.

About us

Compass is committed to safeguarding children, young people and vulnerable adults. Established for over 30 years, Compass is a national charity which works in communities across the UK providing services spanning substance misuse treatment and rehabilitation, early interventions for vulnerable young people, school-aged health programmes and associated prevention as well as treatment and health promotion initiatives.

All Compass posts are subject to appropriate level DBS checks.

We positively encourage applications from all members of the community, regardless of gender, race, faith, disability, age, or sexual orientation, and encourage applications from people who have experiences in life which enrich skills and empathy. This is part of our commitment to equality and developing a truly inclusive and representative workforce.

We are happy to discuss any reasonable adjustments individuals may require in the recruitment process, on commencement, or once in post.

We offer a range of benefits including:

• 27 days holiday + bank holidays, rising to 32 days over time (pro rata)
• Life assurance at 2 x basic salary
• Competitive contributory pension scheme
• 24/7 Employee Assistance Programme and OH service
• Excellent learning & development opportunities and career progression
• Annual performance/salary review

Help us to make a positive change to the lives of children and young people!

Person Specification

Qualifications

• Degree or equivalent relevant professional or management qualification or
• Equivalent level of knowledge gained through relevant work experience in either the NHS or local government or voluntary sector
• Membership of a relevant organisation
• Microsoft PL300 Certified
• Postgraduate training in business intelligence/ data analysis/ business reporting/ statistical analysis

Experience

• Experience of working with data and information either in the NHS or local government or the voluntary sector
• 2-5 years of experience of using Power BI to produce dynamic reports and dashboards that focus on strategic performance insights and understandings
• Excellent track record of delivering to deadlines and balancing competing priorities
• Experience of collaborative and partnership working across organisational hierarchies and boundaries
• Experience of analysing and interpreting complex health and population information and presenting it in an accessible manner
• Experience of using Power Query, Dax, Python and SQL to build data models and to process, transform and analyse data
• Experience of developing, managing and maintaining data warehouses
• Understanding of relational databases
• Knowledge of Caldicott Guidelines, Data Quality Standards and UK GDPR
• Experience of managing people, teams, projects
• Experience of NHS reporting for contract management/ performance management
• Experience of accurate and timely completion of mandatory health information returns
• In depth knowledge and experience of working with health-related datasets
• Knowledge of Public Health priorities
• Experience of generating evidence for the NHS Data Security and Protection Toolkit
• Service and/ or process improvement and transformation
• Working with clinical systems

Additional Criteria

• Able to build and maintain positive working relationships within and outside the organisation
• Able to manage own workload effectively, escalating when necessary
• Able to manage tasks through to successful completion in challenging circumstances
• Excellent verbal and written communication to convey technical concepts to non-technical stakeholders
• Excellent statistical analysis and interpretation skills
• High level interpersonal skills
• Able to work confidently with large, aggregate reports and data sets
• Demonstrates the Compass values
• Leads by example
• Collaborative team player
• Pragmatic, flexible, resilient
• Creative
• Consistent
• Curious
• Self-motivated, energetic, not easily discouraged
• Able to motivate people and promote positive team dynamics
• Strategic thinking

Disclosure and Barring Service Check

This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service (formerly known as CRB) to check for any previous criminal convictions.