Report Developer

Job description

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

• oEducated to degree level or equivalent experience

Desirable

• oFurther study in data analysis, data science statistics, or health informatics

Experience

Essential

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

Desirable

• oExperience of using and creating reports using Tableau (or similar business intelligence/data visualisation tools)

Knowledge

Essential

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

Skills and Abilites

Essential

• 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/Power BI
• 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.

Certificate of Sponsorship

Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab).

From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab).

UK Registration

Applicants must have current UK professional registration. For further information please see NHS Careers website (opens in a new window).

Employer details

Employer name

Pennine Care NHS FT

Address

Trust HQ

225 Old Street

Ashton Under Lyne

OL7 7SR

Employer's website

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