Senior Business Intelligence Developer

We are looking for a highly motivated, enthusiastic and experienced person with a passion for data, digital transformation and service improvement in Healthcare.

This role will be part of a team that supports the development of the Epic suite of Business Intelligence (BI) tools to enable and deliver the organisation’s performance monitoring and information reporting requirements.

We are seeking applicants who possess excellent IT skills, have a thirst for learning something new, and have a genuine interest in achieving improved patient pathways through the implementation of the Epic EPR system. Epic training and certification in the data and reporting area is essential to this role.

The Senior Business Intelligence Developer will work on data development and configuration within the Cogito team. The post holder’s prime responsibility will be to deliver the data tools to meet the Trust’s performance and national information reporting requirements. It is an exacting role to ensure that the data fields in Epic translate to the relevant local and national requirements.

The post-holder will undertake training to learn complex Epic skills and will support the re-architecture, the extraction, transfer and load of data from Epic’s data warehouse into required national reporting requirements, local performance and contracting information. This role will utilise the post-holder’s sound data and information system knowledge combined with excellent analytical skills.

Principal Duties

• Develop the data tools to meet the Trust’s key reporting requirements.
• Make a significant contribution to the design and development of the Epic BI environment.
• Be an Epic EPR subject matter expert for assigned elements of the integrated reporting warehouse (Caboodle, Clarity, Radar, Slicer Dicer and the Reporting Workbench).
• Ensure the transition of using Epic to drive scheduled reports and national returns are produced accurately.

This role is working as part of a Devon wide team to deliver the implementation of Epic across Torbay and South Devon NHS Foundation Trust and University Hospitals Plymouth NHS Trust. Travel across Devon will be required to suit the needs of the programme.

This role is being advertised by Torbay and South Devon NHS Foundation Trust however applications from staff employed by Royal Devon University Healthcare NHS Foundation Trust and University Hospitals Plymouth NHS Trust are welcome to apply. Should a member of staff from either the Royal Devon University Healthcare NHS Foundation Trust or University Hospitals Plymouth be appointed you will remain employed by your existing employer.

By applying for one of these vacancies you are agreeing for your application and personal information to be shared between the three organisations as necessary to complete the recruitment process.

Complete all required Epic courses and certifications (in the UK or overseas) and within 6 months of commencement become qualified in the relevant Epic BI modules for which the role is responsible.

Support the re-architecture, the extraction, transfer and load of data from Epic’s data warehouse into required national reporting requirements, local performance and contracting information.

Become fully conversant with the relevant data models and entity relationships within the Epic BI environment.

Make a significant contribution to the design and development of the Epic BI environment.

Comply with Epic EPR documented quality standards.

Be an Epic EPR subject matter expert (SME for assigned elements of the integrated reporting warehouse – Caboodle, Clarity, Radar, Slicer Dicer and the Reporting Workbench).

Ensure that the BI capability includes: all mandated data set returns, all mandated performance reports, and all locally agreed dashboards and KPI reports.

Ensure the transition of using Epic to drive scheduled reports and national returns are produced accurately, too nationally and locally agreed standards, and delivered to agreed and mandated timetables. This will involve a complete re-design of extraction, transfer and load of data and therefore information output.

To work closely with Cogito Systems DBAs within the Technical Design team and to ensure the requirements are well described and documented.

Ensure compliance with the Trust Governance Procedures, Policies and Standards as they apply to the Business Intelligence environment.

Work with assigned Divisional and Departmental leads to ensure that all their BI needs are met in a timely and sustainable way that allows them to become self-sufficient in the production of local analytics and dashboards.

Use conflict resolution strategies in response to barriers of understanding or acceptance faced by or from the configuration teams and or wider Trust audience.

To provide cover for other team members as required.

To attend meetings as appropriate and, when required, to act as the Business Intelligence Shared Service representative.

To promote new ways of working with Business Intelligence tools within the Trust.