Information Systems Analyst

Robert Jones and Agnes Hunt Orthopaedic Hospital NHS Foundation Trust; Park Hall; On-site; GBP 40,000 - 50,000; Full time

Job summary

A healthcare provider in the UK is looking for a Senior Information Systems Analyst to join their busy Information Team. You will enhance and maintain data warehouse infrastructure and will work closely with analysts to support critical data processes. The role requires technical skills in SQL Server and a strong understanding of data management within healthcare, along with a degree or equivalent experience. This is an excellent opportunity to make an impact in patient care through effective data management.

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: Excel, Access).

Responsibilities

• Act as the Database Administrator for the data warehouse.
• Monitor and maintain the operational function of the warehouse daily.
• Lead the maintenance and development of existing databases and applications.

Skills

SQL database

Power BI

Visual Basic

SSIS

Analytical skills

Education

Degree in IM&T/data related discipline or equivalent

GCSE A*-C in Mathematics

Qualification in advanced IT Use

Tools

Microsoft Office

SSRS

Job description

Senior Information Systems Analyst

Closing date: 18 January 2026

We are seeking to recruit a Senior Information Systems Analyst within our busy Information Team. As the Trust recently implemented a new Electronic Patient Record and is about to begin the implementation of Business Intelligence Software, we need an individual who will work within a small development team to enhance and maintain our data warehouse infrastructure. You will contribute to 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. Technical skills in SQL Server data warehousing are required.

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.

Immigration: Under current Home Office immigration rules, this role does not meet the UK Visas and Immigration criteria and the position is not therefore eligible for sponsorship. Applications from candidates that require skilled worker sponsorship will NOT be shortlisted.

Main duties of the job

You will work closely with a small Development Team and other Analysts 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 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 coordinate system development and implementation as well as be responsible for improving the processing, production and distribution of activity and performance information within the Trust.

Job responsibilities

• Act as the Database Administrator for the Trust data warehouse.
• Monitor and maintain the operational function of the data warehouse daily, ensuring all data extracts and automated imports have successfully completed.
• Load reference and other data into the data warehouse in a timely manner.
• Serve as the first point of contact for all enquiries regarding the Data Warehouse and lead response to potential issues, escalating as necessary.
• Develop the data warehouse with key members of the team, suppliers and developers, creating bespoke designs and solutions that may influence practices beyond your area.
• In collaboration with IT support, maintain the Information Department databases and applications, including backup data.
• Lead the maintenance and development of the Trust’s existing in‑house databases and applications.
• Identify opportunities to build on existing information databases and reporting platforms.
• Design, build and implement solutions to expand the scope of the Apollo EPR system, CRIS (radiology system) and Theatre systems, streamlining data handling processes.
• Coordinate specification, design and implementation of new and revised information systems, and develop solutions to agreed specifications.
• Produce and maintain documentation on the design, testing and use of information systems with sufficient detail for modification, support or use by others.
• Ensure changes to information systems adhere to the Trust’s change control process.
• Maintain and develop knowledge of NHS data structures, ensuring system development complies with the NHS Data Dictionary.
• Act as the lead technical specialist (Database Design/Software code/Programming) for the Information Department and provide expert advice to team members on SQL and other software, challenging them constructively.
• Ensure all national returns, internal routine reporting and information requests are dealt with within agreed timescales.
• Develop a broad understanding of the Trust’s key systems and processes to support information requests.
• Maintain information governance requirements for the security of sensitive data.
• Promote an understanding of the quality, availability and best use of patient‑based information within the Trust, presenting reports to interested groups including Trust Board executives, clinicians and senior managers.
• Undertake data processing and analytical work to support requests for information or investigations into issues such as data quality queries, making judgements within short timescales and providing accurate feedback and solutions.
• Produce outputs with correct content and layout, validating consistency and working with users to ensure understanding.
• Provide guidance on definition, collection, validation and processing of data.
• Work closely with the Data Quality Team, proactively engaging in all data quality initiatives and liaising with data providers as appropriate.
• Report any data quality issues immediately to the Data Quality Team.
• Carry out data validation and reconciliation exercises to ensure data integrity.
• Comply with and support senior informatics staff in the continued development of Information Management policy and protocols across the organisation.
• Ensure all operational procedures and protocols are completed within timescales.
• Develop and maintain effective working relationships with clinical and managerial staff across the organisation, encouraging accurate data collection for improved clinical service management.
• Contribute fully to key Trust projects, taking the lead for information support, e.g. Electronic Patient Records.
• Keep skills up to date and relevant, and participate in training and development programmes, completing requirements within agreed timescales.
• Participate in forums to update staff on organisational/national issues.
• Provide on‑the‑job training for new staff in the Information Department.
• Provide cover for other members of the Information Team, enabling smooth running of information services and supporting delivery of information requirements.
• Represent the department on projects and meetings, participating in multidisciplinary teams to develop the use of information.
• Plan and organise own work and the work schedule of others using appropriate planning aids, demonstrating good time management and promptly resolving anticipated difficulties.
• Work effectively as a member of the Information Team while also working independently and autonomously, prioritising workload effectively.
• Be responsible for the health and safety of staff by identifying and reporting hazards/incidents.
• 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

• Ability to assimilate different views and opinions.
• Self‑motivated and enthusiastic professional with innovative thinking.
• Ability to prioritise workloads and work to tight deadlines.
• Ability to work under pressure and respond to critical and immediate changes of work priorities and demands.
• Ability to consistently deliver high‑quality work 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 ability to 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

• 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 credibility with a wide range of professionals.
• High degree of competence in the use of Microsoft Office and desktop applications, with good skills in 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 a submission for Disclosure to the Disclosure and Barring Service (formerly known as CRB) to check for any previous criminal convictions is required.

Employer name

Robert Jones and Agnes Hunt Orthopaedic Hospital NHS Foundation Trust