Data Warehouse Developer

Job overview

At GOSH, our data is key in ensuring that we meet national and local information reporting requirements to external commissioning bodies and registries and well as supporting clinical service delivery, information development, performance management and planning throughout the hospital.

We are looking for a Data Warehouse Developer who will work with colleagues to develop and maintain processes populating the Trust’s data warehouse from operational systems and processes extracting data from that warehouse to produce datasets for internal and external reporting, as well as producing outputs using BI and visualization tools to Trust standards.

You will be an integral member of the Information Services Business Intelligence and Development team, supporting clinical service delivery, information development, performance management and planning throughout the hospital.

We are offering this as a development position, starting at Band 6, which can be upgraded to a Band 7 following successful completion of a development plan (usually in 18 months). Applicants will be expected to demonstrate personal development to date and a willingness to learn. Details of the training plan and its assessment can be discussed at interview.

This is a great opportunity for someone looking to develop and build on their existing technical, analytical, and problem-solving skills.

Main duties of the job

The responsibilities of the role include:

• Understanding the reporting requirements of the Trust and translating these into an end product
• Specification and design of report and data requirements
• Data Warehousing development for existing or new Trust Information Systems, including the specification and provision of datasets
• Development of reporting to support operational and clinical need
• Troubleshooting and investigation of issues
• Providing support and knowledge sharing with both technical and non-technical colleagues across the Trust

As detailed in the person specification this role would suit someone who:

• Has experience with SQL and data warehousing principles
• Has an analytical and logical mind-set and enjoys problem-solving
• Has BI Tools experience
• Is adaptable and confident working alone as well collaboratively as part of a team

Previous NHS experience would be an advantage but is not essential. Shortlisted candidates will be required to undertake a SQL and Excel test as part of the interview process.

Detailed job description and main responsibilities

The full job description provides an overview of the key tasks and responsibilities of the role, and the person specification outlines the qualifications, skills, experience, and knowledge required. For both documents please view the attachment(s) below.