Database Programmer/Analyst (XN04)

Job description

Job responsibilities

JOB PURPOSE/SUMMARY

The Childrens Liver and GI Unit is one of three specialist units in the United Kingdom dedicated to Hepatology and Complex Hepatobiliary care all of which are funded by the Highly Specialised Commissioning Team which funds £8.9 million towards Paediatric liver disease services across the 3 units and a further £8.5 solely towards Paediatric liver transplantation. Currently the unit averages transplants per year and provides a Paediatric Liver service to centres from Nottingham to Glasgow. The purpose of this post is to manage, maintain and update the Childrens Liver and HPB Unit Database in order to provide an efficient data provision service providing both the Liver Team and National Committees instant and selective access to its patients clinical and demographic details. It involves reporting to national bodies such as the Highly Specialised Commissioning Team and NHS England to document activity. The Unit must document its performance against set targets as a justification for its funding. It also involves MDT Coordination within team and to external centres to ensure safe delivery of service. In particular, the recording of all patient activity associated with the Unit must be managed and extrapolated in accordance with Highly Specialised Commissioning Team Reports.

Database Management

The post primarily involves management of the Units Database by recording the activity of all patients referred to the Unit. This involves adding all admissions to the ward, all outpatient appointments across the Units and any other Liver and complex hepatobiliary work involving outlying patients on a weekly basis. This data is extrapolated on a weekly basis for consultation with the Consultants and Junior Doctors and on a monthly basis to provide Finance and Highly Specialised Commissioning Team with data of the Units activity through their Service Monitoring proforma. We would also expect this post holder to have an interest in quality improvement and audit to work with the Consultant body to improve efficiency in current systems.

MDT Coordinator

This role involves attendance, organisation and feedback to relevant external centres regarding outcomes of multidisciplinary meetings. The MDT coordinator role shares overlap with database management. This role will also include organisation of multicentre national meetings for Liver Steering Group, HPB multicentre meetings and educational meetings for stakeholders.

4. PRINCIPAL DUTIES & AREAS OF RESPONSIBILITY

Data Management

Overall Database Management (able to provide regular integrity checks, adding new patients daily; accurate recording of diagnosis, procedures and understanding of coding)

Undertake complex data tasks as defined by the needs of NHS England, Highly Specialised Commissioning Team and Liver & HPB team with the ability to provide technical support as required.

Updating Admissions and Outpatient appointments on a weekly basis

To lead in redesign of a new Database to accommodate recent change in IT systems and the needs of Consultants and other medical staff for research, national reporting.

Performing Queries to extrapolate data on both weekly and monthly basis for outpatient and admissions meetings which contributes to Out of England Patient/GP reports, activity coding, month end activity, waiting list report, assessed not listed report, Commissioning and NHS England Returns reports.

Provide submission to UK Liver Transplant Audit to NHSBT (3 month and annual data)

Produce Summary figures for a six month interim within and at the end of the financial year.

Supports and performs specific queries as and when requested by the Liver Team against the requested criteria (to support Governance, morbidity and mortality and on-going research).

Preparation and analysis of data for others to present.

Maintains Database for Transition service - to ensure meeting and promoting RCPCH standards.

Maintains Database for high cost CCG approved prescriptions - Blueteq

Support any business case proposals required for the development and improvement of services throughout region by providing appropriate data (ie. Repatriation of medicines)

Collection of renal data for submission to BHLY on both renal transplant and chronic renal failure patients

Attendance at monthly renal transplant listing meeting

External National Reporting

Complete Highly Specialised Service Monitoring reports and liaise with Finance to confirm all activity is accounted for on the PAS System and submit back. Refer returns to lead clinician along with a monthly breakdown

Provides reports as required by UKHSA (in cases of emergency)

UK Liver Transplant Audit to NHSBT (3 month and annual data)

NHS England Returns

MDT Coordinator

Meetings

Attend Internal Audit meeting once a week collect and confirm new referrals and diagnosis details, confirm patient diagnoses, capture Consultant involvement with outlying patients on other wards/units

Attend business meeting once a month to remain informed on current events and developments of the Unit

Attend Multi-disciplinary meeting once a week to keep abreast of developments in all inpatients activity which may have implications on information needing updating or adding to the database such as kasai operations and transplantations

