Job summary
Clatterbridge Cancer Centre Award winning "Non-Clinical Team of the Year", is on the hunt for a BI Developer to join our team.
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 your magic comes in:
- Craft stunning reports and dashboardsthat 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 teamat the forefront of cancer research and treatment.
- 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 to cancer outcomes
- Level up your skillswith cutting-edge technology and a supportive,learning-focused environment.
- Join a team that celebrates innovation and thrives on pushing boundaries.
This is a 12-month fixed-term contract initially, following an internal promotion.
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 Trusts 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 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 NHS Foundation Trust is one of the UK's leading providers of non-surgical cancer treatment, caring for apopulation of 2.4 million people across Cheshire & Merseyside, North Wales, the Isle of Man and parts of Lancashire.
Our flagship specialist cancer hospital in Liverpool opened in June 2020, supported by our hospital on the Clatterbridge Health Park in Wirralproviding outpatient cancer treatment and supportive care, and our radiotherapy treatment centre on the Aintree Hospital site.
Together, working across three sites and operating specialist chemotherapy clinics in four of Merseyside's district hospitals, we are able to deliver a comprehensive range of inpatient care, advanced radiotherapy, chemotherapy and other systemic anti-cancer therapies including genetherapies and immunotherapies. We also deliver a pioneering Treatment at Home and Work service; are the only facility in the UK providing low energyproton beam therapy to treat rare eye cancers and host the region's Teenage and Young Adult Unit, (supported by the Teenage CancerTrust).
Working with leading experts from The University of Liverpool and the Cancer Research UK Liverpool Cancer Trials Unit we strive to stay at theforefront of novel treatments and techniques to deliver more effective and personalised treatments than ever before.
Job description
Job responsibilities
Responsibility for Information Resources1. To support the Head of Business Intelligence with the provision of data and information for use by the directorates, clinicians, corporate teams, Board of Directors, Council of Governors, NHS Improvement, and Clinical Commissioning Groups by leading the development function.2. Lead the development of new information management initiatives, including a self-service portal for all dashboards and reporting requirements for the Trust.3. Work closely with the database administrators and integration team to ensure development and maintenance of the Trust Data Model(s) and associated architecture artefacts and technical standards.
4. Working with the integration team provide expertise in integrating, and optimising structured and/or unstructured data using highly complex database products, technologies, and methods. Typical examples of the deliverables are database designs, information models (logical, physical and dimensional), data migration plans, and data warehouse repositories.5. Proactively manage the integrity of data within the warehouse: investigating, raising and resolving issues with the appropriate Trust managers.6. To utilise the Trusts data warehouse for all appropriate information requests.7. Work closely with the Clinical Systems Team to ensure that all additions and changes to the clinical system are specified for the data warehouse and information needs.8. Work closely with the Clinical Effectiveness Team and Clinical Coding Team to ensure data processing and analysis is standardised and consistent through the wider Business Intelligence Function.9. Work closely with the Principal Information Analyst to ensure that all analytics requirements are streamlined and maintained following best practice regarding national submissions policies and procedures.10. Ensure that all reporting is fully compliant with data protection legislation, Trust policy and more generally that our reporting conforms to information governance best practice.11. To line manager the Principal Information Analyst and to oversee process whereby data is extracted or retrieved from all Trust information systems.
Analytical and Judgement Skills1. Lead the development of the Business Intelligence framework for all Trust wide Information requirements2. Working with the wider business intelligence team to take a lead in the development of reports and dashboards to users specifications to deliver bespoke performance information and clinical reporting to all relevant departments of the Trust.3. Produce timely and accurate briefing reports and other reports, on own initiative and on request as required. This involves analysing complex data and information from a range of sources.4. Responsible for analysis of highly complex and sensitive data within the data warehouse and the investigation of new data sources.5. Maintain a current working knowledge of NHS and Trust information systems, analytical techniques, departmental policies and procedures as required. Alert and advise other members of the team to information system changes that may affect the recording or reporting of service performance.
Planning and Organisational Skills1. To develop and ensure implementation/compliance of strategies to enable the effective functioning of the Trust in a changing environment, responding to both internal and external pressures in line with, and when appropriate, influencing the Trust Business Intelligence Strategy.2. Responsible for data mapping, detailed data analysis and metadata analysis; creating and maintaining mapping documents and technical documentation. To be responsible for generating the standard operating policies and procedures for the Trusts data warehouse and for updating these policies as developments are made3. To ensure all information outputs of the Data Warehouse are accurate, fit for purpose, delivered to time and follow the agreed development methodology with full written documentation.
4. Ensure that business continuity and escalation procedures are in place to support all areas of intelligence responsibility
Job description
Job responsibilities
Responsibility for Information Resources1. To support the Head of Business Intelligence with the provision of data and information for use by the directorates, clinicians, corporate teams, Board of Directors, Council of Governors, NHS Improvement, and Clinical Commissioning Groups by leading the development function.2. Lead the development of new information management initiatives, including a self-service portal for all dashboards and reporting requirements for the Trust.3. Work closely with the database administrators and integration team to ensure development and maintenance of the Trust Data Model(s) and associated architecture artefacts and technical standards.
4. Working with the integration team provide expertise in integrating, and optimising structured and/or unstructured data using highly complex database products, technologies, and methods. Typical examples of the deliverables are database designs, information models (logical, physical and dimensional), data migration plans, and data warehouse repositories.5. Proactively manage the integrity of data within the warehouse: investigating, raising and resolving issues with the appropriate Trust managers.6. To utilise the Trusts data warehouse for all appropriate information requests.7. Work closely with the Clinical Systems Team to ensure that all additions and changes to the clinical system are specified for the data warehouse and information needs.8. Work closely with the Clinical Effectiveness Team and Clinical Coding Team to ensure data processing and analysis is standardised and consistent through the wider Business Intelligence Function.9. Work closely with the Principal Information Analyst to ensure that all analytics requirements are streamlined and maintained following best practice regarding national submissions policies and procedures.10. Ensure that all reporting is fully compliant with data protection legislation, Trust policy and more generally that our reporting conforms to information governance best practice.11. To line manager the Principal Information Analyst and to oversee process whereby data is extracted or retrieved from all Trust information systems.
Analytical and Judgement Skills1. Lead the development of the Business Intelligence framework for all Trust wide Information requirements2. Working with the wider business intelligence team to take a lead in the development of reports and dashboards to users specifications to deliver bespoke performance information and clinical reporting to all relevant departments of the Trust.3. Produce timely and accurate briefing reports and other reports, on own initiative and on request as required. This involves analysing complex data and information from a range of sources.4. Responsible for analysis of highly complex and sensitive data within the data warehouse and the investigation of new data sources.5. Maintain a current working knowledge of NHS and Trust information systems, analytical techniques, departmental policies and procedures as required. Alert and advise other members of the team to information system changes that may affect the recording or reporting of service performance.
Planning and Organisational Skills1. To develop and ensure implementation/compliance of strategies to enable the effective functioning of the Trust in a changing environment, responding to both internal and external pressures in line with, and when appropriate, influencing the Trust Business Intelligence Strategy.2. Responsible for data mapping, detailed data analysis and metadata analysis; creating and maintaining mapping documents and technical documentation. To be responsible for generating the standard operating policies and procedures for the Trusts data warehouse and for updating these policies as developments are made3. To ensure all information outputs of the Data Warehouse are accurate, fit for purpose, delivered to time and follow the agreed development methodology with full written documentation.
4. Ensure that business continuity and escalation procedures are in place to support all areas of intelligence responsibility
Person Specification
Qualifications
Essential
- oEducated to relevant degree level or equivalent proven practical experience
Desirable
- Membership of a relevant Fed-IP recognised professional body
- Evidence of continued Personal Development
Knowledge
Essential
- oExperience and knowledge of using Microsoft BI Stack
- oGood knowledge of Business Intelligence dash boarding and reporting.
Desirable
- Experience using Microsoft SQL server Analysis Services to develop cubes to support reporting solutions
- Experience using version control
Experience
Essential
- oExperience working in a BI development role or equivalent
- oExperience developing and testing reporting solutions
- oExperience documenting data flows and processes
- oGood level of experience of data transmission software and techniques
Desirable
- oExperience of Meditech
- oExperience of supporting and providing training to end users
- oExperience of discussing and collating end user requirements
- oExperience of NHS data sets, broad understanding of NHS information procedures, legislation and policies.
Skills
Essential
- oAbility to design, develop and deploy BI solutions
- oExcellent problem solving skills for investigating data or processing anomalies
- oAbility to work under pressure and to meet deadlines
- oAbility to analyse and judge situations containing complex facts or situations and to examine a range of options related to them
- oAbility to work autonomously plan, and manage own workload.
- oAbility to present technical information in a meaningful manner to non-technical audience, as well as analyse, present and interpret data from a number of different sources
Desirable
- oMicrosoft SQL Server certification
- oExperience of Negotiating deadlines
Person Specification
Qualifications
Essential
- oEducated to relevant degree level or equivalent proven practical experience
Desirable
- Membership of a relevant Fed-IP recognised professional body
- Evidence of continued Personal Development
Knowledge
Essential
- oExperience and knowledge of using Microsoft BI Stack
- oGood knowledge of Business Intelligence dash boarding and reporting.
Desirable
- Experience using Microsoft SQL server Analysis Services to develop cubes to support reporting solutions
- Experience using version control
Experience
Essential
- oExperience working in a BI development role or equivalent
- oExperience developing and testing reporting solutions
- oExperience documenting data flows and processes
- oGood level of experience of data transmission software and techniques
Desirable
- oExperience of Meditech
- oExperience of supporting and providing training to end users
- oExperience of discussing and collating end user requirements
- oExperience of NHS data sets, broad understanding of NHS information procedures, legislation and policies.
Skills
Essential
- oAbility to design, develop and deploy BI solutions
- oExcellent problem solving skills for investigating data or processing anomalies
- oAbility to work under pressure and to meet deadlines
- oAbility to analyse and judge situations containing complex facts or situations and to examine a range of options related to them
- oAbility to work autonomously plan, and manage own workload.
- oAbility to present technical information in a meaningful manner to non-technical audience, as well as analyse, present and interpret data from a number of different sources
Desirable
- oMicrosoft SQL Server certification
- oExperience of Negotiating 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.
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).
Additional information
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).
