Information Systems Analyst

Go back Robert Jones and Agnes Hunt Orthopaedic Hospital NHS Foundation Trust Information Systems Analyst The closing date is 10 December 2025 We are seeking to recruit Senior Information Systems Analyst 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 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. You should have 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. 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 small Development Team and other Analysts in the team 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. 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: 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 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 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. To 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 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 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 applications. 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 the 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 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 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. 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. Employer name Robert Jones and Agnes Hunt Orthopaedic Hospital NHS Foundation Trust Full-time, Flexible working, Home or remote working #J-18808-Ljbffr