EHR Senior Reporting Analyst

Job overview

We have an exciting opportunity to join the Information Technology Clinical Systems (ITCS) reporting team working on innovative analytics and reporting solutions from our new Epic EPR. The role is shared across Guy's and St Thomas' NHS Foundation Trust (GSTT) and King's College Hospital NHS Foundation Trust (KCH) and is ideal for a person who has an understanding of NHS data and wants to become an expert in Epic’s analyst tools to deliver the benefits of data-enabled healthcare.

Main duties of the job

The successful candidate will work as part of a team of analysts supported by an application manager. Key responsibilities include:

· Analysis of business requirements in order to develop end to end reporting solutions using Epic’s Cogito (analytics) tools;

· Provide analytical support and guidance to operational and management teams, relating to Cogito reports, self-service reporting tools and the underlying data structures;

• Analyse, design and implement solutions for problems or issues with Cogito reports and dashboards
• · Producing tip sheets and documentation; and facilitating other information teams' use of Epic reporting tools.
• · Supporting Epic upgrades;

Please note that candidates who do not hold a current Epic certification will be required to undertake and pass an online Epic Sphinx assessment once shortlisted as an interview pre-requisite

Working for our organisation

King’s College Hospital NHS Foundation Trust is one of the UK’s largest and busiest teaching Trusts with a turnover of c£1.8 billion, 1.5 million patient contacts a year and more than 15,000 staff based across South East London. The Trust provides a full range of local and specialist services across its five sites. The trust-wide strategy of Strong Roots, Global Reach is our Vision to be BOLD, Brilliant people, Outstanding care, Leaders in Research, Innovation and Education, Diversity, Equality and Inclusion at the heart of everything we do. By being person-centred, digitally-enabled, and focused on sustainability, we aim to take Team King’s to another level.

We are at a pivotal point in our history and we require individuals who are ready to join a highly professional team and make a real, lasting difference to our patients and our people.

King’s is committed to delivering Sustainable Healthcare for All via our Green Plan. In line with national Greener NHS ambitions, we have set net zero carbon targets of 2040 for our NHS Carbon Footprint and 2045 for our NHS Carbon Footprint Plus. Everyone’s contribution is required in order to meet the goals set out in our Green Plan and we encourage all staff to work responsibly, minimising their contributions to the Trust’s carbon emissions, waste and pollution wherever possible.

Detailed job description and main responsibilities

The Senior Reporting Analyst role is joint across KCH and GSTT. The two Trusts share a Chief Digital Information Officer (CDIO) and a vision for digital services that are lean and agile, that maximise the benefits of a shared service operating model, and deliver the digital ambition for both Trusts. This ambition is supported by a forward-looking and strategic approach, and significant investment in a new Electronic Health Record (EHR) which will catalyse a programme of work across both Trusts to transform the way technology and data is used across our services.

The successful applicant will develop NHS operational and clinical reporting from Epic Cogito front-end tools, Reporting Workbench, Radar, and SlicerDicer, as well as by querying our Caboodle data warehouse using SQL. To achieve this they’ll work closely with the ITCS teams which support Epic applications; informatics departments in partner organisations; data warehouse teams; and end-users across every staff group to provide advice and guidance, develop reports and analytics solutions in Epic and to support using the Cogito tools. Furthermore, they will engage in a team-based development process designed around agile methodologies and collaborate in a formal system of change management to enable safe transition of information products and systems from design to operation.

Understanding of NHS operations and Trust data needs are essential to this role.

Obtaining and maintaining Epic accreditation in the Cogito module is essential. If you do not have a Cogito accreditation, you will be expected to obtain one within the first few months in this role.

Please note this role requires hybrid working and will necessitate travel between Guy's and St. Thomas', King's College Hospital and Royal Brompton and Harefield sites.

Person specification

Education and Qualifications

Essential criteria

