Information Systems Analyst

Job description

Job responsibilities

To act as the Database Administrator for the Trust data warehouse:

To be responsible for monitoring and maintaining the operational function of the data warehouse daily e.g. ensuring that all data extracts and automated imports have successfully completed

To be responsible for the loading of reference and other data into the data warehouse in a timely manner.

To act as a first point of contact for all enquiries regarding the Data Warehouse and to take the lead on responding to any potential issue escalating as necessary to other senior members of the team.

By actively leading on developing the data warehouse working closely with key members of the team, suppliers and developers. This will involve creating bespoke designs and solutions potentially influencing the working practice of own area and beyond.

Tobe responsible for ensuring, with IT support, the maintenance of the Information Department databases and applications including backup data.

Take a lead role with the maintenance and development of the Trust's existing in-house databases and applications such as:

To identify opportunities to build on the existing information databases and Information Department reporting platforms

To design build and implement effective solutions to both expand the scope of the Apollo EPR system, CRIS (radiology system) and Theatres systems, and wherever possible streamline the data handling processes around these systems.

To coordinate the specification, design and implementation of new and revised information systems, and to be responsible for developing information solutions to agreed specifications.

Responsible for the production and maintenance of documentation on the design, testing and use of information systems and in sufficient detail that others mightmodify, support or use the system.

Ensure any changes to information systems adhere to the Trusts change control process.

Maintain and develop own knowledge of NHS data structures. Ensure that any system development isin accordance with NHS Data Dictionary.

To be the lead technical specialist (Database Design/Software code/Programming) for the Information Department and to support team members by providing expert advice in the writing of SQL and other software and be able to challenge them constructively so that they can develop their skills and improve the quality of their outputs.

For their area of responsibility to ensure that all national returns, internal routine reporting and information requests are dealt with within agreed timescales.

To develop a broad understanding of the Trusts key systems and processes to support requests for information.

Ensure that all information governance requirements for the security of sensitive data are maintained in systems developed or modified.

Promote an understanding of the quality,availability and best use of patient-based information within the Trust. Explaining and presenting on reporting to interested groups and working directly with staff groups that include Trust Board Executives, Clinicians and Senior Managers.

To undertake data processing and analytical work to support requests for information or to support an investigation into issues such as data quality queries. This will involve making judgements, within short timescales, involving assimilation of complex facts or situations, which require the analysis,interpretation and comparison of a range of options. There will also need to be an understanding of the queries posed by the requester to ensure accurate feedback and solutions are given

Importance will be placed on the content and layout ofsubsequent analyses, requiring further manipulation within products such as Excel prior to presenting to the users. Outputs will need to be validated to ensure consistency. It will also be necessary to spend time with the users to ensure they understand the analyses and to provide explanation and interpretation for any areas of uncertainty.

To provide guidance on theappropriate definition, collection, validation, and processing of data.

Working closely with the Data Quality Team is an integral part of the post holders role:

To be proactive in all data quality initiatives liaising with data providers as appropriate.

Report any data quality issues that are identified in the role to the Data Quality Team immediately.

To carry out data validation and reconciliation exercises to ensure the integrity of data

Tocomply with, use and support senior informatics staff in the continued ongoing development of Information Management policy and protocols throughout the organisation which could impact on other teams and functions.

To ensure that all operational procedures and protocols are undertaken and completed within timescales.

To develop andmaintain effective working relationships with clinical and managerial staff across the organisation. To work closely with the senior staff to encourage the collection and use of accurate data to obtain improvement in the management of clinical services

To contribute fully to key Trust projects, as directed, by taking the lead for information supporte.g. Electronic Patient Records (EPR).

To keep skills up to date and relevant to carry outappropriate tasks in relation to the core information systems and desktop applications.

To activelyparticipate in any training and development programmes and ensure that all requirements are completed within agreed timescales.

Toparticipate in forums to update staff on any organisation/national issues.

To provideon the job training for new staff in the Information Department.

To provide cover for other members of the Information Team to enable the smooth running of information services and support the delivery of the information requirements ofTrust.

Torepresent the department as appropriate on projects and at meetings and participate in multidisciplinary teams within the Trust to develop the use of information.

To plan andorganise own work and work schedule of others with the use of appropriate planning aids, demonstrating good time management and ensuring anticipated difficulties in meeting deadlines are promptly resolved

To work effectively as a member of the Information Team but also be able to work at times independently and autonomously, employing considerable self-management skills,prioritising the workload effectively

Tobe responsible for the health and safety of staff by identifying and reporting hazards/incidents within the workplace.

To always promote the department in a positive manner.

Person Specification

Qualifications

• Degree in IM&T/data related discipline or equivalent demonstrable experience
• GCSE A* - C in Mathematics or equivalent

• Qualification in advanced IT Use (e.g. Microsoft Office Specialist (MOS): Excel, Microsoft Office Specialist (MOS): Access)

Personal Qualities

• An ability to assimilate different views and opinions.
• A self-motivated and enthusiastic professional, who can display innovative thinking
• Ability to prioritise workloads and to work to tight deadlines
• Ability to work under pressure and to respond to critical and immediate changes of work priorities and demands
• Ability to consistently deliver work to high quality in a changing environment
• Ability to work under own initiative and as part of a team
• Ability to respond to unpredictable work patterns/interruptions
• Ability to gain an understanding of and interpret other professionals' information requirements

• Positive attitude towards learning and development, demonstrated by a record of continuing professional development

Experience

• Experience working within a statutory health care organisation
• Experience in Visual Basic, SSIS, SQL database, SQL and VBA scripting, Power BI
• Experience in either an Information or Planning arena and can demonstrate an understanding and knowledge of organisations associated with the provision of healthcare
• Experience of working with complex analytical queries and presentation of data
• Experience of investigating data anomalies identified during analysis
• Ability to interpret, evaluate and translate information from a variety of sources
• Ability to extract, manipulate and report on diverse datasets using databases and spreadsheets.

• Report writing software (e.g. SSRS)
• NHS experience within Information Services or equivalent
• Previous experience of managing staff

Knowledge / Skills

• Excellent verbal, written & presentation skills
• Ability to lead and motivate teams
• Excellent analytical and numerical skills.
• Ability to adapt and improve information systems
• Ability to disseminate information used in data analysis
• Capacity to absorb a variety of information quickly and re-interpret
• Organisational and interpersonal skills, able to build creditability with a wide range of professionals
• Have a high degree of competence in the use of Microsoft Office and desktop applications and can demonstrate good skills with respect to database and spreadsheet management

• In depth knowledge of NHS datasets
• Can demonstrate project management skills

Disclosure and Barring Service Check

This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service (formerly known as CRB) to check for any previous criminal convictions.

Employer details

Employer name

Robert Jones and Agnes Hunt Orthopaedic Hospital NHS Foundation Trust

Address

RJAH

Gobowen, Oswestry

SY10 7AG

Employer's website

https://www.rjah.nhs.uk/