Job summary
Clatterbridge Cancer Centre Award winning "Non-Clinical Team of the Year", is on the hunt for a BI Assistant 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 Assistant Business Intelligence Developer will support the Senior Business Intelligence Developer in the development of reports and dashboards and help in supporting the management of the Trusts data warehouse and reporting platforms. 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 analyst's 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 Assistant 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.
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
Communication
- The post involves regular communication with staff from departments across the organisation and the wider business intelligence team.
- Frequent contact with other members of the Business Intelligence team to discuss complex issues relating to the Business Intelligence Portal. Working with Senior Business Intelligence Developers to take forward the Business Intelligence development programme and participate in problem resolutions.
- Attend various meetings where directed
- Attend relevant local workshops and training days in support of the personal and development
Analytical and Judgement Skills
- Manipulate, analyse and present clinical and activity data using a variety of systems and applications g. Microsoft Excel, SQL Management Studio and Power BI.
- Utilise data visualisation tools to ensure information is displayed in a consistent departmental format.
- To develop and maintain standardised reports from Data Warehouse with help from the Senior Business Intelligence Developer if required.
- To develop dashboards, automate reporting and develop exception reporting to support and address data quality issues or where measures are close to being breached.
- Support Senior Business Intelligence Developers with the management of the Business Intelligence platforms, including granting user access to reports and dashboards where required
- Utilise the latest technologies to move from providing information to providing intelligence and insight.
Planning and Organisational Skills
- Support the automation and scheduling of reports, processes and loads within the Business Intelligence Team.
- Utilise best practices in the management and granting of user access to all reporting platforms.
- To assist with the improvement and streamlining of existing processes and data feeds from Trust systems, to promote greater efficiency and effectiveness.
- Strong organisational and time management skills are required. Ability to meet tight deadlines and multi-task in an often changing and challenging environment
Responsibility for Policy and Service Development
- Contribute to continual service development in the Business Intelligence Team through liaison with the Senior Business Intelligence Developer.
- Identify opportunities for improvements in clinical/non-clinical systems to improve data quality and efficient ways of working with data.
Responsibility for Information Resources
- Under guidance by the Senior Business Intelligence Developer, promote the use of the business intelligence portal by closely working with directorates and key users to understand and clearly specify requirements and changes.
Job description
Job responsibilities
Communication
- The post involves regular communication with staff from departments across the organisation and the wider business intelligence team.
- Frequent contact with other members of the Business Intelligence team to discuss complex issues relating to the Business Intelligence Portal. Working with Senior Business Intelligence Developers to take forward the Business Intelligence development programme and participate in problem resolutions.
- Attend various meetings where directed
- Attend relevant local workshops and training days in support of the personal and development
Analytical and Judgement Skills
- Manipulate, analyse and present clinical and activity data using a variety of systems and applications g. Microsoft Excel, SQL Management Studio and Power BI.
- Utilise data visualisation tools to ensure information is displayed in a consistent departmental format.
- To develop and maintain standardised reports from Data Warehouse with help from the Senior Business Intelligence Developer if required.
- To develop dashboards, automate reporting and develop exception reporting to support and address data quality issues or where measures are close to being breached.
- Support Senior Business Intelligence Developers with the management of the Business Intelligence platforms, including granting user access to reports and dashboards where required
- Utilise the latest technologies to move from providing information to providing intelligence and insight.
Planning and Organisational Skills
- Support the automation and scheduling of reports, processes and loads within the Business Intelligence Team.
- Utilise best practices in the management and granting of user access to all reporting platforms.
- To assist with the improvement and streamlining of existing processes and data feeds from Trust systems, to promote greater efficiency and effectiveness.
- Strong organisational and time management skills are required. Ability to meet tight deadlines and multi-task in an often changing and challenging environment
Responsibility for Policy and Service Development
- Contribute to continual service development in the Business Intelligence Team through liaison with the Senior Business Intelligence Developer.
- Identify opportunities for improvements in clinical/non-clinical systems to improve data quality and efficient ways of working with data.
Responsibility for Information Resources
- Under guidance by the Senior Business Intelligence Developer, promote the use of the business intelligence portal by closely working with directorates and key users to understand and clearly specify requirements and changes.
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
- oKnowledge of Business Intelligence dash boarding and reporting.
Desirable
- 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
- oExperience in SQL Query writing
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.
- oExperience of data transmission software and techniques
Skills
Essential
- oAbility to design, develop and deploy BI solutions
- oGood problem solving skills for investigating data or processing anomalies
- oAbility to work under pressure and to meet deadlines
- oAbility to work autonomously plan, and manage own workload.
- oAbility to communicate effectively with all levels of staff across the Trust.
Desirable
- 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
- oKnowledge of Business Intelligence dash boarding and reporting.
Desirable
- 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
- oExperience in SQL Query writing
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.
- oExperience of data transmission software and techniques
Skills
Essential
- oAbility to design, develop and deploy BI solutions
- oGood problem solving skills for investigating data or processing anomalies
- oAbility to work under pressure and to meet deadlines
- oAbility to work autonomously plan, and manage own workload.
- oAbility to communicate effectively with all levels of staff across the Trust.
Desirable
- 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
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).
