Job summary
NUH Digital Services are looking for an experienced Data Warehouse Analyst/Developer to join our Data Warehouse team in a senior capacity, to help us drive forward the Trust's Data Warehousing strategy.
Main duties of the job
In addition to the job summary below, 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 a leading role 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 mentoring, advising, and providing leadership for more junior staff, as well as hands-on involvement in all phases of the full software development lifecycle.
About us
The NUH data warehousing team is a small, diverse, and 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, and we provide everyone in our teams with the opportunity to learn and develop.
Job description
Job responsibilities
The primary responsibility of the post holder is to provide project leadership for and provide hands-on involvement in the design, development, testing, and maintenance of extract, transform and load (ETL) routines, together with the corresponding target data warehouse database objects and structures, and all associated documentation.
The job responsibilities also include providing assistance to the team manager, for instance by mentoring and advising more junior members of the team.
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 as well as excellent interpersonal skills.
As we need the successful candidate to be able to hit the ground running, demonstrable prior experience of working in a similar role within the NHS and with NHS data structures is vital to this post. Excellent written and verbal communication skills are likewise essential.
Job description
Job responsibilities
The primary responsibility of the post holder is to provide project leadership for and provide hands-on involvement in the design, development, testing, and maintenance of extract, transform and load (ETL) routines, together with the corresponding target data warehouse database objects and structures, and all associated documentation.
The job responsibilities also include providing assistance to the team manager, for instance by mentoring and advising more junior members of the team.
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 as well as excellent interpersonal skills.
As we need the successful candidate to be able to hit the ground running, demonstrable prior experience of working in a similar role within the NHS and with NHS data structures is vital to this post. Excellent written and verbal communication skills are likewise essential.
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)
Desirable
- Qualification in ITIL Service Management
Exper
Essential
- Experience of working in a similar role within the NHS and with NHS data sets.
- At least 5 years' experience of data warehousing software development within a structured environment.
- Expert knowledge of and experience in the use of SQLServer databases and SQL/TSQL
- Demonstrable experience in performing a leading role in all stages of the development lifecycle
Desirable
- Experience of working with JSON and/or XLM
- Experience of working with non-Microsoft ETL tools and database 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)
- Demonstrable experience in writing project-related documentation, 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)
Desirable
- Qualification in ITIL Service Management
Exper
Essential
- Experience of working in a similar role within the NHS and with NHS data sets.
- At least 5 years' experience of data warehousing software development within a structured environment.
- Expert knowledge of and experience in the use of SQLServer databases and SQL/TSQL
- Demonstrable experience in performing a leading role in all stages of the development lifecycle
Desirable
- Experience of working with JSON and/or XLM
- Experience of working with non-Microsoft ETL tools and database 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)
- Demonstrable experience in writing project-related documentation, 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.
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).