EPMA Data Analyst

Cambridgeshire and Peterborough NHS Foundation Trust; Huntingdon, Peterborough, Cambridge; On-site; GBP 38,000 - 47,000; Full time

Job summary

A regional health organization is seeking an EPMA Data Analyst to develop and manage information systems for Electronic Prescribing and Medicines Administration. The ideal candidate will have strong NHS informatics experience and proficiency in Microsoft SQL Server. Responsibilities include ensuring accurate reporting and collaborating with clinical teams to improve data systems. Join a dedicated team committed to delivering high-quality care and enhancing patient outcomes.

Qualifications

• Experience with Electronic Prescribing and Medication Administration systems.
• Significant experience delivering BI solutions using Microsoft technologies.
• Experience working closely with healthcare professionals.

Responsibilities

• Develop and manage EPMA information systems and reporting solutions.
• Ensure high-quality data for internal and external reporting.
• Collaborate with clinical teams for system improvements and training.

Skills

Attention to detail

Advanced information management

Understanding of NHS data standards

Education

Informatics or numerate qualification to degree level

Tools

Microsoft SQL Server (SSIS, T-SQL, SSAS, SSRS)

PowerBi

Job description

EPMA Data Analyst

The closing date is 26 January 2026

Join us as a Data Analyst and play a key part in developing and managing information systems that support Electronic Prescribing and Medicines Administration (EPMA) reporting. You'll work with clinical and operational data, contribute to our data warehouse and business intelligence solutions, and help ensure high‑quality, trusted information for both internal and external reporting. If you have strong NHS informatics experience and advanced Microsoft SQL Server skills and want to contribute to enhanced patient care through data, we'd love to hear from you.

Main duties of the job

• Develop, manage, and improve information systems and reporting solutions for Electronic Prescribing and Medicines Administration (EPMA) data.
• Ensure high‑quality, accurate, and timely data for internal and external reporting, supporting management decision‑making and statutory requirements.
• Collaborate with colleagues, clinical teams, and external partners to deliver system improvements and training, and support research and service evaluation initiatives.
• Maintain documentation, uphold data governance standards, and contribute to quality, patient safety, and risk management.
• Stay current with national and local information standards, participate in training, and promote equality, diversity, and safeguarding within the Trust.

About us

Cambridgeshire and Peterborough NHS Foundation Trust is a health and social care organisation dedicated to providing high‑quality care with compassion to improve the health and wellbeing of the people we care for, as well as supporting and empowering them to lead a fulfilling life.

Our clinical teams deliver many NHS services, not only via inpatient and primary care settings, but also within the community. These services include children’s, adult and older people’s mental health, forensic and specialist mental health, learning disabilities, primary care and liaison psychiatry, substance misuse, social care, research and development.

To achieve our goal, we look to recruit high‑calibre candidates who share our vision and values. As an equal opportunities employer, we encourage applications from all sectors of the community, particularly from under‑represented groups including people with long term conditions and members of our ethnic minority and LGBTQ+ communities.

Please be advised we reserve the right to close adverts earlier than the closing date should we receive sufficient applications.

Regrettably, we cannot offer sponsorship for all our job roles. If you apply for a role that we cannot offer sponsorship for, unfortunately, your application form will be rejected from the process.

For further information on CPFT, please visit our website at www.cpft.nhs.uk

Job responsibilities

Please refer to the attached job description and person specification for full details of responsibilities.

• To support the delivery of effective and efficient services by enabling better management decision making. This is done by ensuring the availability of trusted information, both internally and externally, and supporting the information use capabilities of colleagues and ensuring that the organisations external activity reporting requirements are met.
• To make a senior contribution in the development of the CPFT data warehouse reporting solution, including data architecture, processing and appropriate presentation layer from a range of clinical and operational data sources. Whilst appropriate alternative solutions should be considered, the technical environment is mainly with Microsoft SQL Server products.
• With the support of the Head of Data, lead the reporting of all aspects of Electronic Prescribing and Medicines Administration reporting, data queries and returns.
• To be accountable for ensuring that assigned internal and external activity information is available to the required standard and meets the required quality and governance standards.
• To provide appropriate technical guidance and support within an informatics environment to colleagues within the Information and Performance department and the wider Trust.

Person Specification

Education

• Informatics or numerate qualification to degree level or equivalent experience in developing and implementing in management information systems.

Experience

• Experience of Electronic Prescribing and Medication Administration systems, data and reporting requirements.
• Significant experience of delivering BI and clinical systems solutions based on Microsoft technology, in particular MS‑SQL 2012 components (SSIS, T‑SQL, SSAS, SSRS), PowerBi or similar, and relevant clinical systems technology (CMM, SystmOne etc.)
• Experience of close working with healthcare professionals

Skills & Abilities

• Attention to detail in all aspects of work
• Advanced knowledge of the concepts of information management, e.g. taxonomies, dimensional hierarchies.
• Understanding of NHS data dictionary and other relevant Information standards, including the ability to apply these standards to system designs/developments.

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.

Cambridgeshire and Peterborough NHS Foundation Trust

£38,682 to £46,580 a year pro rata