Analytics Lead for Medicines and Pharmacy

Job summary

An exciting opportunity has arisen for a highly motivated, proactive, and dynamic data analyst with a background in working with complex data to lead on the provision and analysis of high-quality medicines-related data to stakeholders across UCLH and beyond.

The need for high quality data relating to medicines procurement, supply and use in clinical practice across the Trust has increased substantially in recent years to meet clinical, governance, financial, research and operational needs. In 2019, UCLH implemented a Trust-wide digital health record system, Epic, which captures data at every stage in the management of our patients. This new post has been established to work closely with pharmacy in delivering and analysing accurate, timely and contextualised data - mostly from Epic - to meet organisational needs.

The postholder will lead on the development and maintenance of pharmacy and medicines-related reports, as well as specific analytics and statistical modelling projects.

Main duties of the job

Lead on development and maintenance of pharmacy and medicines-related reports, as well as specific analytics and statistical modelling projects. Support or lead on a range of medicines-related quality initiatives, including:

Medicines-related data for R&D, quality improvement, innovation and audit needs Medication safety initiatives, such as monitoring dose omissions, unauthorised prescribing, alert and warning overrides, and medicines reconciliation rates Monitoring medicines formulary compliance and use of unlicensed or off-label medicines Medicines-related components of patient flow and operational performance Antimicrobial and antifungal stewardship programmes Other high risk medicine stewardship programmes Management of medicines shortages

The postholder will support in developing reports to identify opportunities for cost saving, cost avoidance and income recovery related to medicines expenditure. Support the Head of Analytics by contributing to/leading on statistical modelling projects aimed at improving patient outcomes and enhancing the trust's operational performance. The postholder will interpret the requirements of information users and present detailed, complex reports that can be understood by a wide audience. Experience in working with relational databases, good working knowledge of SQL or another database querying language, specialist knowledge of data analysis and visualisation, statistical modelling, and quantitative service evaluation techniques.

About us

University College London Hospitals NHS Foundation Trust (UCLH) is one of the most complex NHS trusts in the UK, serving a large and diverse population. We provide academically led acute and specialist services, to people from the local area, from throughout the United Kingdom and overseas. Our vision is to deliver top-quality patient care, excellent education, and world-class research.

We provide first-class acute and specialist services across eight sites:

University College Hospital (incorporating the Elizabeth Garrett Anderson Wing) National Hospital for Neurology and Neurosurgery Royal National ENT and Eastman Dental Hospitals University College Hospital Grafton Way Building Royal London Hospital for Integrated Medicine University College Hospital Macmillan Cancer Centre The Hospital for Tropical Diseases University College Hospital at Westmoreland Street

We are dedicated to the diagnosis and treatment of many complex illnesses. UCLH specialises in women's health and the treatment of cancer, infection, neurological, gastrointestinal and oral disease. It has world class support services including critical care, imaging, nuclear medicine and pathology.

At UCLH, we have a real 'One Team' ethos, and our values - safety, kindness, teamwork and improving, are central to the way we work. This is supported by our staff, who voted us as the #1 NHS Acute Trust to work for in the whole of England.

Job description

Job responsibilities

For the full Person Specification and more information regarding the main responsibilities of this role, please refer to the attached Job Description.

We are committed to sustainability and have pledged to become a carbon net zero health service, embedding sustainable practice throughout UCLH. We have set an ambitious target of net zero for our direct emissions by 2031 and indirect emissions by 2040.

Person Specification

Knowledge and Qualifications

Essential

1st degree level or equivalent Masters degree in health informatics-related subject or equivalent experience Specialist knowledge of data analysis and visualisation, statistical modelling and quantitative service evaluation techniques

Desirable

Understanding and knowledge of pharmacy environment and issues related to medicines data recording and reporting

Experience

Essential

Substantial post qualification experience in information analysis role in an NHS or other healthcare information environment Proven experience of working with relational databases Proven experience of managing information staff Significant experience of using and developing query tool functionality Track record of delivery at a senior level in a large complex service focused organisation, including staff management, change management, and performance management

Desirable

Significant experience of development using SQL Server Significant experience of using Microsoft BI stack Significant experience of development in Power BI Experience of using Epic BI stack, including developing Radar, Slicer Diver, Reporting Workbench contents

Skills and Abilities

Essential

Producing and using demand and capacity models Ability to interrogate databases Ability to interpret complex data Ability to convert data to management information Advanced use of Power BI and MS Excel, SQL Advanced use of MS Excel (macro level) Use of R and/or Python for machine learning and predictive analytics Ability to independently interpret the requirements of information users and present detailed, complex reports that can be understood by a wide audience Ability to design and develop information systems Understanding of data quality issues and how these relate to the organisation as a whole Understanding of the Acute Healthcare business environment, particularly relating to income generation, productivity and financial planning across the organisation as a whole In-depth understanding of waiting lists data and processes Proven track record of working under pressure to strict deadlines

Communication

Essential

Ability to communicate effectively with staff at all levels Excellent Oral and Written Communication Skills Ability to train other performance and information staff in the use of information systems Ability to communicate on issues which can be complex and multi-stranded Effective leadership of staff Engages in constructive debate and participates in evidence based decision making that is in the best interests of the Trust

Personal and People Development

Essential

Ability to plan, prioritise and meet deadlines Ability to take responsibility for own workload