Business Intelligence Analyst

NHS; Nottingham; On-site; GBP 35,000 - 37,000; Full time

Job summary

A leading organization in the healthcare sector is seeking a Business Intelligence (BI) Analyst to transform data into actionable insights. The role involves developing data processes, designing dashboards with Power BI, and ensuring compliance with performance metrics to enhance patient care and organizational performance.

Qualifications

• Educated to degree level in a relevant subject.
• Experience in data analysis and visualization.
• Proficient in SQL and Power BI.

Responsibilities

• Develop and implement data collection processes.
• Produce routine and ad-hoc performance reports.
• Design and develop dashboards using Power BI.

Skills

Analytical skills

Data analysis

Data visualization

SQL querying

Trend analysis

Education

Degree in relevant subject

Tools

Power BI

SQL Database

Microsoft Office

Excel

Job description

Job summary

The NEMS Business Intelligence (BI) Analyst will play a key role in transforming data into actionable insights. Supporting our strategic direction to be a data rich organisation, allowing data and information to drive our business decisions.

This position involves developing and maintaining structured data processes to monitor and evaluate performance against service agreements and contractual obligations, ensuring the accurate measurement, monitoring and submission of key performance indicators (KPIs).

The post holder will be responsible for developing and managing data collection, analysis, and reporting processes. Designing and delivering dashboards using Power BI while providing vital business intelligence that supports decision-making processes aimed at improving organisational performance and patient care.

The Analyst will work closely with internal teams and stakeholders to identify reporting gaps, identify areas of improvement, and help drive corrective actions to meet target

Main duties of the job

Data Collection, Analysis and Reporting: Develop and implement structured data collection processes to support business intelligence and reporting needs.

Provide timely and accurate reports on key performance indicator (KPIs) metrics.

Produce routine and ad-hoc performance reports for internal and external stakeholders to support contract and KPI compliance.

Design and develop dashboards using Power BI SQL Database

Management & Querying:

Write, optimize, and execute complex SQL queries to extract, transform, and load (ETL) data from relational databases.

Design and implement improvement measures and reporting mechanisms to capture and analyse data and support organisational decision-making.

Support colleagues and project teams in the provision of collecting, reporting, and analysing data.

Trend Analysis & Forecasting:

Analyse historical data to identify trends, patterns, and anomalies, and assist in developing forecasts and predictive models where appropriate.

Documentation:

Create and maintain comprehensive documentation for data sources, metrics, reports, and dashboards.

About us

About NEMS

NEMS CBS is a high quality, high performing, not-for-profit organisation which delivers integrated Urgent Care and Urgent Primary Care services to over 1 million patients. Responsive, adaptable, and continually evolving, we have a reputation for delivering locally tailored, safe, effective, and cost-efficient services with high levels of patient satisfaction. We are committed to investing in our people and have an established programme of learning and development, successfully developing our own Urgent Care Practitioners and Advanced Clinical Practitioners.

NEMS currently operates 3 main services: (1) Integrated Urgent Care across Nottingham & Nottinghamshire, including home visiting, remote consultation, and clinical assessment services; (2) Urgent Treatment Centre provision located beside the ED Department at QMC, (3) A 24-hour walk-in Urgent Primary Care service at Kings Mill Hospital ED, Mansfield.

NEMS is committed to the NHS Values (as set out in the NHS Constitution March 2015). NEMS CBS is a registered society under the Co-operative and Community Benefit Societies Act 2014.

Details Date posted

22 May 2025

Pay scheme

Other

Salary

£35,000 to £37,000 a year

Contract

Permanent

Working pattern

Full-time, Flexible working

Reference number

U9183-25-0038

Job locations

Forward House

Station Street

Nottingham

NG2 3AJ

Kings Mill Hospital

Mansfield Road

Sutton-in-ashfield

Nottinghamshire

NG17 4JL

Nottingham University Hospital

Derby Road

Nottingham

NG7 2UH

Job description Job responsibilities

Main Duties of The Role

Data Collection, Analysis and Reporting:

Develop and implement structured data collection processes to support business intelligence and reporting needs.

Provide timely and accurate reports on key performance indicator (KPIs) metrics.

Produce routine and ad-hoc performance reports for internal and external stakeholders to support contract and KPI compliance.

Design and develop dashboards using Power BI

SQL Database Management & Querying: Write, optimize, and execute complex SQL queries to extract, transform, and load (ETL) data from relational databases.

Design and implement improvement measures and reporting mechanisms to capture and analyse data and support organisational decision-making.

Support colleagues and project teams in the provision of collecting, reporting, and analysing data.

Trend Analysis & Forecasting:

