Information Specialist @ The Rotherham NHS Foundation Trust

Job summary

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:

Working knowledge of NHS payment mechanisms and SUS

A degree in a relevant subject, or equivalent experience in an information or data analyst role

Knowledge of data warehousing methodology and the ability to support the development of data 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.

In return, you will join a supportive BI team with access to training and development. We welcome applications that show individuality, enthusiasm and a genuine interest in using data to improve healthcare and while you may use AI to support your application, we encourage you to show your individuality and enthusiasm for the role.

For further details, contact:[email protected]

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 ,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 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

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

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

Knowledge

Essential

• 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

Essential

• 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

Essential

• 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

Essential

• 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

Essential

• 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

Essential

• 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

Essential

• Experience of working within an Information/Data Management environment

Employer details

Employer name

The Rotherham NHS Foundation Trust

Address

Woodside Building

Moorgate Road

Rotherham

S60 2TY

United Kingdom

Employer's website

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