Senior Analyst - Report Writer

Job overview

Do you have a passion for creating reports and dashboards for improving access to data and information in Healthcare?

We're seeking a highly skilled Senior Analyst - Report Writer to join our team. You will lead on the reporting requirements for large scale digital transformation projects in the trust. Working closely with reporting specialists, senior leadership and digital system analysts to ensure the reporting function in our digital systems meet the dynamic needs of clinicians, administrators, patients and the wider NHS.

We are looking to recruit an enthusiastic individual with a keen interest & experience in writing complex SQL code as well as a strong knowledge of NHS definitions and Standards. Equally as important to these skills will be your understanding of clinical and administration workflows and processes within an acute Trust.

Main duties of the job

Provide senior operational, technical and professional support for Epic reporting, analytics, data warehouse reporting and associated self-service reporting tools. Lead on reporting aspects of large scale digital transformation projects.

Work with the CCIO, Design Authority, Information Management leadership, application teams, operational services and transformation teams to ensure that reporting and analytics are embedded into Epic. Improve the reporting products that underpin clinical, operational, statutory, financial and research-related decision-making and support optimisation, service redesign and benefit realisation activity.

Take responsibility for the design integrity, governance, validation and optimisation of reporting content across Epic reporting tools and associated business intelligence platforms, including Clarity, Caboodle, Cogito SQL, Reporting Workbench, Radar, SlicerDicer, QlikView and successor technologies.

Provide expert advice to senior clinicians, operational managers, Digital Services leadership, corporate teams and external partners on information requirements, reporting feasibility, data quality, definitions, data models and system capability.

Working for our organisation

Our Trust

Cambridge University Hospitals (CUH) NHS Foundation Trust comprises Addenbrooke's Hospital and the Rosie Hospital in Cambridge. With over 13,000 staff and over 1100 beds the priorities of the Trust focus on a quality service which is all about people - patients, staff and partners. Recognised as providing 'outstanding' care to our patients and rated 'Good' overall by the Care Quality Commissioner, is testament to the skill and dedication of the people who work here. CUH's values - Together - Safe, Kind, Excellent - are at the heart of patient care, defining the way all staff work and behave. The Trust provides accessible high-quality healthcare for the local people of Cambridge, together with specialist services, dealing with rare or complex conditions for a regional, national and international population.

CUH is committed to promoting a diverse and inclusive community - a place where we can all be ourselves. We value our differences and fully advocate and support an inclusive working environment where every individual can fulfil their potential. We want to ensure our people are truly representative of all the communities that we serve. We welcome applications for all positions in the organisation irrespective of people's age, disability, ethnicity, race, nationality, gender identity, sex, sexual orientation, religion or belief, marriage and civil partnership status, or pregnancy and maternity status or social economic background.

Person specification

Qualifications

Essential criteria

• Educated to master's level or equivalent specialist experience in digital, informatics, information management, computer science, analytics, statistics or a related discipline.
• Epic Cogito certification or accreditation
• Evidence of continued professional development. Advanced SQL, database, analytics or business intelligence training or equivalent experience

Desirable criteria

• Project management qualification or equivalent experience, e.g. PRINCE2, Agile or MSP
• Leadership or management qualification

Experience

Essential criteria

• Significant experience of working with Epic EPR, EPR reporting, NHS digital systems or complex healthcare information systems
• Experience of designing, building, validating and maintaining complex reports, dashboards, extracts or analytical products
• Experience of using SQL to query complex data structures, create views, stored procedures or reporting datasets
• Experience of engaging senior clinical, operational and technical stakeholders to define requirements and implement solutions
• Experience of managing competing priorities and delivering to tight deadlines in a complex environment
• Experience of using CLARITY and CABOODLE to create reports and extracts for a wide audience

Desirable criteria

• Experience with QlikView, Power BI or other business intelligence platforms
• Experience of national reporting, statutory submissions, NHS performance reporting or large-scale data quality improvement
• Experience of supporting Epic upgrades, regression testing or data model change assessment
• Experience of ETL processes to move data between databases

Knowledge

Essential criteria

• Expert understanding of the role of reporting and analytics in supporting clinical care, operational management, performance monitoring and strategic decision-making
• Detailed knowledge of NHS data definitions, information standards, data quality principles and reporting governance
• Knowledge of information governance, confidentiality, data protection and safe use of patient-identifiable information
• Understanding of clinical and administrative workflows within an acute hospital environment

Desirable criteria

• Knowledge of Epic application build and workflow dependencies
• Knowledge of clinical safety, digital change management and benefits realisation approaches
• Understanding of AI-assisted analytics / automation governance where relevant to reporting and information management

Skills

Essential criteria

• Advanced SQL query writing and analytical problem-solving skills
• Ability to interpret complex technical, clinical and operational requirements and convert them into clear reporting specifications
• Ability to communicate complex technical concepts to non-technical audiences
• Skills in dashboard design, visual analytics, self-service analytics governance and user-centred reporting design
• Ability to analyse complex information, identify data quality issues and recommend practical solutions
• Highly organised, with ability to plan and prioritise large volumes of work across multiple services
• Ability to lead, motivate and develop staff

Desirable criteria

• Presentation and facilitation skills for senior multidisciplinary groups
• Experience of creating SSIS packages for automation
• Negotiation and influencing skills in complex stakeholder environments
• Excellent written communication skills, including production of specifications and technical documentation

Additional Requirements

Essential criteria

• • The ability to understand and behave at all times, towards patients, visitors and colleagues according to the Trust values of safe, kind, excellent. (A/I)
• • Willingness to work flexibly to support upgrades, testing, incident response and major system changes. (AI)
• • Ability to work independently and make decisions within broad policy and governance frameworks. (AI)
• • High level of accuracy, attention to detail and professional integrity. (AI)
• • Commitment to equality, diversity, inclusion and respectful working relationships. (AI)

Desirable criteria

• • Ability to support cross-cover across related Epic or information management functions. (AI)

Documents to download

• Applicant Information Pack (PDF, 184.7KB)
• Completing your application - Information for applicants (PDF, 222.9KB)