Job summary
**The banding of this role is subject to confirmation of Agenda for Change job evaluation**
The role of Data Warehouse Developer is to support the delivery of the Digital Service Roadmap supporting the Trusts vision and strategic goals.
It is an exciting time to be joining The Shrewsbury and Telford Hospital NHS Trust (SaTH) to be a part of an exceptional Data Warehouse team. You will be working on a number of developments as part of the Digital Services Roadmap as well as business as usual tasks.
You will need to have strong SQL (SSIS, and T-SQL query building) skills, logical reasoning skills, analytics development skills, and be experienced in optimising data models and queries. You will be required to gather requirements from our customers and design and develop robust and efficient data products for reporting and analytical uses.
We are looking for someone with experience of NHS datasets and someone that works well as part of a team. We work within a framework which we have developed to ensure we produce quality output that is fit for purpose. You will need to work effectively under pressure whilst maintaining quality as we have numerous ah-hoc requests, project work and BAU.
NHS experience and knowledge and experience of SQL are essential.
At present we mainly work remotely with a day or two in the office but this is subject to change.
Main duties of the job
- Responsibility for the development, implementation and support of automated ETL routines for the extraction and processing of complex data from source database systems and text based data extracts where appropriate. Adapt existing processes to meet new requirements.
- Data modelling and data solution designs.
- Collaborate on architecture and design across the team on larger projects.
- Deliver code changes and releases to production via development and NPE environments.
- Develop and maintain processes to generate mandated datasets for national and local submission following national guidance or policy.
- Work with senior managers and other key users to specify and design new data flows and outputs.
- Identify opportunities for improvements to routine data processes and implement enhancements to deliver efficiencies. Recommend solutions based on own research.
- Investigate and diagnose technical problems followed by the development and implementation of suitable solutions.
- Assist with migrating databases to the cloud.
- Staff management
- Plan and prioritise own workload.
About us
As a member of the Digital Service's Directorate, this role will be critical to improving the organisations understanding of opportunities and risks and in improving the quality of decision-making.
The role will support the delivery of the Trusts vison and strategic goals though the identification of key insights that drive improvements to the effectiveness and efficiency of the services provided. The team will provide the data for central reporting systems to ease the day to day job of staff at all levels. This in turn will help the Trust deliver its integrated care vision.
Job description
Job responsibilities
For full duties and responsibilities please refer to the attached document entitled Job Description.
Job description
Job responsibilities
For full duties and responsibilities please refer to the attached document entitled Job Description.
Person Specification
Qualifications
Essential
- Educated to degree level in relevant subject or equivalent level of experience of working at a similar level in specialist area
- Educated to GCSE, A-Level in Mathematics and English, NVQ or equivalent qualification.
Desirable
- Microsoft SQL stack qualification
Experience and Knowledge
Essential
- Significant experience of NHS data sets
- Ability to develop code and solutions in a data warehouse environment using advanced Microsoft SQL skills
- Experience of agile working and scrum
- Experience in use of IT packages, especially daily use of Microsoft Office suite especially Excel, Word, Access, Teams and SharePoint.
- Attention to detail whilst working at pace
- Demonstrable experience in liaising and negotiating effectively with internal and external stakeholders at all levels of seniority
- Experience of working flexibly to meet the needs of the service
- Experience in supporting the management of programmes, projects and change - including producing and maintaining relevant high quality project management documentation
- Experience in using Visual Studio and SQL Server Management to create and manage SQL objects eg views and stored procedures
- Experience with Team Foundation Server or DevOps to manage tasks and management of source code
- Experience of creating and maintaining SQL Server Integration Services packages
- Knowledge and experience of the software development lifecycle
- Knowledge of the change control process
- Experience of using the Kimball data warehouse approach
Desirable
- Knowledge of Microsoft Azure
- Knowledge of or experience with Microsoft PowerQuery and Power BI
- Knowledge and experience of SQL Server Data Tools (SSDT)
Person Specification
Qualifications
Essential
- Educated to degree level in relevant subject or equivalent level of experience of working at a similar level in specialist area
- Educated to GCSE, A-Level in Mathematics and English, NVQ or equivalent qualification.
Desirable
- Microsoft SQL stack qualification
Experience and Knowledge
Essential
- Significant experience of NHS data sets
- Ability to develop code and solutions in a data warehouse environment using advanced Microsoft SQL skills
- Experience of agile working and scrum
- Experience in use of IT packages, especially daily use of Microsoft Office suite especially Excel, Word, Access, Teams and SharePoint.
- Attention to detail whilst working at pace
- Demonstrable experience in liaising and negotiating effectively with internal and external stakeholders at all levels of seniority
- Experience of working flexibly to meet the needs of the service
- Experience in supporting the management of programmes, projects and change - including producing and maintaining relevant high quality project management documentation
- Experience in using Visual Studio and SQL Server Management to create and manage SQL objects eg views and stored procedures
- Experience with Team Foundation Server or DevOps to manage tasks and management of source code
- Experience of creating and maintaining SQL Server Integration Services packages
- Knowledge and experience of the software development lifecycle
- Knowledge of the change control process
- Experience of using the Kimball data warehouse approach
Desirable
- Knowledge of Microsoft Azure
- Knowledge of or experience with Microsoft PowerQuery and Power BI
- Knowledge and experience of SQL Server Data Tools (SSDT)
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
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).
Employer details
Employer name
The Shrewsbury and Telford Hospital NHS Trust
Address
The Shrewsbury Business Park
1 Douglas Court, Anchorage Avenue
Shrewsbury
SY2 6LG
Employer's website
http://www.sath.nhs.uk/ (Opens in a new tab)
