Principal Reporting Analyst

Job description

Job responsibilities

Service and Business Management

Responsible for ensuring the production and timely submission of information for monitoring activity together with those statutory returns that have been defined as pertaining to the business.

Responsible for ensuring that the clinical and operational analytic and reporting needs are satisfied to enable delivery of the clinical strategy.

Support analytics provision for Clinical/Corporate Divisions and any initiatives from an analytics perspective as deemed appropriate.

Have responsibility for providing service managers and other relevant managers with information, analysis and insight in response to ad-hoc requests, special projects and to provide specialist input into group projects.

Support providing evidence for any potential of horizon scanning within the group, or other relevant teams/personnel where the benefit will be realised within the group.

Proactively engaging with colleagues and other key contacts to achieve a shared understanding of information requirements and support the development of effective working relationships.

Producing a range of standard management reports and inputs to the development of new reports for varying audiences such as the Board and other relevant management boards and committees.

Developing routine and ad hoc reports presented in a clear, digestible, and useable format to meet the information requirements of the stakeholder(s).

Collating, analysing and interpreting clinical and management information from a wide variety of sources and across a range of operational services.

Managing projects where appropriate to develop and implement data collection processes and produce information to meet defined reporting and information requirements. Interrogating information systems using database query tools/reporting packages and creating complex queries to meet specific information requests.

Developing innovative ways of presenting highly complex information so that it is clear and understandable.

Developing and implementing training/facilitation packages on data sources, definitions, information and data analysis techniques, ensuring content and methods of delivery are appropriate to the various audiences.

Implementing processes to investigate data errors, identifying and analysing sources of variations or errors in information reports, monitoring and auditing data quality and working with services to improve the quality and integrity of the information in the Patient Administration System (PAS) with significant impact on patient care and finances.

Supporting managers and clinicians in their use and interpretation of information and promoting a culture of good data quality and effective use of information.

Sourcing information and keeping up-to-date on new data sources to support benchmarking and project work.

Regularly undertakes audits to measure/benchmark health outcomes and service indicators to identify variations or areas requiring improvement.

Ensuring information is processed in accordance with Information Governance Policy.

Continuously developing and improving knowledge and skills in a range of data analysis techniques and presentation

Representing the Information Department at any meeting that is deemed appropriate, contributing to outcomes and maintaining the reputation of the department

Proactively developing and maintaining effective liaison and communication with key stakeholders to provide an analysis function and ensuring requirements for information are met within an agreed framework.

Developing collaborative partnerships and effective working relationships with colleagues in other teams/directorates and healthcare organisations to deliver a cohesive approach to the provision and use of information.

Working with senior colleagues in shaping strategy and policy for the Information Service, promoting a culture of evidence based decision making. This will include identifying and proposing changes to information policies and procedures and working with cross-professional groups advising on new data collection

Undertaking other tasks as required by the Analytics and Visualisation Manager

Person Specification

Education, Training & Qualifications

• Educated to Masters degree level in a numerate/quantitative discipline or demonstrable equivalent experience and competencies in relevant or similar roles.
• Evidence of continuing professional development
• IT, Information or statistical qualification

• Management qualifications.
• Qualified at practitioner level of a recognised project management methodology

Knowledge & Experience

• Highly developed specialist knowledge of working with health information systems, with ability to keep fully informed about emerging technology through horizon scanning and networking.
• Knowledge of driving through change and developing an insight and analysis culture, moving from reporting the past to supporting future decision making
• In depth knowledge of MS office, Excel, Word, Access, Outlook etc.
• Highly developed specialist knowledge of MS SQL Business Intelligence tools.
• Create reports using appropriate tooling to summarise and analyse data from various sources, ensuring systems are adapted to reflect changes in data collected
• Knowledge and experience of understanding user needs, seeking feedback and user research methods to improve reporting, analytics and insight delivery
• Demonstrate the ability to plan, organise and prioritise workload according to the demands of conflicting and unpredictable requests.
• Experience of writing SQL queries for reporting- Complex correlated queries, sub-queries
• Working knowledge and experience of SPC charts, technical data models, writing DAX queries, creating calculations and measures, bespoke functions and integrating multiple data sources in Power BI

• Working knowledge and experience in R
• Working knowledge and experienced in python
• Experience of working within the agile methodology
• Extensive experience working in a Health Intelligence Role within the NHS

Skills

• Ability to use professional judgement and advise others on best practice, national guidelines and legislation on Information Management
• Proficiency in using SQL including complex correlated queries
• Proficiency the use of SQL Server Integration Systems (SSIS) and SQL Server Reporting Systems (SSRS)
• Proficiency in Microsoft products including advanced skills in Microsoft Excel
• Ability to undertake analytics writing to highlight key messages to relevant stakeholders

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.

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.

Employer details

Employer name

Northampton General Hospital

Address

Northampton General Hospital NHS Trust

Cliftonville

Northampton

NN1 5BD

https://www.northamptongeneral.nhs.uk/Home.aspx