Data Warehouse Analyst
Job summary
Please note that while the advertised closing date for applications is 7th July, we reserve the right to close the vacancy earlier if we receive a high volume of suitable applications. If this happens while you are part-way through an application, you would not be able to submit it. We therefore encourage you to submit your application as soon as possible to avoid missing out.
Do you want a role where you can use the power of data to improve decision-making for the good of patients and staff?
Are you a specialist in data quality, SQL and producing dataset returns?
Read on - this could be your next role...
We're looking to appoint a Data Warehouse Analyst to join our growing Data Warehouse Team. Following investment into our Digital function, we are on a mission to transform complex healthcare data into trusted, accessible information that helps clinicians, managers and decision-makers improve services for our patients. This is an opportunity to work with large-scale datasets, modern data technologies and a highly collaborative and friendly team, delivering solutions that make a genuine difference across the organisation.
We offer a range of training and education opportunities as well as on-the-job training when learning new skills or systems.
Hybrid working: our staff work a mix of from our office at Wardsend Road North and from home. Occasional travel to clinical sites will be required. Everyone is also welcome to work in the office full time.
Main duties of the job
- Identify data quality issues through analysis of data sets and produce reports to address concerns.
- Liaise with colleagues concerning issues of data quality and effect on analysis.
- Submit national datasets to various data landing platforms and portals (e.g., MHSDS, CSDS, NHS Benchmarking) in advance of the deadlines.
- Build, maintain and validate a suite of system 'front-end' reports to facilitate operational management of services.
- Interpret reporting requirements from consumers of information and accurately produce reports to meet demand in the most efficient way and in alignment with supporting guidelines.
Please ensure your supporting statement includes demonstrable evidence and specific examples on how you meet the criteria for each of the key skills specified. This will be used in the shortlisting process.
About us
We are passionate about providing the very best care to the people we support, and we're looking for amazing people who share this passion to join us.
What is it that makes our Trust such a special place to work? Well, it's all about the people. Our staff, service users, carers and families all come from such diverse backgrounds and all have expertise and stories to share.
It's important that you feel supported in your role, that the people who you work with are as passionate as you are and that your health and wellbeing is taken care of
If you're interested in developing your career, you'll have access to a range of training and education opportunities, including apprenticeships, work experience and placements, as well as the chance to get involved in research.
We are very proud of the difference we make to people's lives each and every day and if that's something that you'd like to be part of we'd love to have you with us.
Job description
Job responsibilities
You can find further details about the role, including key responsibilities and accountabilities, alongside the organisational structure and person specification in the attached job description.
Person Specification
Knowledge and skills
- Knowledge of MS SQL Server database technologies - SQL Server 2012 and above
- Strong analytical skills and ability to understand complex data relationships
- Able to demonstrate excellent written, documentation and oral communication skills and abilities
- Working knowledge of NHS data and information flows
- Knowledge of clinical systems and database structures
- Experience working with mental health NHS mandatory datasets (e.g. MHSDS)
- Experience using source control tools (Azure DevOps, GitHub)
Training and qualifications
- Degree in computer related subject or equivalent professional qualification or experience
- Certificate in database administration / data modelling
Experience
- Appropriate demonstrable experience in relational database management systems (RDBMS)
- Substantial experience in an analysis role
- Knowledge of NHS data standards and definitions
- Experience of data migration and data quality reporting
- DW design methodologies
- Experience of submitting timely, statutory and mandatory returns
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.
Certificate of Sponsorship
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.
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.
Employer details
Employer name
Sheffield Health Partnership University NHS Foundation Trust
Address
Wardsend Road North
45 Wardsend Road North
Sheffield
S6 1LX
United Kingdom
Employer's website
https://www.sheffieldpartnership.nhs.uk/