Job Summary
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.
Main duties of the job
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
Job description
Job responsibilities
- 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 Epics 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;
Person Specification
Qualifications
Essential
- Educated to master’s level or equivalent experience
- Evidence of continuing professional development
Desirable
Knowledge
Essential
- Specialist knowledge of information analysis, in particular, of patient activity and use of information across the NHS acquired through relevant senior analytical and managerial experience
- Advanced skills in report development using an enterprise reporting tool (eg Crystal, Tableau, MS Power BI, Business Objects)
- Advanced SQL skills, including advanced querying and report writing
- Knowledge of NHS clinical systems
- Extensive knowledge of NHS Information standards
- Knowledge of strategic developments in health informatics and particularly related to SCCI and the National Information Board and NHS England
- Good working knowledge of operational practice in an acute NHS setting
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.
Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab).
From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab).
Closing Date: 24 March 2025
