EPR BI Lead and Data Warehouse Specialist

EPR BI Lead and Data Warehouse Specialist

The closing date is 03 March 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.

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.

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.

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

• 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 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…