Analyse historical data to identify trends, patterns, and anomalies, and assist in developing forecasts and predictive models where appropriate.

Documentation: Create and maintain comprehensive documentation for data sources, metrics, reports, and dashboards.

Data Integrity and Quality:

Oversee data quality checks on source data on a routine basis and ensure data quality issues are resolved, and process/reporting improvements are made.

Ensure the accuracy, consistency, and integrity of all data used in reporting and analysis.

Implement quality control measures to prevent errors and discrepancies in the data collection process.

Support the Governance team in achieving compliance with Quality Audit reports

Job description Job responsibilities

Main Duties of The Role

Data Collection, Analysis and Reporting:

Develop and implement structured data collection processes to support business intelligence and reporting needs.

Provide timely and accurate reports on key performance indicator (KPIs) metrics.

Produce routine and ad-hoc performance reports for internal and external stakeholders to support contract and KPI compliance.

Design and develop dashboards using Power BI

SQL Database Management & Querying: Write, optimize, and execute complex SQL queries to extract, transform, and load (ETL) data from relational databases.

Design and implement improvement measures and reporting mechanisms to capture and analyse data and support organisational decision-making.

Support colleagues and project teams in the provision of collecting, reporting, and analysing data.

Trend Analysis & Forecasting:

Analyse historical data to identify trends, patterns, and anomalies, and assist in developing forecasts and predictive models where appropriate.

Documentation: Create and maintain comprehensive documentation for data sources, metrics, reports, and dashboards.

Data Integrity and Quality:

Oversee data quality checks on source data on a routine basis and ensure data quality issues are resolved, and process/reporting improvements are made.

Ensure the accuracy, consistency, and integrity of all data used in reporting and analysis.

Implement quality control measures to prevent errors and discrepancies in the data collection process.

Support the Governance team in achieving compliance with Quality Audit reports

Person Specification Qualifications Essential

• Educated to degree level in relevant subject or equivalent
• experience of working at a similar level in specialist area
• Additional specialist knowledge relevant to post
• Evidence of on-going personal development

Experience Essential

• Excellent analytical and numeric skills with an ability to
• understand and question detail
• Experienced and proficient in data analysis tools and
• techniques
• Expert knowledge in data visualization tools including Power BI
• to create clear and impactful reports and dashboards
• Expert SQL Database Management & Querying skills
• An advanced knowledge of Microsoft Office applications
• Advanced Excel skills
• Advanced IT Skills including database systems (e.g. Oracle, MS
• Access) and data warehousing concepts, including cloud-based
• data warehouse & analytics platforms such as Snowflake
• Previous experience in a role of a similar level

Desirable

• Previous experience in a role of a similar level.
• Experience of summarising and presenting
• complex analyses to varied audiences.
• Understanding of data governance principles,
• including data quality, security, and compliance
• in line with NHS guidelines
• Knowledge and experience of working within
• provider services
• An understanding of data and reporting from
• healthcare information systems e.g. SystmOne,
• Adastra
• Knowledge of statistical analysis software (e.g.,
• R, Python)

Person Specification Qualifications Essential

• Educated to degree level in relevant subject or equivalent
• experience of working at a similar level in specialist area
• Additional specialist knowledge relevant to post
• Evidence of on-going personal development

Experience Essential

• Excellent analytical and numeric skills with an ability to
• understand and question detail
• Experienced and proficient in data analysis tools and
• techniques
• Expert knowledge in data visualization tools including Power BI
• to create clear and impactful reports and dashboards
• Expert SQL Database Management & Querying skills
• An advanced knowledge of Microsoft Office applications
• Advanced Excel skills
• Advanced IT Skills including database systems (e.g. Oracle, MS
• Access) and data warehousing concepts, including cloud-based
• data warehouse & analytics platforms such as Snowflake
• Previous experience in a role of a similar level

Desirable

• Previous experience in a role of a similar level.
• Experience of summarising and presenting
• complex analyses to varied audiences.
• Understanding of data governance principles,
• including data quality, security, and compliance
• in line with NHS guidelines
• Knowledge and experience of working within
• provider services
• An understanding of data and reporting from
• healthcare information systems e.g. SystmOne,
• Adastra
• Knowledge of statistical analysis software (e.g.,
• R, Python)

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

NEMS Community Benefit Services Ltd

Address

Forward House

Station Street

Nottingham

NG2 3AJ

Employer's website

https://nemscbs.net/ (Opens in a new tab)

Employer details Employer name

NEMS Community Benefit Services Ltd

Address

Forward House

Station Street

Nottingham

NG2 3AJ

Employer's website

https://nemscbs.net/ (Opens in a new tab)