Overview
The Data Warehouse Developer is a key member of the Digital Data & Technology (DDaT) Development team, adding value for our patients by improving and developing information services across the Trust and wider health and care system. They will ensure that information is an effective component of the Trust’s Digital Data & Technology target operating model, working alongside others to deliver continuous overall improvement. The role involves supporting the ‘engine room’ of DDaT operations as we transition from outsourced arrangements to an in‑house delivery model. The post holder will be responsible for the maintenance and development of the Data Warehouse and BI architecture, ensuring performance, maintainability, scalability, as well as a secure, governed and well‑architected data infrastructure. They will act as a technical expert to users within the department and across the Trust in the following key areas: Microsoft SQL Server (T‑SQL, SSIS, SSRS, SSAS), Data Warehousing Architectures, Microsoft Power BI, Tableau, Exasol, Bedrock Platform, Microsoft Azure. The post holder will deputise for the Data Warehouse Lead in all areas relating to support and maintenance of the Data Warehouse and related systems.
Responsibilities
- Support the Data Warehouse Lead: provide specialist technical support for database applications such as SQL Server, Tableau, Exasol, Bedrock Platform, and Microsoft Azure; ensure smooth operation, stability, and performance of the data warehouse, responding promptly to system issues and user queries.
- Data Warehouse Architecture: contribute to the design and development of the data warehouse architecture, including new data marts, ETL processes, and database structures, and lead the implementation of these designs with a focus on scalability, performance, and security.
- Data Integration and Transformation: manage complex ETL processes, ensuring timely and accurate integration of multiple datasets from various sources into the data warehouse; use tools such as SSIS to automate these processes where possible.
Person Specification
Qualifications
- Educated to degree level or equivalent.
- Degree in a relevant field such as computer science or coding.
Experience
- Demonstrable experience of the maintenance and development of the Data Warehouse and BI architecture, including performance, maintainability, and scalability.
- Experience delivering specialist training to other staff and organisations in all aspects of the Data Warehouse technical environment.
Disclosure and Barring Service Check
This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and requires a Disclosure and Barring Service check.
Equal Opportunity
We are committed to equal opportunities and welcome applications from all sections of the community, regardless of protected characteristics. Reasonable adjustments will be made for disabled applicants where possible. All applicants who have a disability and meet the minimum criteria for the post can opt for a guaranteed interview.
#J-18808-Ljbffr…