Rotherham Doncaster and South Humber NHSFT

Data Architect

The closing date is 07 July 2025

Job summary

We are looking for a Data Architect for our busy Data Warehouse team here at RDaSH. Will lead on the design and direction of the Data Warehouse, the Business Intelligence offering (Power BI) and support to manage the Data Warehouse developers within the team.

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.

Main duties of the job

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 Data Warehouse 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 design, maintenance and ongoing development and implementation of the Trust-wide data warehouse. This will also involve line management of other staff within the Data Warehouse Team.

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

About us

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.

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

Details

Date posted

23 June 2025

Pay scheme

Agenda for change

Band

Band 7

Salary

£46,148 to £52,809 a year per annum

Contract

Permanent

Working pattern

Full-time, Flexible working, Home or remote working

Reference number

376-CP-0610

Job locations

Rotherham, Doncaster & South Humber NHS Foundation Trust (RDaSH)

Tickhill Road Site, Balby

Doncaster

DN4 8QN


Job description

Job responsibilities

Please view the attached job description and person specification to view the full details about the role

Job description

Job responsibilities

Please view the attached job description and person specification to view the full details about the role

Person Specification

Qualifications

Essential

  • Degree qualification in relevant subject or demonstrable experience

Experience

Essential

  • Experience in maintaining business critical databases and data warehouse
  • Experience in relational database management systems (RDBMS) normalisation and de-normalisation, building and maintaining an enterprise data warehouse
  • Significant experience of ETL and data warehouse schemas
  • Experience of documenting processes so they can be easily understood
  • Experience in the use of database extraction tools to develop complex queries
  • Experience of pulling together data from a wide range of sources.
Person Specification

Qualifications

Essential

  • Degree qualification in relevant subject or demonstrable experience

Experience

Essential

  • Experience in maintaining business critical databases and data warehouse
  • Experience in relational database management systems (RDBMS) normalisation and de-normalisation, building and maintaining an enterprise data warehouse
  • Significant experience of ETL and data warehouse schemas
  • Experience of documenting processes so they can be easily understood
  • Experience in the use of database extraction tools to develop complex queries
  • Experience of pulling together data from a wide range of sources.

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.

Certificate of Sponsorship

Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab).

From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab).

Additional information

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.

Certificate of Sponsorship

Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab).

From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab).

Employer details

Employer name

Rotherham Doncaster and South Humber NHSFT

Address

Rotherham, Doncaster & South Humber NHS Foundation Trust (RDaSH)

Tickhill Road Site, Balby

Doncaster

DN4 8QN


Employer's website

https://www.rdash.nhs.uk/ (Opens in a new tab)

Employer details

Employer name

Rotherham Doncaster and South Humber NHSFT

Address

Rotherham, Doncaster & South Humber NHS Foundation Trust (RDaSH)

Tickhill Road Site, Balby

Doncaster

DN4 8QN


Employer's website

https://www.rdash.nhs.uk/ (Opens in a new tab)

Employer contact details

For questions about the job, contact:

Data Warehouse Manager

Paul Campbell

paul.campbell@nhs.net

Details

Date posted

23 June 2025

Pay scheme

Agenda for change

Band

Band 7

Salary

£46,148 to £52,809 a year per annum

Contract

Permanent

Working pattern

Full-time, Flexible working, Home or remote working

Reference number

376-CP-0610

Job locations

Rotherham, Doncaster & South Humber NHS Foundation Trust (RDaSH)

Tickhill Road Site, Balby

Doncaster

DN4 8QN


Supporting documents

Privacy notice

Rotherham Doncaster and South Humber NHSFT's privacy notice (opens in a new tab)