Pharmacy Data Analyst

Oxford University Hospitals NHS Foundation Trust; Oxford; On-site; GBP 42,000 - 54,000; Full time

Job summary

Oxford University Hospitals NHS Foundation Trust is seeking an analytical professional to provide dedicated support to the Medicines Value and Biologics team. You will analyse medicines usage, activity and expenditure data, focusing on high-cost drugs, biologics and biosimilars, and translate findings into actionable insights for decision-making.

You will develop and maintain dashboards using Power BI, Rx-Info (Define/Refine) and Excel to support medicines optimisation, CIP delivery, NHSE and

Qualifications

• Experience analysing medicines usage, expenditure and activity data.
• Familiar with high-cost drugs and biosimilars.
• Strong data governance and IG/GDPR awareness.

Responsibilities

• Analyse medicines usage and expenditure data from Trust systems.
• Develop dashboards and reports using Power BI, Rx-Info and Excel.
• Support medicines optimisation and Cost Improvement Programmes (CIPs).
• Contribute to NHSE and Blueteq reporting requirements.
• Present complex data to stakeholders.

Skills

Power BI

Rx-Info

Excel

Tools

Power BI

Rx-Info Define/Refine

Excel

Job description

An exciting opportunity has arisen for the successful post holder to provide dedicated analytical support to the Pharmacy Medicines Value and Biologics team, enabling the cost-effective, evidence-based use of medicines across the Trust. The role will focus on the analysis, interpretation and reporting of medicines usage, activity and expenditure data, with particular emphasis on high-cost drugs, biologics, and biosimilars. The post holder will support the delivery of medicines optimisation programmes, Cost Improvement Programmes (CIPs), and gain share agreements with the Integrated Care Board (ICB). Using tools such as Power BI, Rx-Info (Define/Refine) and Trust data systems, the post holder will develop dashboards and reports to:

• Monitor high-cost drug and biologics use
• Identify variation and opportunities for improvement
• Support cost-effective medicines uptake and pathway compliance
• Enable robust tracking and validation of savings

The role will also contribute to NHSE and Blueteq reporting requirements, ensuring data is accurate, timely, and aligned with commissioning criteria. Working closely with pharmacy, finance and digital teams, the post holder will translate complex data into meaningful insights to support decision-making, improve value, and contribute to the Trust's financial sustainability. Please note that we cannot provide sponsorship for this role. The post holder will analyse and interpret medicines usage and expenditure data, with a particular focus on high-cost drugs, biologics, and medicines. They will develop and maintain reports and dashboards using tools such as Power BI, Rx-Info, and Excel to support medicines optimisation, Cost Improvement Programmes (CIPs), and gain share delivery. The role includes supporting NHSE and Blueteq reporting requirements, identifying variation in prescribing, and providing clear, data-driven insights to pharmacy, finance, and clinical teams. In addition, the post holder will contribute to improving data quality, maintaining reporting processes and documentation, and responding to ad hoc information requests. They will work collaboratively across teams to support service development, ensure compliance with data governance standards, and enable informed decision-making across the organisation., The post holder will provide high-quality analytical support to the Medicines Value and Biologics team to enable the cost-effective, evidence-based use of medicines across the Trust. The role will focus on the management, analysis, and interpretation of medicines data, with a particular emphasis on high-cost drugs, biologics, and biosimilars, supporting both financial and clinical decision-making.

Analytical and Reporting Responsibilities

• Analyse medicines usage, activity, and expenditure data from Trust systems and external sources
• Identify trends, variation, and outliers in prescribing, particularly in high-cost drugs and biologics
• Produce accurate and timely routine and ad hoc reports to support medicines optimisation, CIPs, and gain share agreements
• Develop and maintain dashboards using tools such asPower BI,Rx-Info (Define/Refine), and Microsoft Excel

Medicines Value and Biologics Support

• Support monitoring of biologics and biosimilar use, including uptake and compliance with agreed pathways
• Contribute to identifying opportunities for cost savings and improved value through data analysis
• Support biologics switching programmes and other medicines optimisation initiatives
• Assist in tracking and validating delivery of medicines-related savings and financial benefits

High-Cost Drugs and NHSE Reporting

• Support analysis and reporting ofNHSE high-cost drugs, including activity and expenditure
• Assist withBlueteq reporting and validation, ensuring data aligns with commissioning criteria
• Work with pharmacy and finance teams to support internal and external reporting requirements

Data Quality and Governance

• Maintain high standards of data quality and integrity across all datasets
• Identify and escalation data quality issues and support improvements where required
• Ensure compliance withInformation Governance, GDPR, and Trust policies
• Maintain clear documentation and standard operating procedures for reports and processes

Communication and Stakeholder Engagement

• Present complex data in a clear and meaningful way to a range of stakeholders
• Respond to ad hoc data requests, ensuring outputs meet user requirements and deadlines
• Work collaboratively with pharmacy, finance, and digital teams to support service development and performance monitoring

Service Development and General Duties

• Contribute to continuous improvement of reporting processes and analytical capability
• Support development of standardised reporting and dashboards across the service
• Work independently within agreed objectives, escalating issues appropriately
• Undertake any other duties consistent with the grade and role, as required by the Medicines Value and Biologics team

Oxford University Hospitals NHS Foundation Trustis one of the largest NHS teaching trusts in the country. It provides a wide range of general and specialist clinical services and is a base for medical education, training and research. The Trust comprises four hospitals - the John Radcliffe Hospital, Churchill Hospital and Nuffield Orthopaedic Centre in Headington and the Horton General Hospital in Banbury.

Our values, standards and behaviours define the quality of clinical care we offer and the professional relationships we make with our patients, colleagues and the wider community. We call this Delivering Compassionate Excellence, and its focus is on our values of compassion, respect, learning, delivery, improvement and excellence. These values put patients at the heart of what we do and underpin the quality healthcare we would like for ourselves or a member of our family. Watch how we set out to deliver compassionate excellence via theOUH YouTube channel. In 2023 NHS England launched its first sexual safety charter, and our Trust proudly signed it. We pledge zero tolerance for inappropriate sexual behaviour and commit to theten core principles Oxford University Hospitalspromotes a safe, respectful hiring environment. If you want to make a difference with us, come and join our team. Together, we will uphold the highest standards of care and professionalism.