Information Systems Developer

South Warwickshire University NHS Foundation Trust; Warwick; Hybrid; GBP 35,000 - 45,000; Full time

Job summary

A leading healthcare provider is looking for an Information Systems Developer to join their Data Warehouse Team. This role involves developing and supporting the Trust's data systems, with at least 2 years of experience in database management necessary. Responsibilities include managing the Data Warehouse, enhancing web-based reporting, and providing technical assistance within the Information Department. This position offers the flexibility of remote work while contributing to an outstanding healthcare team.

Qualifications

• Minimum of 2 years relevant experience in Database Management in a complex environment.
• Experience using and administering Microsoft SQL Server.
• In-depth understanding of relational database design, maintenance, and optimisation.

Responsibilities

• Develop, manage and maintain the Trust's Data Warehouse business intelligence system.
• Recommend improvements to streamline existing processes.
• Lead on the implementation of reporting tools and data warehousing.

Skills

Understanding of relational databases

MS-SQL server database administration and programming

Ability to communicate technical issues clearly to non-technical users

Good interpersonal skills

Ability to prioritise work appropriately

Education

Degree or equivalent professional qualification in ICT-related discipline

Tools

Microsoft SQL Server

SQL Server Integration Services

SSRS

Job description

Information Systems Developer

The closing date is 21 January 2026

An opportunity has arisen for a motivated developer to join South Warwickshire University NHS Foundation Trust. We are an integrated acute and community Trust serving the whole of Warwickshire.

The role, within the Data Warehouse Team, is to cover a secondment for a period of 18 months.

The successful candidate will be developing and supporting the Trust's Data Warehouse and Business Information systems. This team is a key part of the Information Department which provides a wide range of operational and performance reports to the Trust through its Business Intelligence systems.

The candidate will have a minimum of 2 years relevant work experience in database management and extensive practical experience of MS SQL Server in a working environment.

A robust understanding of database concepts and programming techniques is essential, along with excellent technical and communication skills and a willingness to learn new ways of working to enhance efficiency. The ability to interpret complex user requirements and translate these into deliverables is essential.

Knowledge of Data Warehousing concepts and knowledge of Insource's Data Academy and/or BI tools will be advantageous.

The role will mainly be working from home but will require attendance at occasional on‑site meetings. It is a good opportunity for a junior developer to extend their skillset. Previous applicants to the SWFT Data Warehouse Department should not apply.

Main duties of the job

Develop, manage and maintain the Trust's Data Warehouse business intelligence system to produce key dataset outputs.

Develop and enhance web‑based reporting and manage third‑party databases.

Recommend improvements to streamline and enhance existing processes and systems, promoting greater efficiency and effectiveness within production and use of information.

Act as a specialist providing advice on Data Warehouse system or information developments to project managers/IM&T staff, external third‑party developers or Trust users.

Be a source for the information team to develop advanced technical skills.

About us

Come and join a Trust rated Outstanding by the CQC. South Warwickshire University NHS Foundation Trust has been rated as outstanding following our latest inspection by the CQC and we are recruiting new staff to help us improve even further. In addition, our staff survey results have placed us 4th in the country for recommended place to work.

We provide services across Warwickshire and beyond ranging from hospitals in Warwick, Stratford‑Upon‑Avon, Royal Leamington Spa and Shipston‑on‑Stour to community services across the county. We are a progressive, expanding organisation with great ambition around improving quality, integrating pathways and delivering high levels of productivity.

Our values can be summed up in one sentence: ‘Trusted to provide safe, inclusive, effective and compassionate care’. Throughout the recruitment process you will be asked to think about how you demonstrate these values and how they impact on your work. It doesn't matter what role you do, whether it is patient facing or not, we are all working in the same way with our values at the core.

As part of our commitment to Equality, Diversity and Inclusion we encourage all applicants to complete a short survey.

https://forms.office.com/e/ahWY3eAGM2

We appreciate you completing the survey.

