Job Summary
We’re looking for a dynamic data and reporting specialist to join our pharmacy team and drive impactful improvements in drug expenditure management and data reporting. In this role, you’ll lead on developing innovative data solutions, harnessing SQL and Power BI to deliver real-time insights that inform key decisions, boost efficiency, and support cost-saving initiatives.
This role involves working within the Drug Expenditure Programme team and data performance team, collaborating closely with pharmacists and clinicians to use clinical informatics to identify savings, track CIP programmes and display pharmacy data for use by all levels of KCH staff with regards to medicines.
Main duties of the job
- To support the Chief Pharmacist, Deputy Chief Pharmacist, Associate Chief Pharmacist – Clinical Data Lead, Pharmacy Data and Information Manager and Senior Data Quality Analyst in the provision of information and analysis for the pharmacy department specifically around drug expenditure.
- To support the Data and Information Manager and Senior Analyst on the delivery of the clinical informatics objectives in the department with the view to scoping, developing and project managing process improvements around reporting, reporting tools, data quality and data intelligence.
- To liaise with users of information to resolve problems, provide innovative ways of presenting information, and develop new analyses to inform pharmacy team decision-making.
- To act as lead for individual projects & work streams within the department and hold responsibility for their delivery.
- To support the development of the Drug Expenditure Programme and the related reporting needs including a full suite of Power BI reports and Dashboards.
- To support the development of individuals in the Drug Expenditure Programme team.
Person Specification
Communication, relationships plannning and Organisation
Essential
- Interpret requirements and present reports that can be understood by a wide audience.
- Ability to manage unpredictable workloads that consist of conflicting and tight deadlines.
Qualification, Knowlege, Experience and Skill
Essential
- Degree in mathematics, computing or other discipline with a large numeracy component.
- Excellent data presentation skills, written, graphical and verbal.
- Substantial knowledge gained through analytical experience in Information Management within the NHS.
- Skilled in using data query tools, spreadsheets and databases.
- An ability to handle diverse information requests and analyse options with a non-technical audience.
- Able to retrieve and process data from a variety of systems, understand the data structures within the systems and join extracted data sets into uniform outputs.
- Substantial experience working with SQL Server or other Databases. A working knowledge of SSRS or Power BI, is desirable.
Desirable
- Experience of Pharmacy Dispensing Systems such as EMIS, JAC or EPIC (Willow).
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).
Closing Date: 15 October 2025
