Advanced Business Intelligence Analyst

Go back Chesterfield Royal Hospital NHS Foundation Trust

The closing date is 10 March 2026

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.

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.

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.

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.

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

• 
  
• 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)
  

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

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

• 
  
• Compassion, Ambition, Respect and Encouragement
  

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.

Chesterfield Royal Hospital NHS Foundation Trust