Data Warehouse Developer

Rotherham Doncaster & South Humber Foundation Trust; Doncaster; On-site; GBP 35,000 - 55,000; Full time

Job summary

A healthcare organization in Doncaster is looking for a Data Warehouse Developer/Data Engineer with experience in Power BI and SQL Server BI toolset. You will assist in the delivery of business intelligence services, ensuring effective integration of data for reporting solutions. Strong architecture design skills in Power BI are essential. The role offers opportunities to work in a supportive environment focused on delivering quality patient care.

Qualifications

• Experience with Power BI and SQL Server BI toolset is essential.
• Strong architecture design skills in Power BI.
• Ability to analyze and interpret complex problems.

Responsibilities

• Assist in the delivery, development, and management of a business intelligence service.
• Support the development and implementation of the Trust-wide Power BI platform.
• Liaise with colleagues to help deliver information requirements.

Skills

Power BI

SQL Server BI toolset

Data Transformation

ETL tasks

Architecture design

Job description

We are looking for a new Data Warehouse Developer/Data Engineer with experience primarily focussed on Power BI & SQL Server BI toolset (SQL/SSRS/SSIS). The team is involved with data insight, data transformation, ETL tasks, National Submission work and reporting for the trust from various systems. Currently this is designed in a data warehouse and tabular models and presented using SSRS and Power BI. We are looking for someone with strong architecture design skills in Power BI, creating models and designing reporting solutions for the business.

The post holder will be responsible to assist in the delivery, development and management of a comprehensive business intelligence service and to ensure this environment will enable the Trust to achieve its clinical and business objectives.

The method to deliver this will be through the intelligent application of information and the provision of robust intelligence about the Trust’s business functions. This will ensure we have in place an organisation capable of delivering safe, effective and efficient patient care through the provision of quality information in a timely manner to where it is required.

The post holder will be part of the Information team charged with the responsibility to lead the integration of a “business intelligence” philosophy and information / performance management culture throughout the Trust in line with the IM&T Strategy.

The post holder will have responsibility for supporting the development and implementation of the Trust-wide Power BI platform along with ongoing development of the data warehouse.

The post holder will liaise with colleagues within the Information Analysts and Clinical Systems teams to help deliver information requirements. This will require analysis, interpretation and resolution of highly complex problems, covering a wide range of clinical and business areas including at a national level.

The post holder will be the secondary resource for developing, maintaining and evolving the Trust’s Data Warehouse, to support the provision of all reporting requirements transforming data from disparate corporate systems to bring this together to provide centralised information gathering along with automated performance and Business Intelligence reporting.

Rotherham Doncaster and South Humber NHS Foundation Trust (RDaSH) employ around 4000 talented colleagues who are very much appreciated, valued, and respected.

We have a wide portfolio which includes mental health, physical health, learning disability and drug and alcohol services.

About

We are passionate about enhancing the quality of our service and we work hard to attract and select the right colleagues for our organisation. Our goal is to employ those who share our passion for providing first class care while remaining committed to our vision and values. Please view our Strategy using the link below:

https://www.rdash.nhs.uk/documents/clinical-and-organisational-strategy-2023-to-2028/

To find out more about working for RDaSH and the fantastic benefits we offer visit our website:

https://workwithrdash.co.uk/

We Are Committed To Inclusive Cultures And Really Value People In Our Organisation, View Our Allyship Video On YouTube To Find Out More

https://youtu.be/WMJSkLoTk4Q

The main terms and conditions of service can be found here:

https://www.nhsemployers.org/publications/tchandbook

For further details / informal visits contact: Name: Paul Campbell Job title: Data Warehouse Manager Email address: [e-mail]