Information Specialist

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

Do you want to join a team that uses healthcare data to help people live healthier, happier lives?

An opportunity has arisen to join the Business Intelligence Analytics Team within the Commissioning Intelligence Function.

This role will support the accurate reporting of clinical care delivered across care groups and billable functions. You will work across the data warehouse and analytics function to deliver high-quality data pipelines, platforms and analytics that inform service decision-making and support patient care.

You will join a collaborative, high-performing team where your work will make a real difference to patients, staff and the wider organisation. The team operates a hybrid working model, with flexible start and finish times to support work-life balance.

We are looking for someone with:

Workingknowledge of NHS payment mechanisms and SUS

Adegree in a relevant subject, or equivalent experience in an information ordata analyst role

Knowledgeof data warehousing methodology and the ability to support the development ofdata pipelines and platforms for reporting

The role is 37.5 hours per week, Monday to Friday.

Why join us? This is an exciting time to join Information Services as we continue to develop roles that support the Rotherham and Barnsley partnership. As part of a forward-thinking Business Intelligence team, you will have the opportunity to build on your existing skills while becoming a specialist in contracting and commissioning data.

Main duties of the job

This role will support the Rotherham-Barnsley Partnership by generating, analysing, and reporting data and KPIs related to the monitoring of activity and corresponding charging mechanisms for care delivered.

You will support the PbR/Commissioning Information Manager at TRFT with internal and external submissions, undertaking reporting and analysis, linked to financial delivery across the Care Groups. You will build, gather and interpret complex data from multiple sources, identify key messages, trends and issues, and present findings clearly to support decision-making, assurance and compliance.

There will be opportunities to maintain and develop the Microsoft SQL Server data warehouse, using ETL processes aligned to Kimball methodology and supporting data quality, performance, security and integrity. You will use DevOps and change control practices to deliver effective solutions.

We are looking for someone with strong attention to detail, analytical curiosity and the ability to communicate complex information clearly. You will mentor colleagues and promote best practice.

About us

The RotherhamNHS Foundation Trust (TRFT) is a combined acute and community Trust serving ourlocal population of around 270,000 people. Our vision is to always act theright way and be proud to provide exceptional healthcare to the communities ofRotherham

As a Trust weare on a journey to excellence and our people and culture are at the heart ofeverything we do for patients. In the latest NHS Staff Survey ,show progress in areas that matter most to staff. We have seen good results in how colleagues feel about health and wellbeing, alongside increased confidence that employees are recognised and supported

But don't justtake our word for it each year hundreds of colleagues receive nominations forour Excellence and Proud awards, showcasing our brilliant people andrecognising their achievements. Our people make a difference to the lives ofpatients 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 improveour services by upholding the Trusts values of Ambitious, Caring and Together.If you are passionate about making a difference, then please apply to join uson our journey to excellence

Certificates of Sponsorship

Please note that the Trustdoes not currently offer Skilled Worker visa sponsorship for this role.Applications are welcomed from candidates who can demonstrate an alternativeright to work in the UK.

Job responsibilities

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

Person Specification

Knowledge

• Expertise in Information Management, such as complex analysis and presentation of data from multiple sources, the creation of reports and analysis to support service improvements and awareness of performance levels.
• Working knowledge of NHS Payment mechanisms & SUS.
• Working knowledge of how to work with data contained within databases, to compile charts and visuals which support customer insight.
• Awareness of the NHS Key Performance Metrics and associated national reporting/policy requirements
• T-SQL Scripting, Views/Stored Procedures, Cursors and functions

Skills and abilities

• Advanced MS Office Skills eg Excel, Word, PowerPoint.
• Expertise in of one or more of the following BI/Analytical tools to extract, manipulate and interpret data: MS Excel, MS PowerBI, SQL.
• Ability to provide timely and relevant advice and guidance on reporting requirements including the appropriate definition, collection, validation and processing of complex sensitive, personal data.
• Attention to detail with a high level of accuracy and the ability to find key messages and trends within large and complex data sets.
• Ability to pre-empt and evaluate issues to provide appropriate
• Ability to present and discuss complex items with one or more people and clearly deliver key messages and concepts.

Planning and Organising

• Demonstrates an ability to prioritise own workload and responds appropriately to urgent and emergency situations.
• The ability to respond to sudden and unexpected changes in priorities.
• To plan, report and formulate relevant information and performance activity data and key performance indicators into the customer reports and commissioners.
• Ability to manage own workload without supervision to tight and changeable timescales.

Analytical and Judgement

• Analyses highly complex data obtained from several data sources in order to inform decision making.
• Ability to analyse numerical and written data, assess options and draw appropriate conclusions.
• Good judgement and problem solving skills when working in a pressurised environment.

Are you returning to the NHS following a mutually agreed resignation scheme (MARS) payment? Yes or No

• If yes, please note if you are returning within 6 / 12 months or before of the expiry date of the period for which you received compensation, then you will be required to repay any element of the compensation.

Qualifications

• Educated to Degree Standard in a relevant subject or equivalent experience of working at a similar level in a specialist information/ data analyst environment
• Evidence of relevant continued professional development, e.g. Microsoft Products, Team Leadership, Health and Social Care Policy.

Experience

• Experience of working within an Information/Data Management environment

£39,959 to £48,117 a yearper annum, pro rata