• Job Description

  Req#: U9183-25-0038?language=en&page=293&sort=publicationDateDesc

  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)

• About the company

  National Health Service (NHS) is the umbrella term for the publicly-funded healthcare systems of the United Kingdom (UK). The founding principles were that services should be comprehensive, universal and free at the point of delivery—a health service based on clinical need, not ability to pay. Each service provides a comprehensive range of health services, free at the point of use for people ordinarily resident in the United Kingdom apart from dental treatment and optical care.

Notice