Pharmacy Data Analyst

Job description

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.

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

Certificate of Sponsorship

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

Employer details

Employer name

King's College Hospital NHS Foundation Trust

Address

King's College Hospital

Denmark Hill

London

SE5 9RS

Employer's website

https://www.kch.nhs.uk/ (Opens in a new tab)