Report Developer

Pennine Care NHS FT; Ashton-under-Lyne; On-site; GBP 32,000 - 39,000; Full time

Job summary

Pennine Care NHS FT is seeking a Report Developer to join the Strategic Performance and Information service. The role focuses on statutory and corporate data submissions to NHS England, data validation, and delivery of dashboards for performance monitoring.

You will work with Power BI, Tableau, Excel, and SQL to produce accurate reports, support audits, FOIs, and improve data quality across the Trust. A strong attention to detail and effective communication are essential.

Qualifications

• Strong analytical and problem-solving skills.
• Experience with data visualisation and reporting tools (SQL, Excel, Power BI, Tableau).
• Knowledge of NHS reporting requirements and datasets is desirable.

Responsibilities

• Prepare and submit data for statutory reporting using Excel, Tableau, SQL.
• Develop internal dashboards and reports for performance monitoring.
• Maintain data quality and respond to information requests and audits.

Skills

Analytical skills

SQL queries

Communication skills

Numeracy

Power BI

Education

Degree or equivalent experience

Data analytics/health informatics study

Tools

SQL

Excel

Power BI

Tableau

Job description

Unfortunately this role does not attract sponsorship under current government legislation, therefore if you require a certificate of sponsorship to support a visa application, we will be unable to proceed with your application.

An exciting opportunity has arisen for an experienced Report Developer to join our newly established Strategic Performance and Information service.

In this role you will support delivery of statutory and corporate reporting requirements, including national data submissions to NHS England and other regulatory bodies.This includes assisting with data collection, validation, and reporting processes, and ensuring data quality and compliance with national standards.

The post holder will also be responsible for trouble shooting any data related issues that are escalated to the department and liaising with the wider team to ensure the issues are resolved and responded to.

You will support internal performance reporting, benchmarking submissions, and the development of data visualisations in collaboration with the wider reporting team.

You will have the ability to solve problems through effective questioning and investigation with a strong attention to detail and excellent communication and organisational skills.

Main duties of the job

• Develop and follow detailed procedures to prepare and submit data for all statutory and mandated reporting requirements ensuring statutory deadlines are met. This will involve using Microsoft Excel, Tableau and running SQL queries.
• Monitor internal information requests and provide initial triage and response.
• Participate in audits, FOIs, and ad-hoc information requests as required.
• Support the development and ongoing maintenance of the Trust's management information system (Power BI)
• Support the development of internal dashboards and reports for corporate performance monitoring using Excel, SQL, and Power BI.

About us

We are proud to provide high quality mental health and learning disability services, both inpatient and in the community across five boroughs of Greater Manchester - Bury, Oldham, Rochdale, Stockport and Tameside and Glossop.

We are proud of our#PennineCarePeopleand do everything we can to make sure we're a great place to work.

All individuals regardless of race, age, disability, ethnicity, nationality, gender, gender reassignment, sexual orientation, religion or belief, marriage and civil partnership are encouraged to apply for this post. We would also encourage applications from individuals with a lived experience of mental illness, either individually or as a carer.

If you come and work for us we will offer a range of benefits and opportunities, including:

• Generous annual leave entitlement for Agenda for Change and Medical and Dental staff.
• Flexible working opportunities to support your work/life balance
• Access to Continued Professional Development
• Involvement in improvement and research activities
• Health and Wellbeing activities and access to an excellent staff wellbeing service
• Access to staff discounts across retail, leisure and travel

Job responsibilities

Develop and follow detailed procedures to prepare and submit data for all statutory and mandated reporting requirements ensuring statutory deadlines are met. This will involve using Microsoft Excel, Tableau and running SQL queriesWork with senior analysts and corporate leads (e.g. HR, Finance, Digital) to gather, validate, and format data for submission.Maintain internal trackers and reporting templates to support timely and accurate submissions.Support the development of internal dashboards and reports for corporate performance monitoring using Excel, SQL, and Power BI.Collaborate with data visualisation leads to design and refine dashboards and visual outputs that communicate key performance insights clearly and effectively.Ensure data quality by identifying anomalies, performing validation checks, and escalating issues as needed.Interpret national guidance and support the translation of requirements into local data collection processes.Support the continued development and support the Trusts management information system (Power BI/ Tableau) to ensure that this is aligned to the business requirements of the Trust and all appropriate reports/dashboards are developed to identified specifications within the given timescales.Maintain documentation of data definitions, processes, and submission schedules.Contribute to continuous improvement of reporting processes and toolsProvide support and training across organisation in relation to data analysis and interpretationParticipate in audits, FOIs, and ad-hoc information requests as required.Process highly sensitive data according to Information Governance requirementsMonitor internal information requests and provide initial triage and responseMaintain external reporting register and external information requests processPerform Tableau/ Power BI administration tasks such as user management, the creation of scheduled jobs, executing stored procedures and monitoring performance

Person Specification

Education /Qualifications

• oEducated to degree level or equivalent experience
• oFurther study in data analysis, data science statistics, or health informatics

Experience

• oExperience working in a data visualisation, reporting or in an information role, ideally within the NHS or a healthcare setting.
• oExperience of working with large and complex datasets.
• oExperience using analytical tools and software such as SQL, Excel, Power BI, or similar.
• oExperience of using and creating reports using Tableau (or similar business intelligence/data visualisation tools)

Knowledge

• oKnowledge of NHS reporting requirements and submissions
• oClear understanding of NHS performance targets and healthcare datasets is desirable

Skills and Abilites

• oStrong analytical and problem-solving skills
• oAbility to write and optimise SQL queries.
• oHighly numerate and analytical
• oExcellent written and verbal communication skills.
• oProficient in the use of business intelligence systems inc Tableau/PowerBI
• oAbility to work autonomously and without direct supervision, within defined procedures and parameters
• oAbility to solve problems through effective questioning and investigation.
• Demonstrates trust values and behaviours
• oExcellent diary and highly developed time management skills with the ability to re-prioritise and adjust work as required to meet competing demands

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.

£32,073 to £39,043 a yearper annum, pro rata