EPMA Data Analyst

Cambridgeshire and Peterborough NHS Foundation Trust; Cambridge; On-site; GBP 45,000 - 65,000; Full time

Job summary

Cambridgeshire and Peterborough NHS Foundation Trust (CPFT) is seeking a data informatics professional to advance management information systems, ensuring trusted information for decision making and external reporting.

You will oversee CPFT's data warehouse reporting, leveraging MS SQL Server tools, supporting Electronic Prescribing and Medicines Administration reporting, and upholding data quality and governance standards. Guidance within the Information and Performance department is expected.

Qualifications

• 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 (Desirable).

Responsibilities

• To support the delivery of effective and efficient services by enabling better management decision making by ensuring the availability of trusted information and supporting information use capabilities of colleagues and external reporting requirements.
• To lead the reporting of Electronic Prescribing and Medicines Administration data, data queries and returns under the Head of Data.
• To ensure assigned internal and external activity information meets required quality and governance standards.
• To provide technical guidance within an informatics environment to colleagues in the Information and Performance department and the wider Trust.

Skills

BI reporting

SQL Server

Power BI

Healthcare data

Education

Degree in Informatics or related

Tools

MS-SQL

SSIS

SSAS

SSRS

Job description

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

Essential criteria

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

Desirable criteria

• Microsoft certification in SQL Server BI stack components

Experience

Essential criteria

• 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.)

Desirable criteria

• Experience of close working with healthcare professionals

Skills & Abilities

Essential criteria

• Attention to detail in all aspects of work

Knowledge & Understanding

Essential criteria

• 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 and young people's mental health services;
• Children's community services in Peterborough;
• Social care;
• 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 visi