Report Developer

PENNINE CARE NHS FOUNDATION TRUST; Ashton-under-Lyne; On-site; GBP 30,000 - 40,000; Full time

Job summary

An NHS Trust in Ashton-under-Lyne is seeking a Report Developer for an 18-month position to ensure data compliance and support reporting processes. The role involves using tools like Excel, SQL, and Power BI for data validation and visualization. The ideal candidate will possess strong analytical and problem-solving abilities, communicate effectively with teams, and assist in delivering statutory reporting requirements. Applications are welcome from diverse backgrounds, promoting equality and inclusion.

Qualifications

• Experience in data collection, validation, and reporting processes.
• Experience with performance reporting and data visualizations.
• Ability to collaborate effectively with teams.

Responsibilities

• Develop and maintain reporting procedures for statutory requirements.
• Collaborate with teams to validate and format data.
• Ensure data quality and compliance with standards.
• Support development of internal dashboards and reports.

Skills

Attention to detail

Effective communication

Problem-solving

Data analysis

Organizational skills

Tools

Microsoft Excel

Power BI

Tableau

SQL

Job description

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.

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 troubleshooting any data related issues 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.

– 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.

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 alignment with business requirements and that reports/dashboards are developed to identified specifications within timescales.
• Maintain documentation of data definitions, processes, and submission schedules.
• Contribute to continuous improvement of reporting processes and tools.
• Provide support and training across the 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, creation of scheduled jobs, executing stored procedures and monitoring performance.
• 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) 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 key operational, corporate and support staff requiring 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 (e.g. 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 to achieve the objectives of the post, including collaboration with team members and multi-agency work.
• Work as a full member of the Team in planning and delivery regarding management of Tableau and associated systems.
• Work as part of a development team using agile project management techniques to deliver Trust-critical projects when required.

Application and Additional Information

• We are an approved sponsoring organisation. Applications will be considered from applicants requiring sponsorship alongside all other applications. Some roles may not be eligible for sponsorship.
• Pre-Employment Checks will be conducted in line with NHS Employment Check Standards, including identity verification, right to work, DBS/criminal record check (dependent on role), professional registration/qualification check, occupational health assessment, and employment history/reference validation.
• All external applicants will be required to provide HMRC employment history for the most recent three years.
• We encourage applications from diverse backgrounds and support equality, diversity and inclusion.
• If you require reasonable adjustments during the recruitment process, please contact us early so we can support you.