EPR BI Lead and Data Warehouse Specialist

GEH; Birmingham; Hybrid; GBP 49,000 - 57,000; Full time

Job summary

The Royal Orthopaedic Hospital NHS Foundation Trust is seeking an EPR BI Lead and Data Warehouse Specialist to drive the BI information service for the EPR programme. You will oversee the data warehousing, analytics integration, and reporting to executives, clinicians and management.

You will engage with executive teams and clinical staff to understand data requirements and deliver high quality management information, while ensuring compliance with data definitions and reporting standards across

Qualifications

• Post Graduate Degree-level qualification in a relevant subject (e.g. Information Systems, Data Science, Computer Science) or equivalent professional experience.
• Professional certifications in BI, data platforms or analytics tools (e.g. Power BI or equivalent).
• Experience designing, developing, testing and implementing robust reporting and data warehouse solutions.
• Experience supporting reporting solutions within a major digital or systems implementation programme.
• Experience supporting EPR or large clinical system implementations.
• Experience working with BI tools and dashboards to support operational and clinical decision-making.

Responsibilities

• Please refer to the Job Description and Person Specification document for full list of details on the main responsibilities for the role.

Education

Post Graduate Degree-level qualification in a relevant subject

Relevant professional certifications in BI/data platforms

Tools

Power BI

Job description

EPR BI Lead and Data Warehouse Specialist

The closing date is 08 November 2026.

The EPR Business Intelligence Lead & Data Warehouse Specialist is responsible for supporting the delivery of the reporting strategy for data contained in the Trust's EPR system, they will work closely with both clinical teams and the wider Business Intelligence Team to scope, plan and deliver solutions that fulfil the Trust's clinical information reporting needs. The post holder will be a tenacious self-starter who will be able to engage directly with other Trusts and suppliers.

The BI Lead will ensure that reports are built using the Trust's reporting solutions in order to provide accurate, concise and clear information, ensuring compliance with national data definitions (where appropriate). The role will require analysis and manipulation of complex data sets to provide high quality EPR management information for the Trust's clinical staff and senior leaders. The post holder will regularly be required to make decisions on the best technical approach on specialist information issues and support any EPR data modelling or scenario testing for any service developments/changes.

A fundamental requirement of this role is the ability to engage with the Executive Team and clinical staff to understand and deliver on their data requirements for delivering quality care to everyone.

Main duties of the job

The EPR BI Lead & Data Warehouse Specialist will oversee the development of the initial Business Intelligence (BI) information service from the datasets to the Executives, Trust Management and Clinicians and contribute to the delivery of the Trust's Business Intelligence (BI) vision for the EPR Programme.

The role will provide technical leadership for the EPR-aligned data warehousing and analytics solution, ensuring that EPR, legacy and downstream data sources are integrated to support operational, clinical, regulatory and strategic reporting.

About us

The Royal Orthopaedic Hospital NHS Foundation Trust is one of the largest specialist orthopaedic units in Europe. We offer planned orthopaedic surgery to people locally, nationally and internationally.

Our Trust is a very special hospital; big enough to deliver world class services and small enough to offer exceptional patient and staff experience. We offer a working experience unique in the West Midlands and we're always on the lookout for passionate people to join our award-winning team.

The ROH is an equal opportunities employer. We employ people of difference and are committed to growing an inclusive culture, where difference is celebrated, and people feel able to bring their whole and authentic self to work.

We are a Disability Confident Leader and offer a range of inclusive, family friendly and flexible working arrangements and policies, to support our people in the workplace. Flexible working requests will be considered.

The Trust is committed to the Disability Confident Interview Scheme and will offer an interview to disabled applicants who meet the minimum criteria for a vacancy and consider them on their abilities.

If you have a disability and need any support with your application or require any reasonable adjustments to be implemented please do get in touch with the Recruiting Manager for this position so that the team can support you.

Job responsibilities

Please refer to the Job Description and Person Specification document for full list of details on the main responsibilities for the role.

Person Specification

Qualifications

• Post Graduate Degree-level qualification in a relevant subject (e.g. Information Systems, Data Science, Computer Science) or equivalent level of relevant professional experience
• Relevant professional certifications in Business Intelligence, data platforms or analytics tools (e.g. Power BI or equivalent)

Experience

• Experience of designing, developing, testing and implementing robust reporting and data warehouse solutions.
• Experience supporting the delivery of reporting solutions within a major digital or systems implementation programme.
• Experience supporting EPR or large clinical system implementations.
• Experience working with BI tools and dashboards to support operational and clinical decision-making

Knowledge

• Knowledge of Business Intelligence and data warehouse principles, including reporting architectures and data flows.
• Knowledge of integrated dashboard design and development.
• Knowledge of EPR data structures and reporting models

Skills

• Experience of version control tools and techniques.
• oAbility to interpret and explain complex technical information in a non-technical way.
• Ability to create high quality project documentation including reports and policies.

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.

The Royal Orthopaedic Hospital NHS Foundation Trust

£49,387 to £56,515 a yearper annum, pro rata if part-time.