Business Intelligence Analyst

Wirral University Teaching Hospitals NHS Trust

As a key member of the business intelligence analytics team, this role will support the development and maintenance of reporting solutions delivered to trust staff. This will involve utilising all available technologies including Microsoft PowerBI, Data models, SQL Server, and all Microsoft Office products to develop fit-for-purpose reporting solutions. The role will support staff to access a wide range of reports and dashboards via the WUTH Business Intelligence (BI) Portal.

Working closely with the BI business partners for a division, this role will gather reporting requirements, design and develop reporting solutions, and attend meetings to support divisional requirements.

The role will also be responsible, as part of an analyst group, for the timely completion of mandatory and statutory data submissions to external organisations e.g. ICB and NHS England.

Main duties of the job

1. To support the design, development, and maintenance of web-based reporting solutions, proactively support the provision of analytics and Business Intelligence across the trust.
2. To proactively share knowledge with colleagues and support the delivery of training on a regular basis to end users within WUTH to improve overall skill levels in the retrieval of data/analytics.
3. To identify any data quality issues that might arise between Cerner Millennium, the trust's data warehouse(s), and the Business Intelligence reporting solutions.
4. To develop efficient automated processes to ensure the reporting solutions are updated in accordance with agreed timescales to support national returns and local reporting requirements.
5. Working with the BI Business Partners to ensure robust monitoring of reporting solutions are in place to highlight any issues including data quality and completeness.
6. To assist in the management, production, and timely delivery of a diverse range of ad-hoc information requests.
7. Ensure that all reporting processes are fully documented and reviewed on a regular basis and proactively identify where processes can be changed to improve service delivery.

Person Specification

Qualifications, Specific Experience and Training

• Degree or equivalent, relevant experience in an information/business intelligence department.
• Good SQL skills including the development of efficient data models.
• Good understanding of how to use Business Intelligence software tools (e.g. PowerBI, Tableau, business objects etc.).
• Experience of working with complex datasets and processing those datasets into automated data flows. Ability to identify and interpret the information needs of end users to support the development process.
• IT skills to allow full use of Microsoft Office software.
• Understanding and experience using clinical and operational data within an acute hospital e.g. clinical coding (HRG, OPCS4, ICD10, SNOMED), clinical terminology, Payment by Results, Service Line Reporting and contract planning.

Knowledge and Skills

• Excellent knowledge of analysing and interpreting large datasets and good understanding of visualising data/information for end users.
• Ability to gather user requirements and convert them into meaningful business intelligence reports.
• Good analytical skills to support multiple large datasets sometimes from different data sources and in different formats.
• Excellent skills in the analysis, presentation, and interpretation of information.
• Excellent communication skills, ability to establish and maintain good relationships with other team members and with service users, and to influence clinicians and managers.
• Excellent organisational skills relating to creating and maintaining electronic filing systems, locating data and information, and meeting deadlines.
• Commitment to share experience and knowledge and to keep others informed of issues of importance and relevance.
• Importance of maintaining confidentiality, in accordance with Data Protection Act and national/local guidelines.

Personal Attributes

• Self-starter with confidence to work with limited supervision and use of own initiative.
• Ability to prioritise own work by liaising with other staff and teams.
• Good verbal and written communication skills.
• Strong organisational and time management skills.
• Flexible approach to work and the ability to cope with change management.
• A methodical approach to work, with attention to detail in checking and verification of data.
• Ability to work under pressure and to tight deadlines.

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.

Wirral University Teaching Hospitals NHS Trust

Full-time, Flexible working, Home or remote working