Job overview
An exciting opportunity has arisen for an experienced Report Developer to join our newly established Strategic Performance and Information service for a period of 18 months.
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/ Tableau)
* Support the development of internal dashboards and reports for corporate performance monitoring using Excel, SQL, and Power BI.
Working for our organisation
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.
Our vision is for a happier and more hopeful life for everyone in our communities and our staff work hard to deliver the very best care for the people who use our services. We’re really proud of our #PennineCarePeople and 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
Detailed job description and main 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 queries
· Work 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 Trust’s 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 tools
· Provide support and training across organisation in relation to data analysis and interpretation
· Participate in audits, FOIs, and ad-hoc information requests as required.
· Process highly sensitive data according to Information Governance requirements
· Monitor internal information requests and provide initial triage and response
· Maintain external reporting register and external information requests process
· Perform Tableau/ Power BI administration tasks such as user management, the creation of scheduled jobs, executing stored procedures and monitoring performance
Analysis and Data Management
· Analyse complex information to identify and solve a range of problems and support statistical report purposes (e.g. data quality issues, system errors, unexpected variation etc) to ensure understanding and remedial actions are undertaken as necessary.
· Identify the most appropriate data solutions using a range of data sources, analysis and resolution of complex data queries and discrepancies.
· Use basic analysis techniques to present findings from a received problem or information request
· Understand the complex data structures within the data warehouse to have an understanding of the products the team have produced so that you can provide end user support.
· Understand and translate basic SQL to aid issue resolution
Governance and Compliance
· Ensure compliance with data governance, GDPR, and confidentiality policies
· Assist in the development and documentation of data standards, definitions and metadata for consistent data use.
Communications and Leadership
· Provide and receive highly complex information regarding report development.
· Establish working relationships with the key operational, corporate and support staff representing that require data and analysis for decision making
· Work closely with clinical and corporate teams to promote use of data using Tableau /Power BI reports and dashboards, to manage performance and inform decision making.
· Promote the use of data across the Trust so that data is recognised as a key enabler for service development and improvement
· Provide specialist advice and training to groups of staff on how to use Tableau/Power BI
· Communicate effectively with all departments and external agencies to facilitate optimum efficiency (i.e. statutory bodies in relation to any challenges with submissions)
· Liaise with application suppliers and IT department on resolution of hardware, communications and networking problems.
· Interact with others in order to achieve the objectives or purpose of the post. This will range from co-operating with other team members to multi-agency working.
· Work as a full member of the Team in the planning and delivery with regard to the management of Tableau and associated systems
· Work as part of a development team using techniques from agile project management to deliver Trust critical projects where required.
Person specification
Education /Qualifications
Essential criteria
* •Educated to degree level or equivalent experience
Desirable criteria
* •Further study in data analysis, data science statistics, or health informatics
Experience
Essential criteria
* •Experience working in a data visualisation, reporting or in an information role, ideally within the NHS or a healthcare setting.
* •Experience of working with large and complex datasets.
* •Experience using analytical tools and software such as SQL, Excel, Power BI, or similar.
Desirable criteria
* •Experience of using and creating reports using Tableau (or similar business intelligence/data visualisation tools)
Knowledge
Essential criteria
* •Knowledge of NHS reporting requirements and submissions
* •Clear understanding of NHS performance targets and healthcare datasets is desirable
Skills and Abilites
Essential criteria
* •Strong analytical and problem-solving skills
* •Ability to write and optimise SQL queries.
* •Highly numerate and analytical
* •Excellent written and verbal communication skills.
* •Proficient in the use of business intelligence systems inc Tableau/Power BI
* •Ability to work autonomously and without direct supervision, within defined procedures and parameters
* •Ability to solve problems through effective questioning and investigation.
* Demonstrates trust values and behaviours
* •Excellent diary and highly developed time management skills with the ability to re-prioritise and adjust work as required to meet competing demands
📝 Application support - We also offer virtual application support sessions each month, where you will learn some hints and tips to support you in completing your application form. To secure your place, and to find out more visit the on our website.
🌍 Sponsorship Information - We are an approved sponsoring organisation. Applications will be considered from applicants requiring sponsorship alongside all other applications. Please be aware, not all roles are eligible for sponsorship. You can review the list of eligible role and requirements on the
📬 After You Apply - Once your application is submitted, you’ll receive updates via email. Shortlisting is based on how well you meet the criteria outlined in the person specification. Only shortlisted candidates will be invited to interview, and invitations will be sent by email.
✅ If You're Offered the Role - If successful, the hiring manager will contact you directly with a verbal offer. They will then notify the Recruitment Team and submit the necessary paperwork. You’ll receive a formal conditional offer via email
🔍 Pre-Employment Checks - To confirm your suitability for the role, we will carry out pre-employment checks in line with. These include:
* Identity verification
* Right to work check
* Disclosure and barring service (DBS)/Criminal record check (dependent on role)
* Professional registration and/or qualification check
* Occupational health assessment
* Employment history and reference validation
All applicants external to Pennine Care NHS Foundation Trust will be required to provide their to cover the most recent three years employment. This information will used to validate employment history and references.
If you require sponsorship, we will assess your eligibility based on current If the role is not eligible and you cannot demonstrate your right to work, your conditional offer may be withdrawn.
🚀 Once Checks Are Complete -
The Recruitment Team will coordinate with you and the hiring manager to confirm a start date. You’ll be booked onto a Trust Welcome Session and receive your Pennine Care NHS Terms and Conditions.
📣 Additional Information -
We are committed to equality, diversity, and inclusion (EDI), and we strive to ensure our workforce reflects the communities we serve. We actively encourage applications from individuals of diverse backgrounds to help us grow, innovate, and improve.
If you wish to be considered under the Disability Confident Scheme, you will be guaranteed an interview if you meet the essential criteria for the role.
If you need reasonable adjustments during the recruitment process, please contact us on 0161 716 3181 as early as possible so we can support you.
Please note:
* We do not accept unsolicited contact from recruitment agencies. Hiring managers should not be contacted directly.
* We may close vacancies early if we receive a high volume of applications. To ensure your application is considered, please apply as soon as possible.