NHS Data & BI Analyst (Hybrid)

The Rotherham NHS Foundation Trust; Rotherham; Hybrid; GBP 40,000 - 48,000; Full time

Job summary

The RotherhamNHS Foundation Trust is seeking a Business Intelligence analyst to support reporting of clinical care and charging mechanisms. You will work across data warehouses, ETL processes, and BI tools to deliver high-quality data pipelines and analytics for service decision-making.

Join a collaborative team in a hybrid role, with flexible hours. You will engage with PbR/Commissioning data, develop dashboards, and help ensure data quality and governance across care groups.

Qualifications

• Expertise in Information Management and reporting from multiple sources.
• Working knowledge of NHS Payment mechanisms & SUS.
• Experience with databases to create charts and visuals for customer insight.
• Understanding NHS Key Performance Metrics and national reporting requirements.
• Proficiency in T-SQL, stored procedures, and functions.

Responsibilities

• Generate, analyse, and report data and KPIs related to activity monitoring and charging mechanisms.
• Support PbR/Commissioning Information Manager with internal and external submissions.
• Maintain and develop the SQL Server data warehouse and ETL processes aligned to Kimball methodology.

Skills

NHS payment mechanisms

SUS

T-SQL

Stored Procedures

PowerBI

SQL

MS Excel

Data analysis

Education

Degree in a relevant subject

Tools

SQL Server

Power BI

Job description

The RotherhamNHS Foundation Trust is seeking a Business Intelligence analyst to support reporting of clinical care and charging mechanisms. You will work across data warehouses, ETL processes, and BI tools to deliver high-quality data pipelines and analytics for service decision-making.

Join a collaborative team in a hybrid role, with flexible hours. You will engage with PbR/Commissioning data, develop dashboards, and help ensure data quality and governance across care groups.