Attends, organises, provides minutes and follow up actions for Radiology MDT (two meetings a week); Vascular MDT (once a month); Transplant Listing Meeting (once a week); Histopathology meeting (every two weeks); Internal Audit meeting (once a week); Liver Transplant & HPB MDT (every 4 months), Multicentre National HPB meeting (every 4 months).

Organisation of Annual Educational meeting for stakeholders

Supports Morbidity & Mortality meetings and works with consultants towards quality improvement and innovation projects.

Core Values

The post holder is expected to appreciate the importance of a competent and thorough approach to patient care and be committed to providing an efficient data and MDT coordinator service to best support the Liver & HPB Teams delivery of such patient services. This approach should be conducted in a manner which upholds the Leeds Way Values (patient-centred, collaborative, fair, accountable and empowered).

Core Behaviours and Skills

The post holder will be enthusiastic and pro-active at providing a data management service both flexibly and efficiently to supply medical staff with specific data requests for research purposes and audits. They will be methodological and thorough in the extraction and presentation of such data.

Core Knowledge and Understanding

The post holder is required to have experience of working in a hospital setting or an office based environment involving administrative systems. They should be IT proficient with an understanding of Microsoft Office. In particular, a good understanding and working knowledge of Microsoft Access and Excel is particularly important whereby the post holder should have a competent understanding and basic experience of the concept and configuration of a database. The post holder will be expected to extract data from Microsoft Access and export to Excel to analyse and produce summary statistics at an interim of six months and at the end of the financial year.

THE LEEDS WAY VALUES

Our values are part of what make us different from other trusts, so we see this as a strength, as well as a responsibility. They have been developed by our staff and set out what they see as important to how we work. Our five values are:

Patient-centred

Collaborative

Fair

Accountable

Empowered

All our actions and endeavours will be guided and evaluated through these values

Additionally, the following are core values which relate specifically to this post:

The beliefs and attitudes that underpin effective performance within the job role. Emphasis should be on the requirements of the role not the individual when completing this section. Examples might include: quality focus, mistakes are used as a continual learning experience, honesty, integrity etc.

WEST YORKSHIRE ASSOCIATION OF ACUTE TRUSTS (WYAAT)

Leeds Teaching Hospitals NHS Trust is part of the West Yorkshire Association of Acute Trusts (WYAAT), a collaborative of the NHS hospital trusts from across West Yorkshire and Harrogate working together to provide the best possible care for our patients.

By bringing together the wide range of skills and expertise across West Yorkshire and Harrogate we are working differently, innovating and driving forward change to deliver the highest quality care. By working for Leeds Teaching Hospitals NHS Trust this is your opportunity to be a part of that change.

WYAAT is the acute sector arm of the West Yorkshire and Harrogate Health and Care Partnership, one of the largest integrated care systems in the country. The Partnerships ambition is for everyone to have the best possible health and wellbeing, and the work of WYAAT, and each individual trust, supports that ambition.

INFECTION CONTROL

The jobholder must comply at all times with the Leeds Teaching Hospitals NHS Trust Infection Control policies, in particular by practising Universal Infection Control Precautions. Hand hygiene must be performed before and after contact with patients and their environment.

HEALTH AND SAFETY / RISK MANAGEMENT

All staff are responsible for working with their colleagues to maintain and improve the quality of services provided to our patients and other service users. This includes complying at all times with the Leeds Teaching Hospitals NHS Trust Policies, including Health and Safety policies.

Person Specification

Skills & Behaviours

Essential

• Professional attitude towards work upholding confidentiality
• Adhere to Childrens Services Policies and Procedures
• Ability to multitask in busy environment
• Empathetic and non-judgemental approach to patients and families

Desirable

• Previous Secretarial background

Experience

Essential

• Administrative experience
• Ability to make design changes to the database to assist the capture of patient information
• Ability to present data and summary statistics

Desirable

• Experience of working in complex hospital teams
• Experience in quality improvement
• Previous experience as an MDT Co-ordinator

Qualifications

Essential

• Experience with Microsoft Access or other database software
• Evidence of competent numeracy and literacy skills
• Be proactive in undertaking training relevant to the development of the post where necessary
• Standard keyboard skills

Desirable

• Previous Patient Access System (PAS)
• Medical Terminology

Additional requirements

Essential

• Good interpersonal skills
• Able to work on own initiative within agreed guidelines

Employer details

Employer name

Leeds Teaching Hospitals

Address

Leeds General Infirmary

Great George Street

Leeds

LS1 3EX

Employer's website

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