Information Systems & Business Intelligence Lead

Robert Jones and Agnes Hunt Orthopaedic Hospital NHS Foundation Trust; Oswestry; Hybrid; GBP 40,000 - 55,000; Full time

Job summary

A leading healthcare trust in the UK is looking for an Information Systems and Business Intelligence Lead to oversee data warehousing and manage a small team. This full-time role requires strong SQL skills and experience in healthcare information systems. The candidate will influence the development and implementation of business intelligence solutions, ensuring data quality and supporting patient care initiatives. This position also offers opportunities for professional development alongside a commitment to work-life balance.

Benefits

Flexible working

Access to professional development opportunities

State-of-the-art facilities

Qualifications

• Minimum of three years' experience in a statutory health care organisation.
• Experience with complex analytical queries and data presentation.
• Ability to extract, manipulate and report on diverse datasets.

Responsibilities

• Lead the Database Administrator of the Trust data warehouse.
• Monitor and maintain the operational function of the data warehouse.
• Coordinate the specification, design, and implementation of new information systems.

Skills

Strong technical skills in SQL Server data warehousing

Experience in Visual Basic

Experience in Power BI

Excellent analytical and numerical skills

Ability to lead and motivate teams

Education

Master’s degree or equivalent in Healthcare Information/Informatics/IT

GCSE A* – C in Mathematics or equivalent

Tools

SQL Database

Microsoft Office Specialist (MOS): Excel

Report writing software (e.g. SSRS)

Job description

Information Systems & Business Intelligence Lead

The closing date is 15 December 2025.

We are seeking to recruit an Information Systems/Business Intelligence Lead within our busy Information Team, as the Trust recently implemented a new Electronic Patient Record and are about to begin the implementation of Business Intelligence Software.

We are looking for an individual who will lead a small development team to enhance and maintain our data warehouse infrastructure. You will be responsible for the design, build and transformation of data from core Trust systems in our data warehouse to ensure the data is available for Analyst colleagues in the team. You should have strong technical skills in SQL Server data warehousing.

As a Specialist Trust we are a small team so you will be required to work closely with Analyst colleagues and stakeholders within the Trust. This brings great opportunities to support and understand the operational requirements of the organisation and see how the data supports patient care.

Main duties of the job

You will work closely with the Head of Business Intelligence and the Principal Analyst to enhance the Data Warehouse that was recently built to support the new Electronic Patient Record throughout the Trust.

The key purpose of the role is to provide an information service to support the data analysis and information management needs of the Trust. The post holder will need to ensure the effective functioning of the various information technology systems and co‑ordinate system development and implementation as well as being responsible for improving the processing, production, and distribution of activity and performance information within the Trust.

The post holder will be responsible for the design, construction, delivery and support of a Data Warehousing and Business Intelligence solution. This post will enable the Trust to meet its evolving needs.

To provide specialist advice and guidance in developing, maintaining and evolving the Trust’s Business Intelligence platform utilising the full range of software.

About us

The Robert Jones and Agnes Hunt Orthopaedic NHS Trust (RJAH) is one of the leading orthopaedic hospitals in the country, with some of the highest levels of staff and patient satisfaction, as well as a strong reputation for research and innovation.

In the National Staff Survey, 74% of our staff would recommend the Trust as a place to work and 92% would recommend the hospital to a friend or relative for treatment.

Joining RJAH is more than just a job – we want our people to have the best opportunities to thrive in their role. We have a range of fantastic staff benefits on offer to everyone who joins RJAH and you'll have access to outstanding professional development opportunities and state‑of‑the‑art facilities – including our recently‑opened £6 million Headley Court Veterans' Orthopaedic Centre (the first unit of its kind in the UK). RJAH has strong links with a range of universities including Staffordshire, Keele, Glyndwr, Chester and Birmingham. The hospital is located on a site outside Oswestry in Oswestry, just off the A5. The nearest train station is in Gobowen, approximately two miles from the hospital. The station is part of the Chester to Birmingham line. We are based in North Shropshire, close to the border with North and Mid Wales. It is one of the most attractive parts of the country, with a rich historic culture and excellent transport links. It offers outstanding opportunities for anyone who enjoys an outdoor lifestyle or is looking to raise a family.

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.

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: Apollo EPR, 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 actively participate 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.

Person Specification

Qualifications

• Educated to Master’s degree level or equivalent, evidence of specific education and learning in Healthcare Information/Informatics/IT
• 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 concentrate to undertake highly complex analysis requiring accuracy and attention to detail
• 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

• Minimum of three years' 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 highly 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 which may contain conflicting information
• 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

• Ability to lead and motivate teams
• Excellent analytical and numerical skills.
• Ability to adapt and improve information systems
• Ability to disseminate highly complex information used in data analysis – this may involve having to overcome any barriers to understanding
• Capacity to absorb a variety of information quickly and re‑interpret
• Organisational and interpersonal skills, able to build credibility 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

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.

Robert Jones and Agnes Hunt Orthopaedic Hospital NHS Foundation Trust

Full‑time, Flexible working, Home or remote working