Employer Chesterfield Royal Hospital NHS Foundation Trust Employer type NHS Site Chesterfield Royal Hospital Town Chesterfield Salary £47,810 - £54,710 pro rata Salary period Yearly Closing 10/03/2026 23:59 Interview date 26/03/2026
Advanced Business Intelligence Analyst
NHS AfC: Band 7
Job overview
Chesterfield Royal Hospital is looking to appoint a new Advanced Business Intelligence Analyst to join the Informatics Team to support business intelligence and information requirements within the CAMHS and Child Health Care Units.
This is a new role in the team and an exciting opportunity for an enthusiastic individual interested in advancing their career within Information and Business Intelligence in the NHS.
As an experienced analyst you will become part of a dynamic well established Information Team. You will be driven and passionate about using latest innovations and new business technology to meet the needs of the Trust's key internal and external objectives.
Main duties of the job
The post-holder will have excellent communication and negotiation skills, able to build relationships with a range of stakeholders such as clinical leaders, business managers and IT professionals.
The post-holder will need strong technical skills - you will be required to extract and manipulate data directly from systems using Crystal Reporting, as well as sourcing information via the data warehouse using SQL. You will need to use a range of reporting, analytical and visualisation tools - ranging from MS Excel to Tableau and SSRS. The post-holder will be a self-motivated individual who has an organised and logical approach to work. You will have the ability to work under pressure using your own initiative as well as being an integral part of a busy, established team.
Working for our organisation
Chesterfield Royal Hospital's vision is to be a first-class provider of sustainable healthcare services, delivering the best possible care for our patients; and being a great place to work for our people. Our Proud to CARE philosophy supports this vision - and we all play a part in achieving it, by living up to the values we promise to our patients and each other.
Our main hospital is on a greenfield site with abundant countryside, lovely views, beautiful landscaping and an outdoor gym - it's easy to access green space at break times which offers an opportunity to de-stress. The hospital is easily accessible from the M1 and the A61 and the local train station is nearby.
We are passionate about sustainable transport and offer a cycle to work scheme, as well as an electric lease car scheme open to all employees. Our staff wellbeing service provides a huge range of benefits including staff counselling, access to free financial and legal advice and various support groups, fitness classes and even a staff choir! A staff wellbeing hub including a free gym for staff to use has also now opened.
Detailed job description and main responsibilities
Please see the Job description and Person Specification in the attachments. This document contains a full detailed description of the role and what the main responsibilities and duties are along with the criteria that are required.
Additional Requirements: As part of your supporting information please include a 150 word (minimum) write-up on a recent analytical visual report you created and presented and what impact it had on decision making.
Person specification
Qualifications and Training
* Professional Qualification in a BI or Information or equivalent experience (minimum 3 years).
* A certificate in using Microsoft Office applications or equivalent knowledge and experience gained through any combination of alternative study, employment, or voluntary work.
* Microsoft Certified in the use of SQL Management Studio or equivalent knowledge and experience gained through any combination of alternative study, employment, or voluntary work.
* Educated to Master’s degree level or ability to demonstrate equivalent level of experience
* Evidence of continual professional development
* Project management methods (Agile, Prince2)
* Membership of Association of professional healthcare analysts
Experience
* Demonstrable experience of developing data visualisations using analytics tools such as Tableau, Power BI and SSRS
* Working in an NHS Informatics Team (minimum 3 years).
* Extensive experience of working in an analytical reporting environment
* Expert user of Microsoft Office applications and skilled in use of SQL
* Experience of developing complex statistical methods and applying them to large datasets
* Demonstrate an ability to explain technical concepts to others.
* Experience in modelling and forecasting software (R, PYTHON)
Skills and Knowledge
* Highly skilled in interpreting and analysing complex information and presenting it in a simplified manner
* Ability to work with a broad spectrum of information from a wide range of sources presenting complex and sophisticated information in a meaningful way to increase organisational knowledge and enable evidence-based decisions.
* Expert knowledge of and a strong interest in Healthcare Analytics
* Excellent understanding of business requirements for information, including performance management requirements
* Highly developed skills in analysing and investigating key performance information.
* Highly skilled in communicating a range of complex informatics and statistical issues to a varied audience
* Able to act as an expert in field of data capture, manipulation and dissemination.
* Ability to manipulate data from a variety of sources and present in the most appropriate format
* Capacity to quickly develop good working knowledge of unfamiliar or new information systems.
* Excellent understanding of national data quality issues and approaches taken to improve quality
* Expert understanding of a range of data collection methods and analytical tools and techniques (such as R, Python etc), and their application in the NHS.
Personal Attributes
* Passionate about the use of business intelligence in the NHS
* Hypothesis-driven thinking to form and shape solutions to problems
* The motivation and ability to solve complex problems.
* Logical approach to tasks.
* Energetic and confident communicator able to build relationships with colleagues at all levels
* Able to successfully work under tight project deadlines.
* Measures own success on stakeholder feedback
Demonstrates our Proud to CARE Values
* Compassion, Ambition, Respect and Encouragement
Flexible Working
If you're looking for flexible or predictable working arrangements, please speak to us about how we might be able to accommodate this. If it works for our service and patients, we will do our best to make it work for you.
Chesterfield Royal Hospital NHS Foundation Trust is committed to ensuring the safety of all our staff and patients therefore encourages and supports staff to be vaccinated against COVID19 as this remains the best line of defence against the virus.
UK Points-based immigration system
Applications from job seekers who require sponsorship to work in the United Kingdom (UK) are welcome and will be considered alongside all other applications. Please note that from 1 January 2021, to work in the UK all candidates who are not UK or Republic of Ireland (RoI) nationals require sponsorship unless you have permission to work via another route. Non UK / RoI candidates wishing to apply can self-assess the likelihood of obtaining a Certificate of Sponsorship here Work in the UK - GOV.UK (www.gov.uk) .
It is vital that you provide full and accurate details of your current immigration status on the application form. Overseas applicants applying for entry clearance into the UK must present a criminal record certificate from each country they have resided in continuously or cumulatively for 12 months or more in the past 10 years. Guidance can be found here Criminal records checks for overseas applicants - GOV.UK (www.gov.uk)
If you are applying for a vacancy in health or adult social care, you may be eligible to apply for the Health and Care Worker visa instead, which is cheaper to apply for and you do not need to pay the annual immigration health surcharge.
Communications
Communications throughout the application process will be via e-mail therefore please check your e-mail account and Trac account regularly. References are also requested by email (where possible). Therefore to speed up the recruitment process please provide an email address for all referees when completing your application form.
If you require any support in completing the application form, please do not hesitate to contact the HR Support Services team on 01246 513177 and we will be happy to provide assistance.
Please see the attached documents and links in relation to working for Chesterfield Royal Hospital NHS Foundation Trust. In particular, the general conditions of employment and benefits of working for the trust.
This role is part of the integrated health and social care community across Derbyshire, where there are many opportunities to work across different locations and providers developing new and different skills. Whilst this role is initially based in Chesterfield there may be future opportunities to be based at different locations within the health and social care community which we may talk to you about in the future.
Follow us on Facebook and on Twitter: @CRHCareers @WellbeingCRH @royalhospital
Employer certification / accreditation badges
Name Rob Fraser Job title Performance and Information Operations Manager Email address c.emblen@nhs.net Telephone number 01246 514412
#J-18808-Ljbffr