Job summary NUH Digital Services are looking for a number of experienced Senior Data Warehouse Analyst/Developers to join our Data Warehouse team for a period of 18 months, to support us during the implementation of a new Patient Administration System. The potential post-holders must have proven expertise in the use of SQLServer, MS SQL, and SSIS. Previous NHS experience would be highly advantageous. Please note that this role requires regular on-site attendance, and that interviews will take place on site. Previous applicants for this role, which was also advertised in June/July of this year, need not apply. Applicants are kindly requested to refrain from using AI at any stage during the recruitment process. Main duties of the job Please note that, in addition to the below summary, you will need to familiarise yourself with the full job description and person specification documents attached to this advert. Working closely with colleagues in the Data Warehousing and other Digital & Information teams, the post holder will be expected to take a leading role in the analysis, design, and development of both standard as well as ad-hoc data warehousing packages for the provision of data for reports, dashboards, downstream systems, and for data migration purposes. As an expert in the field of Trust data, data validation, ETL mechanisms, and data provision, the post-holder will also be expected to provide leadership and mentoring for less experienced colleagues. They will also be expected to help with the development and maintenance of standards, procedures, and best practice guides, also where this may concern the potential adoption of new technologies in the team. About us With over 19,000 staff, we are one of the biggest employers in the city with a central role in supporting the health and wellbeing of our local population. We play a leading role in research, education and innovation. Come and join our wonderful team at NUH. We are big believers in diversity and welcome new ideas to help develop our team in order to deliver world class healthcare to the vast patient populations we serve. With endless personal development opportunities available, at NUH we will endeavour to turn your job into a career We particularly welcome applications from people who identify as Black, Asian and Minority Ethnic, or Disabled, as we are striving to be better represented at NUH. Date posted 06 November 2024 Pay scheme Agenda for change Band Band 7 Salary £46,148 to £52,809 a year per annum Contract Fixed term Duration 18 months Working pattern Full-time Reference number 164-6765462 Job locations City Hospital Campus Hucknall Road Nottingham NG5 1PB Job description Job responsibilities Your work will be varied and interesting, encompassing e.g. the investigation of acquiring potential new datasets from various clinical systems into the Trust data warehouse, building new data pipelines, ongoing monitoring of existing packages, providing architectural and strategic advice, etc. A full description of the job and the main responsibilities can be found in the Job Description document that accompanies this advert. In your application, please make sure you address the key points outlined in the Person Specification so we can assess your suitability for this role, specifically with regards to your practical experience in working with standard NHS datasets, SQLServer / SSIS, data mapping, requirements gathering, analysis and design, and providing any and all associated project documentation. Job description Job responsibilities Your work will be varied and interesting, encompassing e.g. the investigation of acquiring potential new datasets from various clinical systems into the Trust data warehouse, building new data pipelines, ongoing monitoring of existing packages, providing architectural and strategic advice, etc. A full description of the job and the main responsibilities can be found in the Job Description document that accompanies this advert. In your application, please make sure you address the key points outlined in the Person Specification so we can assess your suitability for this role, specifically with regards to your practical experience in working with standard NHS datasets, SQLServer / SSIS, data mapping, requirements gathering, analysis and design, and providing any and all associated project documentation. Person Specification Training & Qualifications Essential A relevant IT degree at MSc level or above, or equivalent technical qualification & experience (equivalent experience a minimum of 3 years' working in a relevant technical role of sufficient seniority) Experience Essential At least 3 years' experience of working in a similar role within the NHS and with NHS data sets At least 3 years' experience of software development within a structured environment Expert knowledge of and experience in the use of SQLServer databases and SQL/TSQL At least 2 years' experience in the use of SSIS Experience in requirements gathering, software analysis/design and in data mapping Desirable Experience of working with JSON and/or XLM Experience of working with non-Microsoft ETL tools and database technologies Experience of working with Cloud ETL tools and technologies Communication & Relationship Skills Essential Excellent verbal and written communication (-1 for spelling mistakes, -1 for grammatical mistakes, -2 for unanswered questions, -2 for unclear/confused answers, -5 for obvious use of AI to complete the application) Demonstrable experience in writing standards documents, best practice guides, etc. Person Specification Training & Qualifications Essential A relevant IT degree at MSc level or above, or equivalent technical qualification & experience (equivalent experience a minimum of 3 years' working in a relevant technical role of sufficient seniority) Experience Essential At least 3 years' experience of working in a similar role within the NHS and with NHS data sets At least 3 years' experience of software development within a structured environment Expert knowledge of and experience in the use of SQLServer databases and SQL/TSQL At least 2 years' experience in the use of SSIS Experience in requirements gathering, software analysis/design and in data mapping Desirable Experience of working with JSON and/or XLM Experience of working with non-Microsoft ETL tools and database technologies Experience of working with Cloud ETL tools and technologies Communication & Relationship Skills Essential Excellent verbal and written communication (-1 for spelling mistakes, -1 for grammatical mistakes, -2 for unanswered questions, -2 for unclear/confused answers, -5 for obvious use of AI to complete the application) Demonstrable experience in writing standards documents, best practice guides, etc. 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 (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. 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 (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 Nottingham University Hospitals NHS Trusts Address City Hospital Campus Hucknall Road Nottingham NG5 1PB Employer's website https://www.nuh.nhs.uk/ (Opens in a new tab)