Business Intelligence Developer

The Clatterbridge Cancer Centre's Business Intelligence team are looking for a new Business Intelligence Developer.

This isn't just another job; it's a chance to contribute to cancer care through the power of data and our cutting-edge reporting tools.

Here's where we need you:

• Craft stunning reports and dashboards that bring complex data to life, guiding crucial decisions that impact patient lives.
• Become the architect of our data warehouse, ensuring its smooth operation and unlocking its hidden insights.
• Collaborate with a vibrant, award-winning team and learn new skills along the way.
• Enjoy the flexibility of a blended work style: split your time between our Wirral Site, Liverpool Site, and the comfort of your home. We work at least 50% on-site.

This is no ordinary opportunity. It's a chance to:

• Help data make a difference in cancer care.
• Level up your skills with cutting-edge technology and a supportive, learning-focused environment.
• Join a team that celebrates innovation and thrives on pushing boundaries.

Main duties of the job

The Business Intelligence Developer will be responsible for the development of reports and dashboards to support the management of the Trust's chosen Business Intelligence and dashboard reporting solution. They will be responsible for assisting with the design, development, and maintenance of activity reporting across the Trust, as well as statutory reporting for external agencies.

This will involve collaborative working with the wider Business Intelligence team to embed development and automation in the analysts' daily life. This includes gathering requirements in order to develop solutions that are of a high standard and meet the demands of both internal and external stakeholders.

The Business Intelligence Developer will ensure development, testing, and deployment work is undertaken to a high standard using the agreed departmental methods and standards to deliver robust solutions with an acceptable level of performance, ensuring that developments are documented appropriately to facilitate cross-team support of solutions. This includes conforming to the agreed change management procedures in place.

The Business Intelligence Developer will support and educate colleagues across the organisation on the Trust Business Intelligence portal, data quality issues, and effective ways of working in relation to Business Intelligence.

About us

The Clatterbridge Cancer Centre is one of three specialist cancer centres in England. With 1,800 specialist staff and three sites, we are one of the largest NHS providers of non-surgical cancer treatment. The Trust has a unique multi-site care model serving the 2.4 million population across Cheshire and Merseyside and is consistently rated by patients as one of the best performing hospitals.

Our vision is to not only maintain this level of commitment to excellence but to work with our academic and healthcare partners across the region to ensure care, treatment, and patient outcomes continuously improve in the future. We are very proud of all our expert and loyal staff and we welcome people who share the collective aim of delivering excellence in everything that we do.

Our values represent who we are and what we believe in. They define how we act to deliver the best possible care for our patients and shape The Clatterbridge Cancer Centre as a great place to work.

We are -

• Kind
• Empowered
• Responsible
• Inclusive

Job responsibilities

Please see attached Job Description and Person Specification for full details about this exciting role on offer at The Clatterbridge Cancer Centre.

Person Specification

Qualifications

• Educated to relevant degree level or equivalent proven practical experience
• Membership of a relevant Fed-IP recognised professional body
• Evidence of continued Personal Development

Knowledge

• Experience and knowledge of using Microsoft SQL Server (including SSIS) to develop complex ETL and automation solutions
• Experience and knowledge of using Microsoft SQL Server Reporting Services to develop tabular, dashboard, and interactive reports.
• Experienced using Microsoft Office
• Good knowledge of Business Intelligence dashboarding and reporting
• Experience using Microsoft SQL Server Analysis Services to develop cubes to support reporting solutions
• Power BI

Experience

• Experience working in a BI development role or equivalent
• Experience developing and testing reporting solutions
• Experience documenting data flows and processes
• Good level of experience of data transmission software and techniques
• Understanding of information governance, freedom of information, and related issues in a clinical information environment
• Experience of Meditech
• Experience of supporting and providing training to end users
• Experience of discussing and collating end user requirements
• Experience of NHS data sets, broad understanding of NHS information procedures, legislation, and policies.

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.