Nottingham University Hospitals NHS Trusts

Data Warehouse Analyst/Developer

Information:

This job is now closed

Job summary

We have an excellent permanent opportunity for an experienced Data Warehouse Analyst/Developer to join our Data Warehousing team and to help us drive forward the Trust's Data Warehousing strategy.

Main duties of the job

In addition to the below job summary , you need to familiarize yourself with full Job Description and Person Specification documents attached to this advert.

The successful candidate will be based at the City Hospital Campus, and will be expected to take part in the support for and enhancement of our existing data warehouse, as well as in the design, specification, and development of various new ETL and data migration packages; the role encompasses hands-on involvement in all phases of the full software development lifecycle.

About us

The NUH data warehousing team is a small, hard-working team, currently made up of the Data Warehouse Manager and 5 Data Warehouse Analyst/Developers. We are a very friendly and supportive team, with close working ties to other teams in the Trust, such as e.g. colleagues in the SQLDBA team and in Information & Insight.

Details

Date posted

12 May 2023

Pay scheme

Agenda for change

Band

Band 6

Salary

£35,392 to £42,618 a year per annum

Contract

Permanent

Working pattern

Full-time

Reference number

164-5282274

Job locations

NUH, City Hospital

Hucknall Road

Nottingham

NG5 1PB


Job description

Job responsibilities

The primary responsibility of the post holder is to design, develop, test, and maintain extract, transform and load (ETL) routines, together with the corresponding target data warehouse database objects and structures and all associated documentation.

We are therefore looking for an enthusiastic, self-motivated and forward thinking individual who possesses in-depth technical knowledge and practical experience of Data Warehousing, SQLServer, T-SQL, and MS SSIS, combined with excellent proven analysis and design skills. Excellent written and verbal communication skills are likewise essential for this post. Experience of working within the NHS and with NHS data structures, as well as experience of working within a Quality Management System (ISO9001:2008 or similar), would be advantageous.

Job description

Job responsibilities

The primary responsibility of the post holder is to design, develop, test, and maintain extract, transform and load (ETL) routines, together with the corresponding target data warehouse database objects and structures and all associated documentation.

We are therefore looking for an enthusiastic, self-motivated and forward thinking individual who possesses in-depth technical knowledge and practical experience of Data Warehousing, SQLServer, T-SQL, and MS SSIS, combined with excellent proven analysis and design skills. Excellent written and verbal communication skills are likewise essential for this post. Experience of working within the NHS and with NHS data structures, as well as experience of working within a Quality Management System (ISO9001:2008 or similar), would be advantageous.

Person Specification

Qualifications

Essential

  • IT degree or equivalent experience

Experience

Essential

  • Minimum of 6 months practical experience in use of SSMS and T-SQL
  • Minimum of 6 months recent practical experience in use of SSIS
  • Experience in data warehousing and business intelligence
  • Experience in the full development life-cycle, including Analysis and Design

Desirable

  • Experience in the use of either Oracle and/or other relational / non-relational RDBMS technologies
  • Experience in parsing JSON and/or XML.
  • 6 months experience of working within the NHS

Communication skills

Essential

  • Demonstrates the ability to communicate effectively with colleagues, managers, other ICT staff, and internal and external customers and suppliers orally, in writing, and electronically.
  • Demonstrates the ability to write clear and concise technical and non-technical documentation such as analysis and design specifications and user guides.
Person Specification

Qualifications

Essential

  • IT degree or equivalent experience

Experience

Essential

  • Minimum of 6 months practical experience in use of SSMS and T-SQL
  • Minimum of 6 months recent practical experience in use of SSIS
  • Experience in data warehousing and business intelligence
  • Experience in the full development life-cycle, including Analysis and Design

Desirable

  • Experience in the use of either Oracle and/or other relational / non-relational RDBMS technologies
  • Experience in parsing JSON and/or XML.
  • 6 months experience of working within the NHS

Communication skills

Essential

  • Demonstrates the ability to communicate effectively with colleagues, managers, other ICT staff, and internal and external customers and suppliers orally, in writing, and electronically.
  • Demonstrates the ability to write clear and concise technical and non-technical documentation such as analysis and design specifications and user guides.

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

NUH, City Hospital

Hucknall Road

Nottingham

NG5 1PB


Employer's website

https://www.nuh.nhs.uk/ (Opens in a new tab)

Employer details

Employer name

Nottingham University Hospitals NHS Trusts

Address

NUH, City Hospital

Hucknall Road

Nottingham

NG5 1PB


Employer's website

https://www.nuh.nhs.uk/ (Opens in a new tab)

Employer contact details

For questions about the job, contact:

Enterprise Data Architect

Irene Juurlink

irene.juurlink@nuh.nhs.uk

01159691169

Details

Date posted

12 May 2023

Pay scheme

Agenda for change

Band

Band 6

Salary

£35,392 to £42,618 a year per annum

Contract

Permanent

Working pattern

Full-time

Reference number

164-5282274

Job locations

NUH, City Hospital

Hucknall Road

Nottingham

NG5 1PB


Supporting documents

Privacy notice

Nottingham University Hospitals NHS Trusts's privacy notice (opens in a new tab)