Data Warehouse Developer

At the Royal Berkshire NHS Foundation Trust we put our patients at the heart of every element of health and care that we provide. The Trust works together as a community to deliver its vision which is "Working together to provide outstanding care for our community."

Royal Berkshire Hospital are pleased to announce that following our CQC inspection we have been rated 'Good' with inspectors reporting that we have made significant improvements. The Trust's overall rating has also improved to 'good'.

We are Compassionate in our thoughts, words and actions

We are Aspirational and have a true desire to be dynamic and to innovate

We are Resourceful and responsible in the way we work and live

We are Excellent in our development, fairness and sharing best practice

At the Royal Berkshire NHS Foundation Trust, we value candidates who bring their unique personalities, skills, and experiences to the Trust. When completing your application, we encourage you to highlight your individual achievements and strengths, showing us how they align with the requirements outlined in the job description and person specification. While we recognise that some applicants may use AI tools during the process, please be mindful that AI-generated responses can often lack the personal detail and relevance needed to demonstrate your suitability for the role. AI generated content is discouraged by the Trust and may diminish the candidates chances of success.

Amazing things happen at the Royal Berkshire NHS Foundation Trust; delivered by amazing people so why don't you come and join us. We offer a range of learning and development for all employees may you be clinical or non-clinical., 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., * 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, * 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.

• Educated to degree level or equivalent., * Degree in relevant field; computer science, coding, * Demonstrable experience of the maintenance and development of the Data Warehouse and BI architecture including performance, maintainability and scalability

Desirable criteria

• Experience delivering specialist training to other staff and organisations in all aspects of the Data Warehouse technical environment.

We are an approved sponsoring organisation. Applications will be considered from applicants requiring sponsorship alongside all other applications. Please be aware, not all roles are eligible for sponsorship. You can review the list of eligible role and requirements on the government website.

Staff Benefits

• Flexible working opportunities and a strong emphasis on your work, life balance
• Annual leave - 27 days for new starters, plus bank holidays. Increasing to 29 days after 5 years and 33 days after 10 years NHS service. Pro rata for part time staff
• NHS pension scheme
• Employee Assistance Programme
• Money Advice Service
• Generous maternity, paternity and adoption leave for eligible staff
• On-site nursery (based at RBH)
• Full educational library services
• Cycle to work scheme, lockable storage for cycles
• Bus to work scheme
• Excellent rail and bus links
• A huge range of Health Service Discounts at hundreds of big brands from holidays to gadgets and restaurants to retail.

By applying for this post you are agreeing to Royal Berkshire NHS Foundation Trust transferring the information contained in this application to its preferred applicant management system. If you are appointed to a post information will also be transferred into the national NHS Electronic Staff Records system. Appointment to any position is conditional on the satisfactory completion of the core NHS Employment Checks Standards. Information disclosed in your application will be checked and any offer of appointment may be withdrawn if you knowingly withhold information or provide false or misleading information. All new appointments to the Trust, with the exception of executive positions, are subject to a 6 month probationary period. The Trust may close any vacancy prior to the advertised closing date due to the high level of responses we receive for some of our vacancies. Royal Berkshire NHS Foundation Trust is committed to improving the health of its staff, patients and the wider community by providing a smoke free environment. A smoke free policy is in operation and smoking is not permitted on any of the Trust's sites., The postholder will have access to vulnerable people in the course of their normal duties and as such this post is subject to the Rehabilitation of Offenders Act 1974 (Exceptions) Order 1975 (Amendment) (England and Wales) Order 2020 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service to check for any previous criminal convictions.