HealthJobsUK

Detailed job description and main responsibilities

Data Warehouse & BI

• The post holder is responsible for the adaptation, support and development of the technologies and processes supporting the safe use of the Trust Data Warehouse & BI Platform (a major trust wide information system). Ensuring accurate data flows to support Trust Financial Reporting, Income Recovery, National Data Submissions and Internal reporting requirements.
• Provision of technical advice on all Data Warehousing and BI solutions within the Trust.
• To deputise for the Data Architect in all areas relating to support and maintenance of the Data Warehouse and related systems.
• Analyses, investigates and resolves complex queries, where there are a number of options; analyses user requirements which may require configuration of software and hardware
• Works to achieve agreed objectives and has freedom to do this in own way, working within broad professional policies; advises without reference to manager. Acts as a lead specialist in own area.
• Implements IM&T policies for own area and contributes to changes in BI policies and procedures for new reporting processes and BI delivery solutions which will impact throughout the Trust with responsibility to ensure written documentation is created and maintained
• Provides expert guidance and recommendations and will specify the best course of action to be taken where multiple options may exist, ensuring potential risk to patient care is kept to a minimum
• Responsible for managing the operations of delivery and storage of patient and staff identifiable information held within Trust developed BI solutions and the Data Warehouse. They are responsible for ensuring that the data is accurate, relevant, secure, auditable, and that data is suitably anonymised for use in BI solutions.
• Responsible for the speedy resolution of all non-routine problems with the Trust Data Warehouse, Integration Engine and BI solutions. This involves directly supporting the IT Service Desk, Support Analysts and the Trust’s senior managers and requires a proven ability to control and manage crisis and disaster situations.

Reporting

• To provide technical and practical support to members of the Information Services team as required, relating to all aspects of SQL development and the Data Warehouse environment.
• To provide support and advice to ad hoc requesters of information, in developing suitable report formats to meet their requirements.
• To work with other team members to ensure that all information supplied to customers is of the highest possible quality (completeness, accuracy), and to work at all times towards improving data quality in Trust Data Warehouse.
• To work with other members of both Informatics Services team, and with other stakeholders, to ensure that potential benefits of the data Warehouse in improvements in accuracy or timeliness of information or at a reduction in workload associated with the process are fully realized.
• To maintain a good understanding of the NHS Data Standards and Information Publications.

SUS and SLAM

• Responsible for the creation, development and operational maintenance of the SUS and SLAM processes ensuring the information is accurate and within the national tolerance limits for reconciliation purposes.
• Ensure there is a robust SUS/SLAM reconciliation process, proactively investigating any variance to provide assurance on data quality and consistency in both tariff and activity.
• Ensure SUS and HES reports are submitted in a timely fashion.
• Lead on ensuring there are validation reports for SUS, HES and SLAM by developing and maintaining a BI dashboard for SUS/SLAM/business plan as part of overall BI agenda
• Work closely with contracting to response to any queries raised in conjunction with the wider Information Services team. These can be contentious and opinions may conflict.

Communication and Relationships Skills

• The post holder must have the skills and experience to receive, interpret and communicate highly complex service related matters, at the highest level. This may be internal, external, written and/or verbal.
• Be able to communicate clearly and concisely to a wide range of groups at all levels throughout the Trust, e.g. business cases, national initiatives and Facilities Directorate issues
• The post holder will be required to communicate orally and in writing to the Trust Board and its delegated committees.

Patient/Client Care

• There may be incidental patient contact when users are trained, the BI solution is installed or during the planning cycle

Responsibilities for People or Training

• Responsible for delivering specialist training to other staff and organisations in all aspects of the Data Warehouse technical environment.
• Co-ordinates day to day allocation of work for junior team members
• Acts as key mentor to junior staff assessing abilities identifying any training / development needs.

Other Factors

• This role requires the ability to juggle complex issues whilst dealing with demands from Executive Directors, Clinicians and Senior Managers
• The role requires flexibility in approach with working hours with occasional evening and weekend working being required
• The role requires communication with external contacts of high profile
• High levels of concentration and mental effort required whilst handling frequent interruptions to answer complex queries from stakeholders and staff members
• The role is appropriate for flexible home working arrangements under some circumstances, to be determined by the BI Architect. There is a requirement to use VDU equipment more or less continuously on most days