Job summary
Please note to apply for this role you must have the right to work in the UK. CNTW NHS Foundation Trust will not provide sponsorship for this role.
This role is currently work from home with one day per month in the Gosforth office. They may increase in the future and your work base will be Gosforth.
You may be required to attend meetings on-site at one of our locations in the North East and North Cumbria where a Teams meeting is not possible.
Previous applicants need not apply.
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, working with cloud technology and leading a very talented and capable team then read on...
You will be:
Managing and leading the Data Warehouse team in providing a robust Data Warehouse solution (using Kimball/Inmon data warehousing methodology) to support decision making, data management and business intelligence. Ongoing development and enhancement of the data warehouse including database maintenance.
Ensuring nationally mandated datasets are submitted on time and meet nationally defined criteria to support commissioning requirements.
Contributing to the Trusts strategic ambition to migrate the data warehouse (and all of the supporting processes) to Microsoft Azure cloud.
Main duties of the job
o Leading the development and maintenance of the trust data warehouse and database systems.o Leading the technical architecture supporting the production and maintenance of a high-performance data warehouse that evolves to provide consistent capability for reporting from all key trust systems.o Implementing data loading (ETL/ELT) and data access capability from a range of sources using tools such as SSIS, ADF, Logic Apps, SSRS, PowerBI ,T-SQL, etc...o Contributing to and implementing the Trusts Business Intelligence strategy working with key stakeholders.o Lead and develop timely trust wide access to the required information to support dataset returns, operational and performance reporting.o Contributing to and implementing a strategic roadmap to provide high availability for core information and transition to a cloud first approach.
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
Provide leadership and management to the Data Warehouse team and provide support with database administrator tasks. Work closely with a range of internal and external stakeholders ensuring data collection in key systems is accurately reflected in the Data Warehouse to meet statutory and contractual requirements defined by NHS England and Commissioners. Provide specialist advice (and will be expert in this field) 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. Lead and develop timely trust wide access to the required Business Intelligence to support dataset returns, operational and performance reporting.
Please find attached job description for full details.
Advertising date : 7th October2023
Closing date : 22nd October 2023
We welcome your application.
Job description
Job responsibilities
Provide leadership and management to the Data Warehouse team and provide support with database administrator tasks. Work closely with a range of internal and external stakeholders ensuring data collection in key systems is accurately reflected in the Data Warehouse to meet statutory and contractual requirements defined by NHS England and Commissioners. Provide specialist advice (and will be expert in this field) 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. Lead and develop timely trust wide access to the required Business Intelligence to support dataset returns, operational and performance reporting.
Please find attached job description for full details.
Advertising date : 7th October2023
Closing date : 22nd October 2023
We welcome your application.
Person Specification
Education and Qualification
Essential
- Educated to degree level or equivalent experience
Desirable
- Any relevant qualifications in Data warehouse / MS SQL.
Knowledge and Experience
Essential
- Knowledge of managing large relational database schemas and models.
- Knowledge of NHS Information, datasets and submission processes
- Knowledge of ETL/ELT processes
- Knowledge of Statistics/information analysis and the use of information across the NHS.
- At least 3 years' experience of designing and developing specialised custom-built reporting systems using MS SQL Reporting Services (Report Builder) and Power BI that deliver effective solutions to meet Trust business needs
- At least 2 years experience working with Microsoft Azure cloud resources
- At least 4 years' experience of working in a lead Information role within an NHS Organisation.
- Experience of managing or supervising staff.
Desirable
- Knowledge of NHS electronic systems (ESR, Oracle Finance, etc..)
Skills and Competencies
Essential
- Advanced MS SQL Server database (On premise and the cloud) skills including SQL Server Management Studio, T-SQL, SSIS packages, stored procedures, functions, indexing and query tuning
- Report writing and technical documentation skills, including experience of reporting to senior management and attendance of steering groups and committees
- Ability to analyse highly complex data and interpret and present this appropriately
Person Specification
Education and Qualification
Essential
- Educated to degree level or equivalent experience
Desirable
- Any relevant qualifications in Data warehouse / MS SQL.
Knowledge and Experience
Essential
- Knowledge of managing large relational database schemas and models.
- Knowledge of NHS Information, datasets and submission processes
- Knowledge of ETL/ELT processes
- Knowledge of Statistics/information analysis and the use of information across the NHS.
- At least 3 years' experience of designing and developing specialised custom-built reporting systems using MS SQL Reporting Services (Report Builder) and Power BI that deliver effective solutions to meet Trust business needs
- At least 2 years experience working with Microsoft Azure cloud resources
- At least 4 years' experience of working in a lead Information role within an NHS Organisation.
- Experience of managing or supervising staff.
Desirable
- Knowledge of NHS electronic systems (ESR, Oracle Finance, etc..)
Skills and Competencies
Essential
- Advanced MS SQL Server database (On premise and the cloud) skills including SQL Server Management Studio, T-SQL, SSIS packages, stored procedures, functions, indexing and query tuning
- Report writing and technical documentation skills, including experience of reporting to senior management and attendance of steering groups and committees
- Ability to analyse highly complex data and interpret and present this appropriately
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).
