EPMA Data Analyst

Cambridgeshire and Peterborough NHS Foundation Trust (CPFT); Cambridge; On-site; GBP 40,000 - 48,000; Part time

Job summary

Cambridgeshire and Peterborough NHS Foundation Trust is seeking a part-time Data Analyst (18.75 hours per week) to develop and manage information systems supporting EPMA reporting. You will work with clinical and operational data, contribute to the data warehouse and BI solutions, and ensure trusted information for internal and external reporting.

The role requires strong NHS informatics experience and advanced Microsoft SQL Server skills, with a focus on delivering data-driven improvements for

Qualifications

• Informatics or numerate qualification at degree level or equivalent experience in MIS.
• Experience with Electronic Prescribing and Medication Administration data and reporting.
• Significant BI/clinical systems experience using Microsoft technologies.

Responsibilities

• Develop, manage, and improve information systems and reporting for EPMA data.
• Ensure high-quality, timely data for internal/external reporting.
• Collaborate with clinical teams and partners to deliver system improvements and training.
• Maintain data governance and quality standards.
• Stay current with information standards and promote equality and safeguarding.

Skills

Electronic Prescribing data reporting

BI reporting solutions

Healthcare data collaboration

Education

Informatics degree or numerate qualification

Tools

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

Power BI

Job description

Main area Informatics Grade Band 6 Contract Permanent: Working pattern Monday - Friday Hours

• Part time
• Flexible working

18.75 hours per week Job ref 310-CORP-8145265

Site Cambridge/Huntingdon/Peterborough Town Cambridge/Huntingdon/Peterborough Salary £39,959 - £48,117 per annum pro rata Salary period Yearly Closing 24/08/2026 23:59

Job overview

This post is part time - 18.75hrs per week

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.

Working for our organisation

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

Our clinical teams deliver a wide range of NHS services across inpatient, primary care and community settings, including 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, and research and development.

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

All appointments are subject to the successful completion of a probationary period.

Please note we reserve the right to close adverts early should we receive sufficient applications.

Regrettably, we cannot offer sponsorship for all roles. If you apply for a post that does not attract sponsorship, your application will be withdrawn from the process.

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

Detailed job description and main 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.

Here at Cambridgeshire and Peterborough NHS Foundation Trust (CPFT) we are dedicated to providing high quality care with compassion. We deliver many of the NHS services that are provided outside of hospital and in the community such as physical, mental health and specialist services.

We are a health and social care organisation, offering a wide range of services, including:

• Integrated physical and mental health services for adults and older people;
• Specialist mental health and learning disability services;
• Children’s community services in Peterborough;
• Ground-breaking research

We strongly encourage applications from all sections of the community, particularly from under-represented groups including disabled people and members of our ethnic minorities and LGBTQ+ communities. For further information about our positive equality, diversity and Inclusion work, please visit https://www.cpft.nhs.uk/equalityanddiversity .

CPFT is looking to build upon its pool of temporary workers with Temporary Staffing Services (TSS). You will be asked at interview if you would be willing to register with TSS. This is an excellent opportunity for those looking to take on additional hours that are flexible around your personal circumstances.

Please be advised that in line with the WHO Health Workforce Support and Safeguards List, 2020 Cambridgeshire and Peterborough NHS Foundation Trust currently are unable to accept applications from overseas candidates whose country of residence is classed as a ‘Red List’ country.

Applicants who require entry into the UK will be required to provide a valid police certificate from the relevant authority from each country (except the UK) where the applicant has been present for 12 months or more, 10 years before the date of visa application, while aged 18 or over.

If you are successful at interview you will be subject to pre-employment checks, including a DBS (if appropriate), references and Occupational Health. To ensure a smooth process please bring all identity documents to your interview. A list of required identity documents will be attached to your interview invitation.

All communications will be sent to you via TRAC Systems. By applying for this post you are agreeing to CPFT transferring the information contained in this application to TRAC. If you are made an offer, information will also be transferred into the national NHS Electronic Staff Records system.

Employer certification / accreditation badges

Name Jonathon Artingstall Job title Associate Director Information and Performance Email address [e-mail]