King's College Hospital NHS Foundation Trust logo
Full-time
On-site
London, London, United Kingdom

King’s College Hospital NHS Foundation Trust is one of the UK’s largest and busiest teaching Trusts with a turnover of c£1.8 billion, 1.5 million patient contacts a year and more than 15,000 staff based across 5 main sites in South East London. The Trust provides a full range of local hospital services across its different sites, and specialist services from King’s College Hospital (KCH) sites at Denmark Hill in Camberwell and at the Princess Royal University Hospital (PRUH) site in the London Borough of Bromley.

We encourage all our staff to have a healthy work/life balance. In doing so, you can apply for flexible working from the beginning of your employment. We offer a range of options which are designed to suit different circumstances and priorities in line with service requirements. 

flexible-working

Job overview

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.

 

 

Advert

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

Working for our organisation

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.

Detailed job description and main 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 team’s 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 team’s 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 Team’s 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 team’s responsibility to provide information in accordance with the Freedom of Information Act and internal Information Governance.

3.    Liaison role

·         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 department’s 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

IMPORTANT

  • Check your email account regularly as this is how we will communicate with you
  • If you delete the job from any of your accounts, you may be prevented from accessing further communications
  • To enquire about your application or inform us of any changes in your circumstances, please contact the named person on this advert
  • Please provide email addresses for referees where possible
  • Click here to see the range of benefits we offer
  • Please review the documentation on our recruitment microsite, particularly the Trust’s criminal records checking policy
  • All staff have a responsibility for safeguarding children and vulnerable adults and for ensuring they are aware of the specific duties relating to their role.
  • Please note that the closing date is given as a guide. On occasion, we might close a vacancy early due to a high number of applications being received. You are advised to submit your application as early as possible to avoid disappointment.

King's College Hospital NHS Foundation Trust Annual Reports and Other Corporate Publications


King's Health Partners Academic Health Science Centre Website

King's College Hospital is part of King's Health Partners Academic Health Sciences Centre (AHSC), a pioneering collaboration between King's College London, and Guy's and St Thomas', King's College Hospital and South London and Maudsley NHS Foundation Trusts.