Go back
Medway Community Healthcare

Senior business intelligence analyst

The closing date is 16 July 2025

Apply for this job

Job summary

Job overview

  • Are you a highly motivated and efficient team player, who can also work on your own initiative?

If you answered yes, we've got the perfect role for you!

An exciting opportunity has arisen for a self-starting and enthusiastic individual to join our innovative and fast paced business intelligence team.

We are looking to appoint a pro-active and dynamic individual with the confidence to engage with others across all levels of the organisation and wider health economy.

Main duties of the job

To support the organisation with analysis and reporting on a wide range of topics and service areas, and to contribute to improving quality in respect of patient activity data that is captured by community services.

To use SQL and other Microsoft tools, to extract data from source systems to produce analytic reports, visualisations and outline findings on a range of topics.

The post-holder will provide high quality, timely and accurate information to enable Medway Community Healthcare to provide effective patient services.

About us

So what else?

  • This is your chance to join a progressive and innovative service in a social enterprise that is patient and staff focused - you'll even have the opportunity to become an MCH shareholder.
  • We encourage staff to get involved in exploring new ways of working and service development.
  • We'll provide well established, in-service training, one to one supervision, and appraisals with regular support.
  • You'll be able to develop your skills in a friendly and supportive team.

Would you like to work flexibly?In the NHS, we are reminded every day of how important work life balance is. As a flexible working friendly organisation, we want to be sure that you can work in a way that is best for us, for our patients and for you. Speak to us about how we might be able to accommodate a flexible working arrangement.

The small print

  • We will offer you the choice of two pension schemes; the NHS Pension scheme and the scottish widows group pension scheme.
  • MCH encourages all staff to be double COVID vaccinated to protect themselves, their colleagues, their family and their patients.

Details

Date posted

02 July 2025

Pay scheme

Agenda for change

Band

Band 6

Salary

£37,338 to £44,962 a year per annum

Contract

Permanent

Working pattern

Full-time, Flexible working, Home or remote working

Reference number

813-176-0725-LB

Job locations

MCH House

Gillingham

ME8 0PZ


Job description

Job responsibilities

The Senior Business Intelligence Analyst is responsible for:

Co-ordinating the day-to-day work of the business intelligence team to ensure it meets its deadlines and delivers high quality business support to its customers.

Providing the Business Intelligence Analyst with support and guidance to develop their technical SQL skills.

Provide advice on data reporting for mobilisation of new services and support the development of current and future reporting requirements.

Developing a culture that improves quality in respect of patient activity data.

Support and assist in yearly contract refresh for activity and capacity planning.

To develop national minimum data set reporting and provide assurance against timescales for delivery and reporting requirements.

To produce accurate and timely performance data by:

o Ensuring collation of patient activity data from a variety of systems for internal management and for contract performance meetings

o Monitoring the processing of data and information

o Assurance on data quality addressing issues with services where required

Advise and support service leads to help improve the accuracy and consistency of their activity recording and reporting to minimise data and information gaps.

Develop and implement effective models of interrogating and presenting monthly and quarterly performance data across multiple services, highlighting areas for change /investigation.

Build good working relationships with various stakeholders (internal and external).

Ensure the Business Intelligence team can produce, interrogate and report on the portfolio of performance data via Power BI.

Full JD can be found in the attachments

Job description

Job responsibilities

The Senior Business Intelligence Analyst is responsible for:

Co-ordinating the day-to-day work of the business intelligence team to ensure it meets its deadlines and delivers high quality business support to its customers.

Providing the Business Intelligence Analyst with support and guidance to develop their technical SQL skills.

Provide advice on data reporting for mobilisation of new services and support the development of current and future reporting requirements.

Developing a culture that improves quality in respect of patient activity data.

Support and assist in yearly contract refresh for activity and capacity planning.

To develop national minimum data set reporting and provide assurance against timescales for delivery and reporting requirements.

To produce accurate and timely performance data by:

o Ensuring collation of patient activity data from a variety of systems for internal management and for contract performance meetings

