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