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, 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 the 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 the area and beyond. To be 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 identifying opportunities to build on the existing information databases and reporting platforms, designing, building and implementing effective solutions to 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. Coordinate the specification, design and implementation of new and revised information systems, and 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, in sufficient detail that others might modify, support or use the system. Ensure any changes to information systems adhere to the Trust's change control process. Maintain and develop own knowledge of NHS data structures. Ensure that any system development is in 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, ensure that all national returns, internal routine reporting and information requests are dealt with within agreed timescales. To develop a broad understanding of the Trust's 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. Explain and present on reporting to interested groups and work directly with staff groups that include Trust Board Executives, Clinicians and Senior Managers. Undertake data processing and analytical work to support requests for information or to support an investigation into issues such as data quality queries. Make judgements within short timescales, involving assimilation of complex facts or situations, requiring 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 of subsequent analyses, requiring further manipulation within products such as Excel prior to presenting to the users. Outputs must be validated to ensure consistency. Spend time with users to ensure they understand the analyses and provide explanation and interpretation for any areas of uncertainty. Provide guidance on the appropriate definition, collection, validation, and processing of data.
Working closely with the Data Quality Team is an integral part of the post holder's role: 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. Carry out data validation and reconciliation exercises to ensure the integrity of data. Comply with, use and support senior informatics staff in the continued ongoing development of Information Management policy and protocols throughout the organisation which could impact other teams and functions. Ensure that all operational procedures and protocols are undertaken and completed within timescales.
Develop and maintain effective working relationships with clinical and managerial staff across the organisation. Work closely with senior staff to encourage the collection and use of accurate data to improve the management of clinical services. Contribute fully to key Trust projects, as directed, by taking the lead for information support e.g. Electronic Patient Records (EPR). Keep skills up to date and relevant to carry out appropriate tasks in relation to the core information systems and desktop applications.
Actively participate in any training and development programmes and ensure that all requirements are completed within agreed timescales. Participate in forums to update staff on any organisation/national issues. Provide on‑the‑job training for new staff in the Information Department. 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 of the Trust.
Represent the department as appropriate on projects and at meetings and participate in multidisciplinary teams within the Trust to develop the use of information. Plan and organise own work and work schedule of others with appropriate planning aids, demonstrating good time management and ensuring anticipated difficulties in meeting deadlines are promptly resolved. Work effectively as a member of the Information Team but also be able to work independently and autonomously, employing considerable self‑management skills, prioritising the workload effectively. Be responsible for the health and safety of staff by identifying and reporting hazards/incidents within the workplace. Always promote the department in a positive manner.
Details
* Seniority level: Mid‑Senior level
* Employment type: Full‑time
* Job function: Information Technology
* Industry: Data Infrastructure and Analytics
#J-18808-Ljbffr