Job summary
Are you a data-driven thinker with a passion for improving healthcare outcomes? This is a rare and exciting opportunity to become a key player in our Pharmacy team as a Data Analyst, embedded within the Pharmacy Medicines Use & Quality division. You'll collaborate across the Trust with Procurement, Finance, and Information teams, and connect with regional and national NHS networks to drive meaningful change.
In this role, you'll harness your love for data and statistics to deliver high-impact analytics using cutting-edge Business Intelligence platforms. Working closely with key stakeholders, you'll produce timely, insightful reports that go beyond performance metrics--helping shape strategic decisions that enhance patient care. You'll dive deep into complex scenarios, ask the right questions, and offer actionable recommendations to refine and elevate current practices.
You'll lead and contribute to a diverse portfolio of projects, from intelligence dashboards to innovative app development, all aligned with the Trust's data-driven strategy. Your ability to work both independently and collaboratively will be essential as you bring expert knowledge, curiosity, and a commitment to excellence into everything you do.
This is more than a data role - it's a chance to make a real difference in the lives of patients and the future of pharmacy services.
Main duties of the job
1. To be responsible for the development and production of medicines related reporting and data analytics along with pharmacy business intelligence metrics from our digital systems.
2. To ensure that timely, relevant and accessible information is available to relevant departmental, divisional and Trust stakeholders in relation to medicines and related pharmacy business activities.
3. To support the timely submission of month end medicine related financial data extracts to the relevant teams in finance to support the Trust in satisfying mandatory and contractual reporting obligations.
4. To ensure that data integrity is maintained and that submission of data is carried out accurately and timely.
5. To develop key relationships with colleagues within the trust reporting team, finance and commissioning teams along with relevant stakeholders (e.g. CDF, NHSE)
6. Track and analyse biosimilar switching trends to support decision-making in conjunction with the senior managers
About us
Bedfordshire Hospitals NHS Foundation Trust provides hospital services to a growing population of around 700,000 people living across Bedfordshire and the surrounding areas across two busy hospital sites in Bedford and Luton. Both hospital sites offer key services such as A&E, Obstetrics-led Maternity and Paediatrics. You will be joining a friendly, high performing Trust committed to ensuring the health and wellbeing of staff. As one of the largest NHS Trusts in our region you will have access to a programme of high quality training and development to help you grow your career. The Trust continues to be committed to delivering the best patient care using the best clinical knowledge and technology available.
Our values
We not only recruit based on qualifications and experience - we recruit individuals who demonstrate the behaviours which underpin our Trusts core values. We achieve this by using values based recruitment. We are dedicated to making our recruitment practices as inclusive as possible for everyone, we are committed to promoting equality and diversity, and creating a culture that values differences.
Please note that vacancies may close prior to the advertised closing date when sufficient number of applications have been received. All new staff will be subject to a probationary period covering first 6 months in post. Travel between hospital sites may be required. Please review all documents attached to ensure you familiarize yourself with all requirements of the job
Job description
Job responsibilities
The Job Description and Person Specification are attached to this job, please review for the full details and responsibilities
1. To be responsible for the extraction of data pertaining to medicines, including high cost drugs (HCD), from the Trusts information systems including Pharmacy Stock Control System, electronic Prescribing Medicines Administration (ePMA) System and other pharmacy systems. To ensure that all statutory activity data relating to medication activity is collated, validated, checked for accuracy and submitted in accordance with strict deadlines.
2. Extract and analyse datasets derived from pharmacy digital systems, to maintain regular performance reporting mechanisms for medicines and pharmacy activity across the Trust.
3. Set up and maintenance of a database with patients treated with excluded from tariff medicines as required
4. To assist in the recovery of funding for PbR excluded high cost drug exclusions and management of ICS / NHS England approvals for PbR excluded and exceptional circumstances drugs.
5. Carry out relevant audits and analysis on the use of PbR excluded drugs and NICE approved drugs used at Bedfordshire Hospitals NHS Foundation Trust.
Job description
Job responsibilities
The Job Description and Person Specification are attached to this job, please review for the full details and responsibilities
1. To be responsible for the extraction of data pertaining to medicines, including high cost drugs (HCD), from the Trusts information systems including Pharmacy Stock Control System, electronic Prescribing Medicines Administration (ePMA) System and other pharmacy systems. To ensure that all statutory activity data relating to medication activity is collated, validated, checked for accuracy and submitted in accordance with strict deadlines.
2. Extract and analyse datasets derived from pharmacy digital systems, to maintain regular performance reporting mechanisms for medicines and pharmacy activity across the Trust.
3. Set up and maintenance of a database with patients treated with excluded from tariff medicines as required
4. To assist in the recovery of funding for PbR excluded high cost drug exclusions and management of ICS / NHS England approvals for PbR excluded and exceptional circumstances drugs.
5. Carry out relevant audits and analysis on the use of PbR excluded drugs and NICE approved drugs used at Bedfordshire Hospitals NHS Foundation Trust.
Person Specification
Qualifactions
Essential
- GCSE English and Mathematics or equivalent
Desirable
- Educated to degree level or have equivalent experience within an information related role
Experience
Essential
- Experience in analytics and reporting using standard tools - e.g. Excel, Power Query, SQL, Crystal Reporting or Python
- Experience in building complex reports and using the software to create effective visualisations
- Experience of working to deadlines and managing own workload to meet the needs of a service
Desirable
- Experience of working in the NHS or other complex customer focused organisation
- Matrix working
Knowledge
Essential
- Good knowledge of healthcare data and how it is used both locally and nationally.
- Understanding of importance of Data within an NHS environment.
Personal Skills
Essential
- Ability to work to an extremely high level, with periods of intense concentration, dealing with interruptions as they arise, which may require a change of focus for urgent issues.
- Calm under pressure
- Willing to undertake in-house training on pharmacy computer systems
- Reliable and trustworthy
- Good written and verbal communication skills
- Accurate and organised
- Self-motivated and organised
- Able to work with minimum supervision; self-reliant
Other
Essential
- To handle patient identifiable/sensitive data correctly and within the confines of the Trust's Information Governance Policies.
Person Specification
Qualifactions
Essential
- GCSE English and Mathematics or equivalent
Desirable
- Educated to degree level or have equivalent experience within an information related role
Experience
Essential
- Experience in analytics and reporting using standard tools - e.g. Excel, Power Query, SQL, Crystal Reporting or Python
- Experience in building complex reports and using the software to create effective visualisations
- Experience of working to deadlines and managing own workload to meet the needs of a service
Desirable
- Experience of working in the NHS or other complex customer focused organisation
- Matrix working
Knowledge
Essential
- Good knowledge of healthcare data and how it is used both locally and nationally.
- Understanding of importance of Data within an NHS environment.
Personal Skills
Essential
- Ability to work to an extremely high level, with periods of intense concentration, dealing with interruptions as they arise, which may require a change of focus for urgent issues.
- Calm under pressure
- Willing to undertake in-house training on pharmacy computer systems
- Reliable and trustworthy
- Good written and verbal communication skills
- Accurate and organised
- Self-motivated and organised
- Able to work with minimum supervision; self-reliant
Other
Essential
- To handle patient identifiable/sensitive data correctly and within the confines of the Trust's Information Governance Policies.
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.
Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab).
From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab).
Additional information
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.
Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab).
From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab).
