Data Warehouse Developer

Job overview

The Data Warehouse Developer is a key member of the Digital Data &  Technology (DDaT) Development team, adding value for our patients  through improving and developing information services across the Trust  and wider health and care system. They will ensure the information is an effective component of the Trust’s  Digital Data & Technology (DDaT) target operating model, working  alongside others, delivering continuous overall improvement. This role is part of supporting the ‘engine room’ of DDaT operations, transitioning 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 including performance,  maintainability and scalability along with a secure, governed and well  architected data infrastructure. You will act as a technical expert to users both within the department and to  other departments around 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 postholder will deputise for the Data Warehouse Lead, in all areas  relating to support and maintenance of the Data Warehouse and related  systems. Previous applicants  need not apply.

Main duties of the job

• Support the Data Warehouse Lead: Provide specialist technical support for a range of database applications including SQL Server, Tableau, Exasol, Bedrock Platform, Microsoft Azure. You will be responsible for ensuring the 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, to meet the growing needs of the Trust. Lead the implementation of these designs with a focus on scalability, performance, and security. Please see JD for full list

Detailed job description and main responsibilities

• Support the Data Warehouse Lead: Provide specialist technical support for a range of  database applications including SQL Server, Tableau, Exasol, Bedrock Platform, Microsoft  Azure. You will be responsible for ensuring the 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, to meet the growing needs of the Trust. Lead the implementation of these  designs with a focus on scalability, performance, and security. • Data Integration and Transformation: Manage complex ETL (Extract, Transform, Load)  processes, ensuring the timely and accurate integration of multiple datasets from various  sources into the data warehouse. Use tools such as SSIS (SQL Server Integration  Services) to automate these processes where possible.