Job responsibilities

Provide technical assistance to the Information Department to help ensure that the data warehouse and its processes fully support Contracting/SLA reporting requirements including Payment by Results (PbR) and SUS data submissions.

Respond to queries regarding data integrity within the department’s Data Warehouse and other systems, investigating, raising and resolving issues with the Information Service Managers.

Improve and streamline existing processes and systems to promote greater efficiency and effectiveness in the production and use of information and offer performance and productivity advice.

Work closely with Line Manager to manage the development of new information databases, information processing systems, and deployment in collaboration with other Information and ITSS Services staff in Warwickshire.

Help develop the use of web‑based reporting tools, including designing, maintaining and developing reports for different audiences, assisting colleagues in using these tools. Also responsible for guidance to report writers.

Lead (with support of Line Manager) on the implementation of reporting tools and data warehousing to support the development of key performance indicators with drill‑through facilities using Microsoft SQL Server Reporting Services, Analysis Services, Integration Services and other third‑party BI tools.

Manage upgrades to data warehouses and reporting tools to ensure the department keeps up with the latest technologies and SQL Server upgrades and other software upgrades.

Decipher the work done by others.

Maintain a good understanding of available new technologies/techniques and be able to apply them as appropriate.

Assist Information staff with database analysis and data interpretation, including problem solving using SQL programming, use of advanced functions and highly complex methodology.

Develop and improve information reporting systems to meet the requirements of managers within the Trust including availability, data quality, etc.

Support the Trust in the development and implementation of new information systems.

Investigate technical issues in areas of expertise related to software or databases, and identify solutions and options for resolution.

Ensure that all developed systems are documented to the appropriate level, and that documentation is maintained and up to date.

Through close liaison with the IT Technical Services Manager, ensure that application servers such as Web Servers and Database Servers are appropriately managed and maintained.

Create, develop and sustain good working relationships with external stakeholders.

Ensure that the Data Protection Act recommendations relating to the provision of information are followed at all times.

Ensure processes have written procedures and that they are followed and maintained at all times.

Take a shared responsibility for all aspects of data quality and information with other senior staff within information, acting as a Deputy to Data Warehouse Manager.

Maintain a network of contacts and build professional relationships with suppliers and other NHS Trusts.

Communications and Working Relationships

Internal: Information Department staff, ITSS, Clinicians, and Operational Managers. Staff at all levels and grades of the organization.

External: External suppliers, other NHS organisations.

Person Specification

Qualifications

• Degree or equivalent professional qualification in an ICT related discipline, or equivalent experience
• Relevant recognised qualification or training in database design and maintenance

Experience

• Minimum of 2 years relevant experience in Database Management in a complex environment
• A minimum of two years’ experience using and administering Microsoft SQL Server
• In‑depth understanding of the principles of relational database design, maintenance and optimisation
• Knowledge of programming database tasks using SQL Server Integration Services and Stored Procedures
• Understanding of SSRS reporting system
• Good understanding of Windows NT, in particular the effects of user and group permissions for data access
• Experience of using Insource Data Academy product

Skills

• Understanding of relational databases
• Understanding of Data Warehousing
• MS‑SQL server database administration and programming
• SQL coding (e user‑defined functions/procedures) with SSIS and within application
• Ability to communicate technical issues clearly to non‑technical users
• Ability to obtain and analyse system requirements from a wide range of staff throughout the Trust
• Good interpersonal skills
• Good written presentation skills including graphics
• Ability to prioritise work appropriately
• Ability to process information in a logical order
• Detailed knowledge of the Trust’s standard Microsoft software packages

Personal Qualities

• Punctuality, reliability, integrity
• Self‑motivation
• Able to prioritise effectively and to work to deadlines
• Works well as part of a team
• Can communicate complex technical information to non‑IT staff within meetings and peer groups

Other

• Ability to work with PC/VDU for long periods
• Car Driver

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.

South Warwickshire University NHS Foundation Trust