Business Intelligence Coordinator
Job summary
This role matters:
A unique opportunity has arisen for a Business Intelligence Coordinator to join our team and help transform data into clear, useful insights. If you enjoy working with systems, data and people, and you are passionate about using information to drive positive change, get in touch!
At St Johns Hospice, every decision we make helps us provide care and support to local people and their loved ones when they need us most. Working across both clinical and non-clinical services, you will play a key role in developing reports, dashboards and business intelligence solutions to support decision-making throughout the Hospice.
As part of our dedicated on-site IT team, you will work collaboratively with colleagues across St Johns to champion effective data management and promote the use of high-quality, reliable information. Your work will help the Hospice strengthen processes, support service development and meet its regulatory and commissioning requirements. Meaningful information plays a vital role in this by helping us demonstrate our impact, plan for the future with confidence and continually improve the services we offer to our community.
If you are looking for a role where you can use your analytical and organisational skills, your keen eye for detail and your ability to build positive working relationships across a wide range of teams, this could be the perfect opportunity for you.
Informal enquiries are welcome.
Main duties of the job
JOB PURPOSE
The Business Intelligence Coordinator is responsible for the development of all business information for St Johns Hospice, both clinical and non-clinical, through the implementation and promotion of systems and processes, including Power BI, to ensure data is effectively utilised to support business objectives. The Business Intelligence Coordinator works collaboratively with cross-functional teams across the Hospice, to champion effective data management that delivers consistent, insightful reporting.
This role is critical in enabling the Hospice to demonstrate impact, meet commissioning requirements, and to maintain high standards of care through the presentation of high-quality data.
KEY WORKING RELATIONSHIPS
- Senior Management Team
- IT Manager
- IT Assistant
- Heads of Departments
- All staff and volunteers of the Hospice and its subsidiaries
About us
St John's Hospice is a well-respected local charity providing free specialist palliative care.
Our services include an inpatient ward for end-of-life care as well as pain and symptom management, a Hospice at Home service for people who choose to spend their last time at home and need our support, Clinical Nurse Specialists who support people with planning and pain & Symptom management, and a Respite Service for carers of loved ones who need respite time during the day or night. St John's also offers pre and post bereavement support plus other services you may not associate with a Hospice such as Social Workers and Therapists.
St John's Hospice is a charity. All of our care, compassion and support is offered free of charge to patients and their families or carers. Our care however is not cost free, around a quarter of our funding is from the government and the remaining three-quarters is raised our amazing local community.
We put local patients and families at the heart of everything we do to ensure that on the journey towards the end of life and through bereavement, we provide the right care, in the right place, at the right time. This role will play in a key role in supporting our work.
St John's Hospice is rated as CQC Good.
Job description
Job responsibilities
Accountable To: Director of Finance and Resources
Reports To: IT Manager
Hours: 30 per week
MAIN DUTIES
Data Capture
- Using good interpersonal skills, communicate and negotiate with hospice colleagues and stakeholders to ensure a clear understanding of data requirements and the rationale behind these.
- Work closely with colleagues across the Hospice to promote the use of data from the correct sources to ensure that the Hospices work with patients, supporters and stakeholders is consistent and fully reflected in the information that is published.
- Develop systems and processes with guidance from internal and external experts.
- Understand the Hospices reporting requirements and propose configuration solutions that meet these.
- Proactively work with Heads of Service and Senior Management Team to ensure that information provision is tailored to their priorities and supports their decision-making requirements.
- Process and validate data to ensure it is consistently accurate for the organisation to effectively utilise.
- Support service development and income generation by ensuring data capture and flows are built into service specifications to enable effective analysis and reporting of activity.
Data Quality
- Comply with all information governance requirements, including the General Data Protection Regulations.
- Contribute to the development and implementation of data management policies and procedures to ensure compliance with regulatory requirements.
- Collaborate with other team members to ensure data consistency and quality across different systems.
- Review and validate data sets to ensure accuracy and completeness.
- Investigate data anomalies and instigate corrective actions as required.
- Undertake audits for data accuracy as required by the role.
Data Reporting
- Ensure appropriate training of staff to use systems which will assist in the extraction of data.
- Support data provision for the Hospice, providing accurate and meaningful routine, scheduled and ad hoc reports to communicate data insights to a broad spectrum of stakeholders.
- Provide organisational data in a number of formats including dashboards, graphs, charts and reports.
- Provide analysis and interpretation to support the evaluation of organisational activities.
- Understand external reporting requirements, e.g. NHS, CQC, Charity Commission, Fundraising Regulator, and provide data and information to meet these requirements.
- Keep informed of best practice, technological developments, and changes in Hospice practices, in order to develop and implement data-driven solutions.
- Maintain good communications with external support providers and the Hospice User Group forums.
OTHER
- Proactively contribute to the objectives of the IT team.
- Attend team meetings.
- Undertake continuous professional development related to the role
- Perform other duties commensurate with the role as assigned by the IT Manager or Director of Finance & Resources.
The responsibilities set out in this document may change from time to time through discussion with the post holder. In addition, the post holder might, at the discretion of the Senior Management Team, be required to take on other tasks in the wider interests of the Hospice.
STANDARD/ENHANCED DISCLOSURE REQUIREMENT
Standard DBS disclosure
DUTIES AND RESPONSIBILITIES TO ST. JOHNS HOSPICE
Please refer to the uploaded Job description for full details of the points below
1. Confidentiality
2. Health and Safety
3. External Interests
4. Statutory Training
5. Flexibility
6. Safeguarding
7. Disclosure and Barring
8. Equality and Inclusion
9. Volunteers
Person Specification
Experience
- Proven experience in data management, data analysis, business intelligence or a similar role.
- Demonstrable experience of collaborating effectively with cross functional teams.
- Experience of working within the charity sector and/or healthcare.
Knowledge and Skills
- Strong understanding of data management technologies and best practices.
- Proficiency in database management, with the ability to extract, manipulate, and query data.
- Strong Excel skills, including the effective use of formulas, pivot tables, and filtering to analyse and interpret data.
- Ability to communicate complex data insights to stakeholders in a clear and concise manner.
- Familiarity with data privacy regulations and best practices.
- Excellent problem-solving and analytical skills.
- Excellent organisational skills, with the ability to prioritise workload effectively to meet deadlines.
- Familiarity with data visualization tools, such as Power BI, to create visually appealing and informative reports.
Values and personal attributes
- Ability to work independently and as part of a team.
- Resilient and able to effectively work under pressure.
- Strong commitment to the vision and values of St Johns Hospice.
- Commitment to continuous professional development.
Qualifications
- Good general education which should include GCSE Grades A to C (or equivalent) in English and Maths.
- Bachelors degree in a related field, such as computer science, mathematics, or statistics.
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.
Employer details
Employer name
St John's Hospice
Address
Slyne Road
Lancaster
LA2 6ST
United Kingdom
Employer's website
https://www.sjhospice.org.uk/