o Monitoring the processing of data and information

o Assurance on data quality addressing issues with services where required

Advise and support service leads to help improve the accuracy and consistency of their activity recording and reporting to minimise data and information gaps.

Develop and implement effective models of interrogating and presenting monthly and quarterly performance data across multiple services, highlighting areas for change /investigation.

Build good working relationships with various stakeholders (internal and external).

Ensure the Business Intelligence team can produce, interrogate and report on the portfolio of performance data via Power BI.

Full JD can be found in the attachments

Person Specification

Qualifications & Experience

Essential

  • Educated to degree level or relevant experience
  • Excellent IT skills with intermediate level knowledge of excel and Power BI
  • Knowledge of SQL and coding

Desirable

  • Previous role as an analyst
  • Experience of SQL coding at intermediate level
  • Experience using SSRS/SSMS/SSAS

Knowledge

Essential

  • Knowledge of NHS data sources and information
  • Knowledge of NHS data protection and information governance

Desirable

  • Experience working in the public sector, particularly healthcare
  • Clear understanding of NHS data sources and information flows

Experience

Essential

  • Experience of data analysis and manipulation
  • Experience of use of various IT systems
  • Experience of improving processed and/or reporting solutions

Desirable

  • Experience using EPR systems
  • Experience using Power BI

Practical and Intellectual skills

Essential

  • Excellent communication and skills and a strong communicator
  • Ability to manage and prioritise conflicting and demanding workloads and deadlines
  • Excellent attention to details

Desirable

  • Proactive and solution focused
  • Flexibility and willingness to perform adhoc duties as and when required to support the wider team
  • Understand expectations of stakeholders and recognise when issues/events may effect delivery

MCH values

Essential

  • Good understanding of MCH values
Person Specification

Qualifications & Experience

Essential

  • Educated to degree level or relevant experience
  • Excellent IT skills with intermediate level knowledge of excel and Power BI
  • Knowledge of SQL and coding

Desirable

  • Previous role as an analyst
  • Experience of SQL coding at intermediate level
  • Experience using SSRS/SSMS/SSAS

Knowledge

Essential

  • Knowledge of NHS data sources and information
  • Knowledge of NHS data protection and information governance

Desirable

  • Experience working in the public sector, particularly healthcare
  • Clear understanding of NHS data sources and information flows

Experience

Essential

  • Experience of data analysis and manipulation
  • Experience of use of various IT systems
  • Experience of improving processed and/or reporting solutions

Desirable

  • Experience using EPR systems
  • Experience using Power BI

Practical and Intellectual skills

Essential

  • Excellent communication and skills and a strong communicator
  • Ability to manage and prioritise conflicting and demanding workloads and deadlines
  • Excellent attention to details

Desirable

  • Proactive and solution focused
  • Flexibility and willingness to perform adhoc duties as and when required to support the wider team
  • Understand expectations of stakeholders and recognise when issues/events may effect delivery

MCH values

Essential

  • Good understanding of MCH values

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

Medway Community Healthcare

Address

MCH House

Gillingham

ME8 0PZ


Employer's website

https://www.medwaycommunityhealthcare.nhs.uk/ (Opens in a new tab)

Employer details

Employer name

Medway Community Healthcare

Address

MCH House

Gillingham

ME8 0PZ


Employer's website

https://www.medwaycommunityhealthcare.nhs.uk/ (Opens in a new tab)

Employer contact details

For questions about the job, contact:

Business Intelligent Lead

Sasha New

Sasha.New@nhs.net

Details

Date posted

02 July 2025

Pay scheme

Agenda for change

Band

Band 6

Salary

£37,338 to £44,962 a year per annum

Contract

Permanent

Working pattern

Full-time, Flexible working, Home or remote working

Reference number

813-176-0725-LB

Job locations

MCH House

Gillingham

ME8 0PZ


Supporting documents

Privacy notice

Medway Community Healthcare's privacy notice (opens in a new tab)