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.

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.

Any attachments will be accessible after you click to apply.

164-5282274