JOB DESCRIPTION

Job Title:Data Analyst

Department:IT

Reports to:Technology Business Partner

Location: Brentry, BS10

Direct Reports:N/A

Hours of Work:37.5 hrs per week (Mon – Fri)

Salary:£30,000 - £33,000

Background:

St Peter’s is a hospice charity that offers a range of high quality services to adults with life limiting illnesses and their families and carers. Income to support the charity is generated through a wide range of sources including fundraising and shops. It employs over 450 staff that work across over 50 sites and in the community.

There is a systems analyst that is responsible for the electronic patient record database (EMIS) and its related processes. There is currently no formal company wide data management/business intelligence strategy. We are looking for an experienced data analyst to work with the hospice to enhance our business intelligence capabilities. Timely access to trusted actionable data will support decision making across the business. This will involve increasing self-service reporting, automating processes and exploring the benefits that could be derived from data mining or predictive analysis.

We currently use a number of different databases across many functions; patients, fundraising, volunteering, retail, HR and finance. We would like to explore the benefit of integrated reporting mechanisms such as SSRS, SSIS and Power BI. In addition we would like to look at the possibilityof real time interrogation of reports and underlying systems.

Main Job Purpose:

Improve business intelligence capabilities and underlying processes

Make available timely accurate trusted and actionable data

Key Stakeholders:

Director of Finance and IT

Executive

Trustee responsible for information technology

Outsourcing company

Information asset owners and Caldicott Guardian

Systems analyst

Business Technology Partner

Heads of department

Data administrators

Database providers; patient care system, retail, finance, HR, fundraising

Organisations with whom St Peter’s shares data

Principal Responsibilities:

  • Reporting Platform
  • Design and implement a reporting platform utilising Microsoft SSRS / PowerBI or similar.
  • Create report specification templates for use in conversation with business functions.
  • Create and maintain documentation for reporting platform
  • Report Creation
  • Work with business functions and system administrators to understand data systems and reporting requirements.
  • Work with business functions to understand compliance reporting requirements (e.g. NHS, CQC)
  • Create report specifications which reflect requirements gathered.
  • Create reports to specification using a suitable reporting platform e.g. SSRS / PowerBI
  • Ensure reports are documented and signed off by business functions prior to finalisation
  • Work with business functions to define change requirements to existing reports, suggesting improvements where appropriate.
  • Highlight and suggest changes to reports or data sets where knowledge of data from multiple systems highlights opportunities.
  • Increase usage of self-service reporting, assisting users, creating guidance and providing data sets.
  • Ensure timely and accurate data is available to support decision making (e.g. retail, fundraising, clinical, support)
  • Ensure reports are available in a suitable format – e.g. ensuring Excel exportable versions available.
  • Work with information asset owners and key representatives from business functions to establish metrics / KPI’s and how changes to thresholds should be reviewed.
  • ReportingProcesses & Design
  • Automate reporting activities as much as possible, reducing opportunity for error.
  • Document processes so that others can pick up and perform if required.
  • Avoid duplication of data wherever possible.
  • Troubleshoot issues with dataset population – e.g. SSIS troubleshooting
  • Data Processing
  • Perform de-duplication and mastering as part of report data gathering and processing.
  • Working with Information Asset Owners, understand data flows and key activities. Advise on improvements to processes and additional data inputs / outputs.
  • Advise on changes to working practices to support better reporting – e.g. collection / organisation of data.
  • Data collection; type and method. Working with staff to ensure they understand the importance of data collection and that they understand their role in it.
  • Data storage
  • Design and maintain a data warehouse for reporting data
  • Apply data security principals to data warehouse and reporting platform
  • Work with IT Project Engineer to implement security via groups and user properties.
  • Create a data dictionary
  • Excel
  • Identify usage of Excel as part of business processes
  • Where appropriate consider the use of a data sets or databases to streamline business processes
Supplementary Information:

Equality Statement

St Peter’s Hospice expects all staff and volunteers to act in a way that is consistent with organisational procedures and the law relating to equality, diversity and rights and to treat everyone with whom they come into contact equitably, with respect and without discriminating.

They should recognise and appreciate that people, both colleagues and service users, are different and act in ways that are consistent with their needs and preferences. They should ensure that the practices and processes operated in their areas of work are fair and provide equitable treatment for all and they should take effective action to deal with any discrimination or unfair treatment of which they become aware.

Health & Safety

Under the provisions of the Health & Safety at Work Act 1974, it is the duty of every employee

i)To take reasonable care of themselves and others at work.

ii)To co-operate with the hospice as far as is necessary to enable them to carry out their legal duty.

iii)Not to intentionally or recklessly interfere with anything provided including personal protective equipment for health and safety or welfare at work.

Rehabilitation of Offenders

The hospice promotes equality of opportunity for all individuals with the right mix of talent, skills and potential and welcomes applications from a wide range of candidates, including those with criminal records.

We undertake not to discriminate unfairly against anyone who has previous criminal convictions and having a criminal record will not necessarily be a bar to employment with the hospice.

Scope of Job Description

This job description reflects the immediate requirements and objectives of the post. It is not an exhaustive list of the duties but gives a general indication of work undertaken which may vary in detail in the light of changing demands and priorities. Substantive changes will be carried out in consultation with the post holder.

Created: April 2018

PERSON SPECIFICATION DETAILS

Data Analyst

Essential / Desirable
Education/Qualifications
A bachelor’s degree in business or related field or an MBA / X
Industry recognised IT qualification (MCP, MCSA etc.) / X
SQL Database Services Qualification / X
Experience
Charity / not for profit experience / X
Design of data sets and databases / X
Determining reporting requirements with business functions / X
Designing SSIS packages to import and manipulate data / X
Designing and developing SSRS reports / X
Extensive experience of Excel for data analysis and manipulation / X
Skills, Knowledge, Abilities
Excellent analytical and problem solving skills with an informed, evidence-based approach; / X
Proven experience in eliciting requirements and testing / X
Excellent communication skills, with the ability to talk to and present to a range of audiences, sometimes acting as a translator between parties / X
Strong written and verbal communication skills including technical writing skills / X
The ability to influence stakeholders and work closely with them to determine acceptable solutions. / X
the ability to work under pressure on multiple projects within agreed project timeframes / X
Excellent planning, organisational, and time management skills. / X
High level of accuracy / X
A passion for creating solutions with a positive attitude to change; / X
Personal Attributes
Excellent interpersonal skills and ability to communicate successfully with people of all levels / X
Motivated to really understand the organisation, its services and drivers of performance / X
Approachable and keen to develop positive working relationships across the organisation / X
Takes pride in their work and motivated to produce high quality, well presented and accurate analysis / X
Self-starter, able to identify areas which would benefit from analysis / X
Capable of working independently and making decisions on day-to-day team matters but recognising when it is appropriate to request support from line manager / X
Excellent team working skills / X
Flexible, willing to carry out any task needed to support the team / X
Resilient with ability to work under pressure and adapt to change / X
A desire to learn and a commitment to personal development / X

1