Job summary
This is an exciting role within the Digital Services department. We are a small team but achieve great things. If you are passionate about data and working with cloud technology then read on...
Your role will be to:
Support the successful delivery of a Trust wide data warehouse for the Trusts business critical systems.
Support the Data Warehouse Manager on the development of a Trust wide reporting system including the use of dashboards.
Provide specialist advice relating to the interpretation of NHS data metrics and standards and take these into account when loading data into the data warehouse.
Provide technical expertise and in depth understanding of NHS information from a variety of systems.
Support the creation and maintenance process of nationally mandateddatasets and to ensure accurate and timely submission of all relevant statutory returns.
Main duties of the job
The Digital Services Systems Development Team provides a key function to the Trust in the areas of in-house systems development, web development (intranet and internet), data warehousing, enterprise level reporting (including dashboard development) and system support.
This important role will continue to develop and support the Trusts Data Warehouse and reporting / metric creation function. You will need a strong understanding of databases and Microsoft SQL Server development (T-SQL, Integration Services), Reporting Services (Report Builder) and PowerBI. Microsoft Azure exposure would be advantageous.
You will have a good understanding of NHS data, metrics and standards and will have experience of working with an enterprise level data warehouse. An understanding of NHS commissioning, datasets and performance targets would be advantageous.
This is an exciting opportunity to join a fast-growing area within the department.
For more information about the post, please email any questions to ben.scorer@cntw.nhs.uk
About us
We aim to attract and retain a diverse, talented and committed workforce, who are caring and compassionate, and therefore able to meet the demands of the modern NHS now and in the future. In return we can offer a dynamic working environment in which to build a career.
We recognise that the people who work for us are our greatest asset, and when you feel supported and happy at work this positively reaches those very people we are here for - our service users.
https://www.cntw.nhs.uk/careers/working-with-us/
Job description
Job responsibilities
- Advanced Knowledge of Relational Databases
- In depth Knowledge in the field of NHS Information
- In depth Knowledge of NHS Information requirements, datasets and submission processes
- Knowledge of managing large relational database schemas
- In depth knowledge of ETL/ELT processes.
- In depth knowledge of building functional dashboards.
- Advanced MS SQL Server database skills including SQL Server Management Studio, T-SQL, SSIS packages, stored procedures, functions, indexing and query tuning.
- Experience of maintaining accurate documentation regarding the data structures, metrics, routines and files used by the Data Warehouse Team.
- Experience of designing and developing specialised custom-built reporting systems using MS SQL Reporting Services (Report Builder) and / or Power BI.
- Experience of assessing the impact of forthcoming changes to NHS information requirements so that changes / improvements to the Trusts Data warehouse are developed and tested in good timeExperience of using BI tools and OLAP Reporting tools.
Please find attached job description for full details.
Advertising date : 29th August 2023
Closing date : 12th September 2023
We welcome your application.
Job description
Job responsibilities
- Advanced Knowledge of Relational Databases
- In depth Knowledge in the field of NHS Information
- In depth Knowledge of NHS Information requirements, datasets and submission processes
- Knowledge of managing large relational database schemas
- In depth knowledge of ETL/ELT processes.
- In depth knowledge of building functional dashboards.
- Advanced MS SQL Server database skills including SQL Server Management Studio, T-SQL, SSIS packages, stored procedures, functions, indexing and query tuning.
- Experience of maintaining accurate documentation regarding the data structures, metrics, routines and files used by the Data Warehouse Team.
- Experience of designing and developing specialised custom-built reporting systems using MS SQL Reporting Services (Report Builder) and / or Power BI.
- Experience of assessing the impact of forthcoming changes to NHS information requirements so that changes / improvements to the Trusts Data warehouse are developed and tested in good timeExperience of using BI tools and OLAP Reporting tools.
Please find attached job description for full details.
Advertising date : 29th August 2023
Closing date : 12th September 2023
We welcome your application.
Person Specification
Knowledge
Essential
- In depth knowledge of ETL processes
- Knowledge of managing/reading large relational database schemas
- In depth knowledge of relational databases
Desirable
- Knowledge creating and submitting nationally mandated datasets
- AZURE knowledge
Qualifications
Essential
- Educated to degree level or equivalent experience
Desirable
- Any relevant qualifications in the area of Data warehouse development / MS SQL
Experience
Essential
- Vast experience of developing dashboards
- Vast experience of designing and developing reports using MS SQL Reporting Services
- Vast experience of designing and developing reports using PowerBI
- At least 2 years' experience of working in a senior Information role
Desirable
- Experience of working with AZURE
Skills
Essential
- Strong T-SQL skills
- Strong SSIS skills
Desirable
- AZURE Data Factory
- AZURE Managed Instance
- AZURE SQL Databases
Person Specification
Knowledge
Essential
- In depth knowledge of ETL processes
- Knowledge of managing/reading large relational database schemas
- In depth knowledge of relational databases
Desirable
- Knowledge creating and submitting nationally mandated datasets
- AZURE knowledge
Qualifications
Essential
- Educated to degree level or equivalent experience
Desirable
- Any relevant qualifications in the area of Data warehouse development / MS SQL
Experience
Essential
- Vast experience of developing dashboards
- Vast experience of designing and developing reports using MS SQL Reporting Services
- Vast experience of designing and developing reports using PowerBI
- At least 2 years' experience of working in a senior Information role
Desirable
- Experience of working with AZURE
Skills
Essential
- Strong T-SQL skills
- Strong SSIS skills
Desirable
- AZURE Data Factory
- AZURE Managed Instance
- AZURE SQL Databases
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).
