EPMA Data Analyst
Job summary
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 andempowering 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 description
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.
- Microsoft certification in SQL Server BI stack components
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
Knowledge & Understanding
- 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.
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.
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.
Employer details
Employer name
Cambridgeshire and Peterborough NHS Foundation Trust
Address
Cambridge/Huntingdon/Peterborough
Cambridge/Huntingdon/Peterborough
CB21 5EF
Employer's website
https://www.cpft.nhs.uk/