EPR BI Lead and Data Warehouse Specialist

The Methodist Church in Britain; Birmingham; On-site; GBP 65,000 - 90,000; Full time

Benefits offered by this job

Inclusive, family friendly working

Flexible working arrangements

Guaranteed interview for disabled

Job summary

Royal Orthopaedic Hospital NHS Foundation Trust is seeking a talented BI Lead to steer the development of the information service for the EPR and data warehouse. You will work with clinical teams and the wider BI group to turn complex data into actionable management information for executives and clinicians.

The role provides technical leadership for the EPR-aligned analytics platform, coordinating with other Trusts and suppliers within a major digital programme.

Qualifications

• Designing, developing, testing and implementing robust reporting and data warehouse solutions.
• Supporting delivery of reporting solutions within a major digital or systems implementation programme.
• Knowledge of BI and data warehouse principles, reporting architectures and data flows.
• Experience with integrated dashboard design and development.

Responsibilities

• Oversee development of the BI information service from datasets to Executives, Trust Management and Clinicians.
• Provide technical leadership for the EPR-aligned data warehousing and analytics solution.
• Integrate EPR, legacy and downstream data sources for operational, clinical, regulatory and strategic reporting.
• Engage with the Executive Team and clinical staff to understand and deliver data requirements.
• Engage directly with other Trusts and suppliers.

Skills

BI knowledge

Dashboard design

Version control

Communication

Education

Postgraduate degree or equivalent

Tools

Power BI

Job description

A 12-month fixed-term post at the Royal Orthopaedic Hospital NHS Foundation Trust, leading business intelligence for the Trust's EPR system and data warehouse. The work centres on scoping, building and delivering clinical reporting with clinical teams and the wider BI team, turning complex data into management information for executives and clinicians. The role also provides technical leadership for the EPR-aligned data warehousing and analytics solution, and involves engaging directly with other Trusts and suppliers. Experience of delivering reporting within a major digital or systems programme is essential.

What the job involves

• Oversee 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 solution
• Integrate EPR, legacy and downstream data sources for operational, clinical, regulatory and strategic reporting
• Support delivery of the reporting strategy for data in the Trust's EPR system
• Contribute to the Trust's BI vision for the EPR Programme
• Scope, plan and deliver solutions with clinical teams and the wider BI team
• Build reports in the Trust's reporting solutions, complying with national data definitions where appropriate
• Analyse and manipulate complex data sets to provide EPR management information
• Make decisions on the best technical approach to specialist information issues
• Support EPR data modelling and scenario testing for service developments or changes
• Engage with the Executive Team and clinical staff to understand and deliver their data requirements
• Engage directly with other Trusts and suppliers

What’s required

Qualifications

• Postgraduate degree-level qualification in a relevant subject (e.g. Information Systems, Data Science, Computer Science) or equivalent relevant professional experience

Experience

• Designing, developing, testing and implementing robust reporting and data warehouse solutions
• Supporting delivery of reporting solutions within a major digital or systems implementation programme

Skills & knowledge

• Knowledge of Business Intelligence and data warehouse principles, including reporting architectures and data flows
• Knowledge of integrated dashboard design and development
• Experience of version control tools and techniques
• Ability to interpret and explain complex technical information in a non-technical way

Nice to have

• Relevant professional certifications in Business Intelligence, data platforms or analytics tools (e.g. Power BI)
• Experience supporting EPR or large clinical system implementations
• Experience working with BI tools and dashboards to support operational and clinical decision-making
• Knowledge of EPR data structures and reporting models
• Ability to create high quality project documentation, including reports and policies

What’s offered

• Inclusive, family friendly and flexible working arrangements and policies
• Flexible working requests considered
• Guaranteed interview for disabled applicants who meet the minimum criteria