Power BI Project Officer

Job summary

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'lltake 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.

Benefits

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
  • Enhanced sick pay
  • 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!

Closing date: 21/09/2025

Job description

Job responsibilities

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. Youll 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, youll 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.

Person Specification

Qualifications

Essential
  • 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
Desirable
  • Membership of a relevant organisation
  • Microsoft PL300 Certified
  • Postgraduate training in business intelligence/ data analysis/ business reporting/ statistical analysis
  • Recognized project management qualification

Experience

Essential
  • 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
Desirable
  • 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

Essential
  • 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
  • Problem solving 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
  • Manages difficult situations sensitively
  • Creative
  • Consistent
  • Curious
  • Self-motivated, energetic, not easily discouraged
Desirable
  • Able to motivate people and promote positive team dynamics
  • Presentation skills
  • 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.

Employer details

Employer name

Compass

Address

2nd Floor

Marlborough House

York Business Park

North Yorkshire

YO26 6RW


Employer's website

https://www.compass-uk.org/

Company
Compass
Location
York Business Park, United Kingdom YO26 6RW
Employment Type
Fixed-Term
Salary
£31962.00 - £39172.00 a year
Posted
Company
Compass
Location
York Business Park, United Kingdom YO26 6RW
Employment Type
Fixed-Term
Salary
£31962.00 - £39172.00 a year
Posted