Data Warehouse Developer
Job summary
The Data Warehouse Developer is a key member of the Digital Data &Technology (DDaT) Development team, adding value for our patientsthrough improving and developing information services across the Trustand wider health and care system.They will ensure the information is an effective component of the Trust'sDigital Data & Technology (DDaT) target operating model, workingalongside 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 developmentof the Data Warehouse and BI architecture including performance,maintainability and scalability along with a secure, governed and wellarchitected 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:o Microsoft SQL Server (T-SQL, SSIS, SSRS, SSAS)o Data Warehousing Architectureso Microsoft Power BIo Tableauo Exasolo Bedrock Platformo Microsoft AzureThe postholder will deputise for the Data Warehouse Lead, in all areasrelating to support and maintenance of the Data Warehouse and relatedsystems.Previous applicants need not apply.
Main duties of the job
o 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.o 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 description
Job responsibilities
Support the Data Warehouse Lead: Provide specialist technical support for a range ofdatabase applications including SQL Server, Tableau, Exasol, Bedrock Platform, MicrosoftAzure. You will be responsible for ensuring the smooth operation, stability, andperformance of the data warehouse, responding promptly to system issues and userqueries. Data Warehouse Architecture: Contribute to the design and development of the datawarehouse architecture, including new data marts, ETL processes, and databasestructures, to meet the growing needs of the Trust. Lead the implementation of thesedesigns 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 varioussources into the data warehouse. Use tools such as SSIS (SQL Server IntegrationServices) 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.
Employer details
Employer name
Royal Berkshire NHS Foundation Trust
Address
Royal Berkshire Hospital
London Road
Reading
RG1 5AN
Employer's website
https://www.royalberkshire.nhs.uk/