Data and Insight Analyst

Job description

Job responsibilities

Job Title: Data and Insight Analyst

Team: Strategy and Partnerships

Salary range/pay band: £33,000-£36,000

Reports to: Head of Data

Direct reports: None

Hours: 37.5 hour per week

Location: Christophers/Shooting Star House to be agreed

Introduction to Shooting Star Childrens Hospices

Shooting Star Childrens Hospices provides specialist care and support to families who have a baby, child or young person with a life-limiting condition, or who have been bereaved. Rated Outstanding by the Care Quality Commission, we support families across Surrey, north-west London and south-west London from diagnosis to end of life and throughout bereavement with a range of nursing, practical, emotional and medical care.

Our specialist care and support is free of charge to families and available 24 hours a day, 365 days a year. It includes specialist nursing in the community, symptom management and pain relief, overnight respite stays, end-of-life care, specialist bereavement care and a comprehensive range of therapies, groups and clinics for the whole family.

At the heart of what we do are our dedicated staff; their exceptional commitment and professionalism means every family has the opportunity to make every moment count.

It costs £10 million a year to run Shooting Star Childrens Hospices. Just 30% of our funding comes from the government, so we rely on our supporters generosity to keep the service running. We employ 175 members of staff, including 98 nursing and medical staff, and support around 700 families. Introduction to Team Strategy and Partnerships Shooting Star Childrens Hospices Teams Strategy and Partnerships Team: This Team is responsible for the delivery and monitoring of the organisational strategy; the Data and Insight function across the whole organisation; partnerships with external organisations in the voluntary and statutory sector; raising £3million + of statutory income and providing the administration and systems support to the Care team.

Part 1: Job Profile

a)Main purpose of job

To support Shooting Star Childrens Hospices in turning data into information, information into insight and insight into business decisions.

Duties and key responsibilities

• Interpret data, analyse results using statistical techniques and provide reports to the organisation
• Assist in the development and Implementation of data analysis using data collection systems and other strategies to optimise the data as efficiently as possible
• Acquiring data from primary and secondary sources and maintain the necessary databases
• Monitor the Organisational performance by producing KPIs and reporting at least quarterly Produce benchmarking with other children hospices by building external relationships and using external sources of information Produce any regulatory reports in collaboration with the business
• Produce board packs for senior leadership and trustees in collaboration with the business

Essential and desirable skills and experience

• Proven experience as a data analyst Knowledge and experience with reporting packages (Business objects, tableau, power BI), databases (SQL etc), programming (XML, Javascript)
• Knowledge of statistics and experience in using statistical packages for analysing datasets (Excel, SPSS,SAS etc)
• Strong analytical skills with the ability to collect, organise, analyse and disseminate information with high attention to detail
• Adept with queries, report writing and presenting findings

Part 2: Main duties and key responsibilities

a)Use headings from the scope Producing monthly/quarterly KPIs for all departments Monitoring and ensuring controls in place for data capture Producing dashboards for individual departments Producing reports which use external sources to highlight trends and display how we are performing compared to other hospices Produce reports to support bids and tenders for trusts and funders Produce any reports for external companies which are required for compliance purposes Produce quarterly board reports in partnership with the relevant departments Maintaining any databases or warehouses used to store data from several different sources ensuring it is up to date and accurate

b)Other duties

These duties will be applicable to some posts. (Please delete/amend those which are not relevant for this role.)

• The post holder must be able and willing to get to and work in both hospices. The post holder will need to travel extensively throughout their area and less frequently in other parts of Surrey/West London
• The post holder should be prepared to attend SSCH meetings in different parts of the country. Some meetings may be during evenings or weekends.
• The post holder will be required to apply for a Disclosure and Barring Service check
• The post holder must live within the area of work/within xx distance of a key venue

c)Mandatory Criteria

1. Other duties

The post holder will be working in a developing environment and they will therefore be expected to undertake other appropriate duties as required for the effective operation of Shooting Star Childrens Hospices.

2.Professional Codes of Conduct

