Go back King's College Hospital NHS Foundation Trust
Pharmacy Data Analyst
The closing date is 15 October 2025
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.
About us
King's College Hospital NHS Foundation Trust is one of the UK's largest and busiest teaching Trusts with a turnover of £1 billion, 1.5 million patient contacts a year and more than 15,000 staff based across South East London. The Trust provides a full range of local and specialist services across its five sites. The trust-wide strategy of Strong Roots, Global Reach is our Vision to be BOLD, Brilliant people, Outstanding care, Leaders in Research, Innovation and Education, Diversity, Equality and Inclusion at the heart of everything we do. By being person-centred, digitally-enabled, and focused on sustainability, we aim to take Team King's to another level.
We are at a pivotal point in our history and we require individuals who are ready to join a highly professional team and make a real, lasting difference to our patients and our people.
King's is committed to delivering Sustainable Healthcare for All via our Green Plan. In line with national Greener NHS ambitions, we have set net zero carbon targets of 2040 for our NHS Carbon Footprint and 2045 for our NHS Carbon Footprint Plus. Everyone's contribution is required in order to meet the goals set out in our Green Plan and we encourage all staff to work responsibly, minimising their contributions to the Trust's carbon emissions, waste and pollution wherever possible.
Job responsibilities
1. Information service
To be a lead contact in addressing both the Pharmacy teams analytical and reporting requirements, advising on complex analysis requirements and reporting structures to Pharmacy management teams.
To gain a working knowledge of the Trust and its services specifically around their interaction with the Pharmacy team and drug expenditure, utilising your existent or acquired understanding of operational business to advise on information requirements, statutory reporting and new measurements where appropriate.
To play a pivotal role, with the direction of the Senior Analyst, in the development of new ways of presenting and visualising data to increase accessibility and immediacy to Pharmacy Teams, Finance and Contracts/Business Intelligence Colleagues within the Trust.
Through your own knowledge of SQL, to accurately script and report on the aforementioned datasets, specifically from the EPIC Willow Pharmacy Module.
To share your knowledge and develop the Drug Expenditure teams and the Data and Technology teams own knowledge of activity datasets, informatics, SQL scripting (MSSQL) and data interrogation.
To provide timely and accurate reporting to enable the Pharmacy teams performance management framework to be implemented, using central and local data sources as required.
To scrutinize data and proactively report on changes in trends or patterns, particularly focusing on defined key performance indicators specifically relating to Drug Expenditure and the Operational running of the Department.
To collate, monitor, manage and produce timely and accurate dashboards and reports to support the Pharmacy teams Cost Improvement Program (CIP) and Quality, Innovation, Productivity and Prevention (QIPP) targets.
Assist with adhoc requests from staff who work in the Pharmacy Department
2. Corporate role
To be a senior member of the department in supporting and advising both the team and non-technical staff outside of the department on complex and routine ad-hoc reporting on Pharmacy data. Leading on key areas of reporting, both internal and external (statutory)
To work with key service staff to develop knowledge of regular Trust information systems and their use by operational and clinical teams.
To manage your own workload of reporting requirements to agreed timetables and plan core corporate tasks with colleagues and, through managing and supporting the workloads of the Drug Expenditure and Data Performance Teams, ensure delivery of collaborative or work stream-related projects.
To ensure the Department meets its regular reporting responsibilities such as high cost drug submission to commissioners.
To work with the team in facilitating the expansion of the Pharmacy Teams use of clinical, benchmarking and performance data; and to be a pro-active user of benchmarking systems to inform current performance and future target-setting.
To work together with other senior members of the department and the Pharmacy Information Systems Team to increase the volume of information sources the department has direct access to.
To support the Associate Chief Pharmacist - Clinical Data Lead, Data and Information Manager and Senior Analyst and Principal Pharmacist for Data and Technology, in implementing relevant information related policies and data set changes and communicate issues to the wider analytical team and relevant staff within the Trust.
Review Trust wide drug expenditure data and liaise with clinical pharmacy colleagues to identify potential cost reduction opportunities as well as reviewing CMU contracts for potential savings opportunities.
Being part of the team, and sometimes acting as lead, in fulfilling the Pharmacy teams responsibility to provide information in accordance with the Freedom of Information Act and internal Information Governance.
To challenge both Pharmacy staff and Management teams in the development and interpretation of performance indicators in support of performance management.
To provide commentary and detailed information where required for Pharmacy staff and management teams to increase understanding of performance indicators and how they can be used efficiently to manage the department performance.
To advise on information and data analyses required to improve data recording processes, where data quality issues are preventing staff from monitoring and actioning due to poor data quality.
To advise Management teams and Pharmacists on internal and external benchmarking information in the identification of targets and standards to monitor and support improvement of performance.
To work with managers and management staff to identify new information reporting needs and further develop one's technical skills to add value.
To appropriately characterise, formally define, and deliver on current and emerging reporting requirements.
4. Other responsibilities
To become competent in fulfilling the departments regular reporting responsibilities, through reporting development software such as SSRS, Power BI & Power Pivot.
To ensure production of regular reports to external bodies such as NHS England/Model Hospital and ICBs; and ensuring policy such as NICE guidance from those external bodies is adhered to.
To provide detailed and accurate activity modelling to enable budget setting around drug forecasting and CIP and QIPP planning.
To attend, where required, operational and clinical performance management meetings.
Database administration duties involve maintaining and loading information to the pharmacy data warehouse. This contains all information around drug procurement and drug dispensing to patients and wards from EPIC data sources such as the general ledge feed, high-cost drugs billing feed or EPIC Caboodle tables.
To encourage staff to fulfil their potential by identifying opportunities for them to technically upskill and develop analytical skills to forward the interests of the Pharmacy department.
To take an active role in team meetings to contribute to the planning and development of the Drug Expenditure Program and the Data Performance Team.
Ensure data quality through necessary data validation practices
Person SpecificationCommunication, relationships plannning and Organisation
- 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
- 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.
- 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.
King's College Hospital NHS Foundation Trust
£56,276 to £63,176 a yearPer annum including HCA
#J-18808-Ljbffr
