Information Systems & Business Intelligence Lead
| Posting date: | 01 December 2025 |
|---|---|
| Salary: | £47,810.00 to £54,710.00 per year |
| Additional salary information: | £47810.00 - £54710.00 a year |
| Hours: | Full time |
| Closing date: | 15 December 2025 |
| Location: | Gobowen, Oswestry, SY10 7AG |
| Company: | NHS Jobs |
| Job type: | Permanent |
| Job reference: | C9224-25-0321 |
Summary
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. 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: 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. This will include providing advice on strategic developments designed to enhance Business Intelligence capability through specialist knowledge, contribute to the Data Warehouse strategy and co-ordinate the development of dimensional models and logical design. Responsible for the production and maintenance of documentation on the design, testing and use of information systems and in sufficient detail that others might modify, 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 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 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 highly 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 of subsequent 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. Providing expert advice and support to staff on the use of information and statistics made available to them and to communicate highly complex statistical/analytical information to non-statistical/analytical staff in a user-friendly manner. To provide specialist support with the use and design of tools and techniques with regards to the management of demand and capacity. To provide guidance on the appropriate definition, collection, validation, and processing of data. To control and advise on audits of information system implementations and utilisation. 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 To 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 on other teams and functions. To ensure that all operational procedures and protocols are undertaken and completed within timescales. To be responsible for leading and managing the Information Systems Analyst Team, and to ensure that an effective and efficient Information Systems Analysis service is provided e.g. develop staff ensuring staff receive an appraisal annually and that personal development plans are devised, to provide guidance and monitor the performance of staff against agreed objectives and to contribute to recruitment within the Information Department. To develop and maintain 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 support e.g. Electronic Patient Records (EPR). To keep skills up to date and relevant to carry out appropriate tasks in relation to the core information systems and desktop application To activelyparticipate in any training and development programmes and ensure that all requirements are completed within agreed timescales. To participate in forums to update staff on any organisation/national issues. To provide on 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 of Trust. To represent 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 and organise 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. To be 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.