The post holder will be required to respect professional codes of conduct and practice relevant to their role, as appropriate.

3.Health and Safety

Be responsible for health and safety in the area under their control and ensure that they are familiar with Shooting Star Childrens Hospices policy on health and safety at work.

4.Mandatory Training

The post holder will attend all mandatory training relevant to their role

5.Our values and behaviours

Shooting Star Childrens Hospices is a leading childrens hospice charity for babies, children and young people with life limiting conditions, and their families. We require that all of our staff share our common values and display behaviors that will enable us to achieve our goals.

Professionalism we will safeguard our families, each other and our organisation by working to ethical and professional standards at all times.

Respect We will treat each other with the utmost respect.

Integrity We will be open, honest and transparent in all that we do.

Diversity We will respect individuality and ensure inclusion and fairness to all.

Excellence We will strive for excellence in all that we do.

Shooting Star Childrens Hospices is committed to ensuring the welfare and safety of children and young people. All staff members are expected to adhere to our safeguarding policies and procedures. This includes undergoing appropriate training, following reporting protocols for any concerns related to child welfare, and promoting a safe and supportive environment for children and young people. Before commencing employment, successful candidates will be required to provide satisfactory references and undergo an enhanced Disclosure and Barring Service (DBS) check.

Part 3: Person specification: Qualifications, experience and skill levels

a)Qualifications

Have a recognised qualification in coding and report writing, or be working towards this- E

Degree- D

b)Experience

Proven experience as a data analyst- E

Has experience in writing reports direct from a database -E

Working knowledge of a business intelligence platform such as Tableau E Implementation of a data warehouse or business intelligence platform- D

c)Knowledge and Skills

Excellent IT skills including O365 and excel-E

Excellent communication skills with the ability to communicate, both verbally and in writing-E

d)General attributes

Ability to work effectively as part of a team & on your own initiative-E

Excellent attention to detail-E

Understand confidentiality-E

Flexibility to cover for sickness and holidays- E

What we offer

Pension scheme

• NHS Pension Scheme (eligible employees)
• Stakeholder pension scheme
• Employee contribution 3.5%
• Shooting Star Childrens Hospices contribution 4.5%
• Additional contributions we will pay 1% above the contribution up to a limit of 7%

Annual leave

• 35 days including Bank Holidays rising with length of service
• 2 weeks paid sabbatical leave after 5, 10 and 15 years service

Contractual benefits

• Generous sick pay scheme
• Enhanced maternity, adoption, and paternity leave pay
• Flexible working arrangements
• Death in service benefits
• Reimbursed professional membership fees
• Eye care Employee referral scheme
• Blue Light discount card

Health and wellbeing

• EmployeeAssistance Programme
• Occupational Health
• Cycle to work scheme
• Mental Health First Aiders
• Nutritionally balanced meals at Christophers (free employees)

Equality, diversity and inclusion Shooting Star Childrens Hospice is committed to inclusion and diversity in everything we do. We know that getting things right is critical for us to live our organisations values: Professionalism, Respect, Integrity, Diversity and Excellence. We are always trying to improve our way of working to be more inclusive and equal. Our vision is for Shooting Star Childrens Hospice to be a place where people of all backgrounds, groups and communities feel welcomed to work and volunteer.

Person Specification

Qualifications

• Have a recognised qualification in coding and report writing, or be working towards this

• Degree

General attributes

• Ability to work effectively as part of a team & on your own initiative E
• Excellent attention to detail E
• Understand confidentiality E
• Flexibility to cover for sickness and holidays E

Experience

• Proven experience as a data analyst E
• Has experience in writing reports direct from a database E
• Working knowledge of a business intelligence platform such as Tableau E

• Implementation of a datawarehouse or business intelligence platform D

Knowledge and Skills

• Excellent IT skills including O365 and excel E
• Excellent communication skills with the ability to communicate, both verbally and in writing E

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

Shooting Star Children’s Hospices

Address

Shooting Star Childrens Hospice

The Avenue

Hampton

Middlesex

TW12 3RA

https://www.shootingstar.org.uk/

---