EPR BI Lead and Data Warehouse Specialist

The Royal Orthopaedic Hospital NHS Foundation Trust; Birmingham; On-site; GBP 49,000 - 57,000; Full time

Job summary

The Royal Orthopaedic Hospital NHS Foundation Trust is seeking an EPR BI Lead & Data Warehouse Specialist to drive the reporting strategy for the Trust’s EPR system. You will work with clinical teams and the BI team to scope, plan and deliver high quality information that informs patient care and strategic decisions.

You will provide technical leadership for the EPR-aligned data warehouse, ensure integration of data sources, and engage with executives to translate clinical needs into robust

Qualifications

• Postgraduate degree or equivalent professional experience in IS/Data Science/CS.
• Professional BI/data platform certifications (Power BI or equivalent).
• Experience designing, developing and delivering robust BI and data warehouse solutions.

Responsibilities

• The BI Lead will oversee the development of the initial BI information service from datasets to Executives, Trust Management and Clinicians.
• Provide technical leadership for the EPR-aligned data warehousing and analytics, integrating data sources.
• Engage with Executive Team and clinical staff to understand and deliver data requirements for quality care.

Skills

Version control tools

Non-technical explanations

Project documentation

Education

Postgraduate degree in Information Systems / Data Science / CS

BI certifications (Power BI or equivalent)

Tools

Power BI

Job description

Employer The Royal Orthopaedic Hospital NHS Foundation Trust Employer type NHS Site The Royal Orthopaedic Hospital Town Birmingham Salary £49,387 - £56,515 per annum, pro rata if part-time. Salary period Yearly Closing 08/11/2026 08:00

EPR BI Lead and Data Warehouse Specialist

NHS AfC: Band 7

Job overview

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.

Working for our organisation

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.

Detailed job description and main 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.
• Ability to interpret and explain complex technical information in a non-technical way.
• Ability to create high quality project documentation including reports and policies.

Employer certification / accreditation badges