The Rotherham NHS Foundation Trust

Technical Development Analyst

The closing date is 30 June 2025

Job summary

Embark on a unique journey with TRFTs Business Intelligence team as our Technical Development Analyst. You will collaborate with a talented team to design, build, and maintain automated data flows to NHSE supporting the Trust in becoming compliant with Faster Data Flows (FDF), utilising the Federated Data Platform (FDP) portal for secure and timely data submission. A core part of this work will be supporting the design and development of data models in support of our community Services. This role will be supporting our Business Intelligence teams to ensure the timely submission of statutory returns, ongoing monitoring and development of new reports to ultimately help provide exceptional care across our acute and community services. Our team thrives in a hybrid working model, with flexible start and finish times that reflect our commitment to work-life balance. Your contributions will be valued, the work will be rewarding, and youll play a vital role in shaping a collaborative, high-performing teammaking a real difference for our patients and those who care for them. The successful candidate must hold a degree or equivalent professional qualification, have substantial relevant experience and hold relevant Microsoft Certified Professional certification. This post will be fixed term until March 2027. Working Pattern: 37.5 hours (Monday to Friday) For Further details contact David Simm, Head of Business Intelligence Data Warehouse davidsimm@nhs.net

Main duties of the job

The postholder will design, build and maintain automated data flows to NHS England, supporting the Trusts compliance with Faster Data Flows (FDF). A key focus will be the development of data models for Community Services. As part of the Business Intelligence team, they will contribute to the Trusts vision of automating reporting using modern tools to enable self-service.They will maintain the Microsoft SQL Server data warehouse using ETL processes aligned to Kimball methodology, upholding data quality standards to support effective decision-making. The role includes safeguarding performance, security and integrity of data systems, using DevOps and change control practices to deliver efficient solutions.The postholder will translate business needs into actionable insights, create dashboards and support self-service reporting across clinical and operational teams. They will also contribute to research, service improvement and system migrations, including to cloud technologies.Mentoring colleagues and promoting best practice is expected. The successful candidate will be supported by the BI team and have access to a wide range of training and development opportunities.

About us

The Rotherham NHS Foundation Trust (TRFT) is a combined acute and community Trust serving our local population of around 270,000 people. Our vision is to always act the right way and be proud to provide exceptional healthcare to the communities of Rotherham

As a Trust we are on a journey to excellence and our people and culture are at the heart of everything we do for patients. In the latest NHS Staff Survey, we are the second most improved Trust in England for would you recommend the Trust as a place to work?, and were one of the most improved for staff engagement overall

But don't just take our word for it each year hundreds of colleagues receive nominations for our Excellence and Proud awards, showcasing our brilliant people and recognising their achievements. Our people make a difference to the lives of patients every day and we are proud of the improvements we are making

All of our colleagues are key to our journey, and we are continuing to improve our services by upholding the Trusts values of Ambitious, Caring and Together. If you are passionate about making a difference, then please apply to join us on our journey to excellence

Certificates of Sponsorship

For individuals who may require sponsorship under the skilled worker or health & care visa route please use the link below to check your eligibility. Check if you need a UK visa - GOV.UK (www.gov.uk) band 2 and entry level band 3 roles are no longer eligible for sponsorship.

Details

Date posted

20 June 2025

Pay scheme

Agenda for change

Band

Band 7

Salary

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

Contract

Fixed term

Duration

21 months

Working pattern

Full-time, Flexible working

Reference number

C9165-25-04-114

Job locations

Woodside Building

Moorgate Road

Rotherham

S60 2TY


Job description

Job responsibilities

Please see attached the job description and person specification for the full details about the role and the responsibilities.

Job description

Job responsibilities

Please see attached the job description and person specification for the full details about the role and the responsibilities.

Person Specification

Experience

Essential

  • Previous experience of supporting Commissioners, Finance and Contracting departments in the provision of contract
  • Experience with Community/Acute EPR systems (Meditech, SystmOne)
  • Experience of Data Mining/NHS Analytical experience in an acute or community setting

Qualifications

Essential

  • Degree or equivalent occupational/professional qualification or experience
  • Significant experience or educated to relevant Microsoft Certified Professional certification or other equivalent post graduate qualification in the use of the Microsoft SQL software suite
  • Evidence of relevant continued professional development

Desirable

  • Member of a relevant professional body Fed IP, BCS

knowledge

Essential

  • T-SQL Scripting, Views/Stored Procedures, Cursors and functions
  • Kimball data warehousing methodology
  • NHS Data Definitions, Datasets and Statistical Returns

Desirable

  • NHS Information Governance
  • Data Protection Act 1998 and Caldicott Principles
  • Data Accreditation/Information Quality Assurance
Person Specification

Experience

Essential

  • Previous experience of supporting Commissioners, Finance and Contracting departments in the provision of contract
  • Experience with Community/Acute EPR systems (Meditech, SystmOne)
  • Experience of Data Mining/NHS Analytical experience in an acute or community setting

Qualifications

Essential

  • Degree or equivalent occupational/professional qualification or experience
  • Significant experience or educated to relevant Microsoft Certified Professional certification or other equivalent post graduate qualification in the use of the Microsoft SQL software suite
  • Evidence of relevant continued professional development

Desirable

  • Member of a relevant professional body Fed IP, BCS

knowledge

Essential

  • T-SQL Scripting, Views/Stored Procedures, Cursors and functions
  • Kimball data warehousing methodology
  • NHS Data Definitions, Datasets and Statistical Returns

Desirable

  • NHS Information Governance
  • Data Protection Act 1998 and Caldicott Principles
  • Data Accreditation/Information Quality Assurance

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

The Rotherham NHS Foundation Trust

Address

Woodside Building

Moorgate Road

Rotherham

S60 2TY


Employer's website

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


Employer details

Employer name

The Rotherham NHS Foundation Trust

Address

Woodside Building

Moorgate Road

Rotherham

S60 2TY


Employer's website

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


Employer contact details

For questions about the job, contact:

David Simm

davidsimm@nhs.net

07810453684

Details

Date posted

20 June 2025

Pay scheme

Agenda for change

Band

Band 7

Salary

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

Contract

Fixed term

Duration

21 months

Working pattern

Full-time, Flexible working

Reference number

C9165-25-04-114

Job locations

Woodside Building

Moorgate Road

Rotherham

S60 2TY


Supporting documents

Privacy notice

The Rotherham NHS Foundation Trust's privacy notice (opens in a new tab)