Data Analyst

Job Description

The RCPCH Research and Quality Improvement Directorate aims to promote evidence-based practice amongst paediatricians and child health professionals and improve the quality of care and health outcomes for children. The Research and Quality Improvement Directorate programme of work encompasses a range of activities, from supporting clinical leads and other RCPCH members/experts with the development of evidence-based guidance, to delivering high quality national audits and facilitating and supporting quality improvement activities.

The post holder will have responsibilities in three broad areas:

1. Manage the secure handling of complex audit datasets and the analysis of data with a primary focus on an audit programme.
2. Present findings of data analysis work to experts and work with the project team, including the audit clinical lead and senior data analyst
3. Produce reporting outputs at local, regional and national level, including the development of annual report key findings.

Responsibilities

Working across a designated audit programme and other RCPCH-delivered national audits to:

1. Create analysis plans and report structures in line with the agreed datasets, working closely with the project clinical leads, managers, senior data analyst and data platform suppliers.
2. Analyse data to produce unit, ICB, regional and national level results, identifying trends and outliers as defined by the agreed analysis plan and dataset requirements.
3. Establishing and maintaining robust data management, security and manipulation processes in line with data governance and protection requirements.
4. Support the production of reports aimed at different audiences such as clinicians, healthcare policy decision makers and patient stakeholders.
5. Produce data outputs for use by internal and external stakeholders including commissioners and regulators.
6. Act as a point of contact for audit data, technical and analysis enquiries from those submitting data for analysis.
7. Lead in the planning of analytical processes for planned data analysis projects.
8. Contribute to key components of departmental and project reports including interpreting the data analysis and writing editorial content. 
9. Support the development and enhancement of data capture software.
10. Any other duties as required to support the College, the work of the audits programme of work and Research and QI Division.

Desirable skills

Desirable

• Experience of working with any of R, R-studio, SAS, or SQL for cleaning, aggregating, recoding, and merging data, computing new variables, and producing descriptive statistics.
• Experience of working with Power Bi to present findings and data visualisations
• Experience of developing data export, outputs and dashboard reporting functions in data capture and processing platforms
• Experience of preparing data for presentation to healthcare commissioners and regulators at various levels of granularity of NHS organisations

Skills Required

Essential

• Undergraduate degree or equivalent experience, in a social or medical science, statistics, or other numerate discipline
• Experience of producing and presenting high quality written reports, documentation and promotional information suitable for a range of audiences
• Experience of working with Stata and Microsoft Excel for cleaning, aggregating, recoding, and merging data, computing new variables, and producing descriptive statistics.
• Experience of analysing large and complex datasets and applying appropriate advanced analytical methodologies including regression analysis.
• Strong analytical and problem-solving skills and experience, demonstrating the ability to understand and discuss complex issues around health and health related statistics
• Excellent interpersonal skills with the ability to quickly establish and maintain good working relationships with health professionals
• Ability to exercise discretion in dealing with confidential or sensitive matters, and be able to deliver difficult messages with diplomacy and tact
• High level of numeracy and ability to handle and interrogate large, complex datasets in Excel and statistical packages along with knowledge of statistical methods of analysis and data cleaning, processing and management
• Good attention to detail and high standards of accuracy.
• Strong IT skills, particularly in MS Excel, MS Word and MS PowerPoint

Educational Requirements

Essential

• Undergraduate degree or equivalent experience, in a social or medical science, statistics, or other numerate discipline

Information about the organisation for use across multiple jobs