• Educated to degree level in an Informatics related subject or substantial equivalent experience within a Health Informatics role
• Specialist training in Microsoft SQL Server Management Studio
• Specialist training in Data visualisation tools e.g. Microsoft Power BI, Qlikview

Desirable criteria

• Master’s degree in an Informatics related subject
• Epic Cogito Certification in one or multiple data models

Knowledge and Experience

Essential criteria

• Substantial experience in an Informatics or Analytics role
• Experience of working in an acute hospital, community provider, Clinical Commissioning Group or other healthcare related organisation
• Broad experience of using information derived from large and complex data sets
• Experience of data requirements gathering and report specification documentation
• Substantial experience of developing complex datasets and information systems to meet with complex and changing customer requirements
• Experience of communicating complex reporting issues to a wide range of stakeholders, including NHS managers, clinicians and partner organisations
• Experience of supporting a wide range of stakeholders to effectively use and to build their knowledge of reporting tools and analytic outputs
• Experience of writing relational and multidimensional SQL queries
• Substantial experience of designing and developing reporting and analytical outputs using appropriate enterprise BI tools (Business Objects, Microsoft SQL Server Reporting Services, PowerView, Tableau, QlikView, Power BI etc.)
• Experience of report testing tools and methodologies
• Experience of leading projects, including use of project plans and identifying risks

Desirable criteria

• Experience working with NHS acute or community datasets
• Experience of authoring high quality technical and user documentation to support the adoption and further development of Information solutions
• Experience of writing complex SQL stored procedures
• Experience of supervising staff and/or project teams

Skills and Competencies

Essential criteria

• Detailed knowledge & understanding of Health Informatics – including healthcare datasets, data quality, performance monitoring, national strategic control mechanisms for data management, definitional guidance & data protection
• Excellent understanding of the principles of Analysis, benchmarking and highly developed modelling and data manipulation
• Knowledge of data driven improvement methodologies
• Knowledge of report development software and techniques
• Good information presentation skills, evident in use of graphics and design of reports
• Ability to plan ahead and anticipate potential problem areas, devising and implementing appropriate solutions
• A working knowledge of the Microsoft SQL Server product, including its services and their use
• Comprehensive understanding of information governance rules relating to health data
• Ability to confidently manage and facilitate meetings and workshops
• Excellent interpersonal skills and team working/building skills
• Ability to provide and receive highly complex, sensitive or contentious information
• Ability to negotiate with senior stakeholders on difficult and controversial issues, and present complex and sensitive information to large and influential groups
• Ability to negotiate on difficult and controversial issues including performance and change

Desirable criteria

• Understanding of latest developments in NHS statutory and mandatory reporting and good understanding of NHS information and performance monitoring systems
• Knowledge of medical terminology
• Detailed knowledge and understanding of NHS administrative processes and systems
• Understanding of techniques for database design, management and interrogation including the use of SQL
• Knowledge of Epic Cogito suite of tools including Caboodle, Clarity, Radar, Reporting Workbench and Slicer Dicer

IMPORTANT

• Check your email account regularly as this is how we will communicate with you
• If you delete the job from any of your accounts, you may be prevented from accessing further communications
• To enquire about your application or inform us of any changes in your circumstances, please contact the named person on this advert
• Please provide email addresses for referees where possible
• Please review the documentation on our recruitment microsite, particularly the Trust’s criminal records checking policy
• All staff have a responsibility for safeguarding children and vulnerable adults and for ensuring they are aware of the specific duties relating to their role.
• Please note that the closing date is given as a guide. On occasion, we might close a vacancy early due to a high number of applications being received. You are advised to submit your application as early as possible to avoid disappointment.

King's College Hospital NHS Foundation Trust Annual Reports and Other Corporate Publications

King's Health Partners Academic Health Science Centre Website

King's College Hospital is part of King's Health Partners Academic Health Sciences Centre (AHSC), a pioneering collaboration between King's College London, and Guy's and St Thomas', King's College Hospital and South London and Maudsley NHS Foundation Trusts.