Job summary
We are looking for an enthusiastic candidate to join the innovative Data Analytics team at Somerset Foundation Trust. The successful candidate will aid in the provision of routine reporting, business intelligence dashboards, and the creation of actionable insights to help improve patient care for the population of Somerset.
It's an exciting time to join the team as we are investing in the Trust's brand new data infrastructure, embracing open source tools such as Python, R, and Git, and enhancing the training and professionalisation offerings for our analysts.
This role offers a hybrid model of work with a minimum of 1 day per week in the Taunton or Yeovil office.
Main duties of the job
The post holder will be required to:
- Provide operational support for a wide range of reports and dashboards to support the business needs of the Trust.
- Submit routine statutory, contractual and routine reports to deadlines, and works with the reporting leads to ensure the accuracy of the reports.
- Produce reports using a variety of analytics tools, including managing and maintaining pre-built SQL scripts.
- Respond to requests in a timely manner and present reports in a way that is relevant and meaningful to their end audience.
- Proactively continues the development of own technical skills in order to support the team and information needs of the Trust.
About us
Why chose us?
Kindness, Respect, Teamwork
Everyone, Every day
Somerset NHS Foundation Trust runs acute hospital services, community services, mental health and learning disability services and a quarter of Somerset's GP practices. It runs services from two acute hospitals - Musgrove Park Hospital in Taunton, Yeovil Hospital in Yeovil - services in the community and services from the 13 community hospitals in the county, a range of mental health and learning disability services and Symphony Healthcare Services runs a quarter of GP practices in the county.
Within our trust we are privileged to work with over 12,500 colleagues who deliver or support our patient services. From therapists to nurses, doctors, researchers, scientists, porters, cleaners, kitchen staff, accountants, those who teach, and the receptionists who welcome our patients, the contribution of all of our colleagues is invaluable.
And its these colleagues who care and support a population of 561,000 across Somerset. We believe that the broad range of services that we offer within one organisation put us in a better position to provide mental and physical health services for our population, helping people to enjoy healthier lives with improved equitable access to the specialist care and treatment they need, when they need it.
Job description
Job responsibilities
Please see the attached supporting document for a detailed Job Description and Person Specification for this vacancy.
Job description
Job responsibilities
Please see the attached supporting document for a detailed Job Description and Person Specification for this vacancy.
Person Specification
Qualification & Training
Essential
- A levels or equivalent level of competence
Desirable
- Numerate qualification or equivalent experience
- Evidence of further study in IT/Information systems/Analytics related areas
Experience & Knowledge
Essential
- Excellent Analytical Skills
- Proficient user of Microsoft Office Excel and Access products
- Careful attention to detail
- Good organisational Skills
Desirable
- Good presentation skills
- Ability to understand and interpret basic SQL scripts within either an MS Access or SQL Server environment
Analytical & Judgement Skills
Essential
- Experience of using initiative and enthusiasm to problem solve/develop the service with minimum disruption to the office
- Ability to work on own or as a member of a team
- Experience of managing a busy workload with conflicting priorities
- Ability to reconcile data accurately and maintain appropriate documentation
Desirable
- Understanding of NHS data definitions, standards and information requirements across the NHS
Planning & Organising Skills
Essential
- Experience of managing a busy workload with conflicting priorities
Personal Qualities
Essential
- Attention to detail
- Easily and successfully adapts to changing circumstances
- Provides a consistent high level of quality work and constantly seeks to improve own performance, giving their best at all times
- Proactive work ethic
Desirable
- Demonstrates imagination and innovation using different perspectives to challenge and improve processes
Person Specification
Qualification & Training
Essential
- A levels or equivalent level of competence
Desirable
- Numerate qualification or equivalent experience
- Evidence of further study in IT/Information systems/Analytics related areas
Experience & Knowledge
Essential
- Excellent Analytical Skills
- Proficient user of Microsoft Office Excel and Access products
- Careful attention to detail
- Good organisational Skills
Desirable
- Good presentation skills
- Ability to understand and interpret basic SQL scripts within either an MS Access or SQL Server environment
Analytical & Judgement Skills
Essential
- Experience of using initiative and enthusiasm to problem solve/develop the service with minimum disruption to the office
- Ability to work on own or as a member of a team
- Experience of managing a busy workload with conflicting priorities
- Ability to reconcile data accurately and maintain appropriate documentation
Desirable
- Understanding of NHS data definitions, standards and information requirements across the NHS
Planning & Organising Skills
Essential
- Experience of managing a busy workload with conflicting priorities
Personal Qualities
Essential
- Attention to detail
- Easily and successfully adapts to changing circumstances
- Provides a consistent high level of quality work and constantly seeks to improve own performance, giving their best at all times
- Proactive work ethic
Desirable
- Demonstrates imagination and innovation using different perspectives to challenge and improve processes
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).
