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 Architecture
* 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. 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.
About us
Diversity makes us interesting... Inclusion is what will make us outstanding.
Inequality exists and the journey to eliminate it is not easy. Every step we take will be a purposeful step forward to deliver a truly inclusive culture where all our people are enabled to deliver outstanding care, where background is no barrier, and where everyone can be their authentic self and we truly represent our patient community.
We are committed to equal opportunities and welcome applications from all sections of the community, regardless of any 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.
If you need additional help with your application please get in touch by calling the recruitment team on 0118 322 6997 or 0118 322 5342.
Our primary method of communication will be via email. However, if you would prefer to be contacted through a different method, please inform the recruitment team.
Job 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.
Person Specification
Qualifications
* Educated to degree level or equivalent.
* Degree in relevant field; computer science, 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 as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service (formerly known as CRB) to check for any previous criminal convictions.
#J-18808-Ljbffr