Senior Data Warehouse Officer - Newcastle upon Tyne, United Kingdom - Cumbria, Northumberland, Tyne and Wear NHS Foundation Trust

Cumbria, Northumberland, Tyne and Wear NHS Foundation Trust
Cumbria, Northumberland, Tyne and Wear NHS Foundation Trust
Verified Company
Newcastle upon Tyne, United Kingdom

2 weeks ago

Tom O´Connor

Posted by:

Tom O´Connor

beBee Recruiter
Description
This is an exciting role within the Digital Services department. We are a small team but achieve great things. If you are passionate about data and working with cloud technology then read on...


Your role will be to:

Support the successful delivery of a Trust wide data warehouse for the Trusts business critical systems.

Support the Data Warehouse Manager on the development of a Trust wide reporting system including the use of dashboards.


Provide specialist advice relating to the interpretation of NHS data metrics and standards and take these into account when loading data into the data warehouse.

Provide technical expertise and in depth understanding of NHS information from a variety of systems.

Support the creation and maintenance process of nationally mandated
datasets and to ensure accurate and timely submission of all relevant statutory returns.


The Digital Services Systems Development Team provides a key function to the Trust in the areas of in-house systems development, web development (intranet and internet), data warehousing, enterprise level reporting (including dashboard development) and system support.

This important role will continue to develop and support the Trusts Data Warehouse and reporting / metric creation function.

You will need a strong understanding of databases and Microsoft SQL Server development (T-SQL, Integration Services), Reporting Services (Report Builder) and PowerBI.

Microsoft Azure exposure would be advantageous.


You will have a good understanding of NHS data, metrics and standards and will have experience of working with an enterprise level data warehouse.

An understanding of NHS commissioning, datasets and performance targets would be advantageous.

This is an exciting opportunity to join a fast-growing area within the department.


We aim to attract and retain a diverse, talented and committed workforce, who are caring and compassionate, and therefore able to meet the demands of the modern NHS now and in the future.

In return we can offer a dynamic working environment in which to build a career.


We recognise that the people who work for us are our greatest asset, and when you feel supported and happy at work this positively reaches those very people we are here for - our service users.


  • Advanced Knowledge of Relational Databases
  • In depth Knowledge in the field of NHS Information
  • In depth Knowledge of NHS Information requirements, datasets and submission processes
  • Knowledge of managing large relational database schemas
  • In depth knowledge of ETL/ELT processes.
  • In depth knowledge of building functional dashboards.
  • Advanced MS SQL Server database skills including SQL Server Management Studio, T-SQL, SSIS packages, stored procedures, functions, indexing and query tuning.
  • Experience of maintaining accurate documentation regarding the data structures, metrics, routines and files used by the Data Warehouse Team.
  • Experience of designing and developing specialised custombuilt reporting systems using MS SQL Reporting Services (Report Builder) and / or Power BI.
  • Experience of assessing the impact of forthcoming changes to NHS information requirements so that changes / improvements to the Trusts Data warehouse are developed and tested in good time
Experience of using BI tools and OLAP Reporting tools.

Please find attached job description for full details.


Advertising date: 29thAugust 2023


Closing date: 12thSeptember 2023
More jobs from Cumbria, Northumberland, Tyne and Wear NHS Foundation Trust
See all jobs of Cumbria, Northumberland, Tyne and Wear NHS Foundation Trust