An exciting opportunity has arisen at South Warwickshire University NHS Foundation Trust (SWFT) for a highly motivated senior developer in the Information & Performance Department. This is an 18 month fixed term contract.
The successful candidate will be developing and supporting the Trust’s Data Warehouse and Business Information systems and ensuring the Trust’s new EPR, Oracle Health (Cerner) currently being implemented, will integrate into the Data Warehouse.
This team is a key part of the Information & Performance Department which provides a wide range of operational and performance reports to the Trust through its Business Intelligence systems. You will be mostly working from home but will have to attend the occasional on- site meetings or events.
The ideal candidate will have a minimum of 5 years relevant work experience in database management and practical experience of MS SQL server in a complex NHS organisation. A robust understanding of database concepts and programming techniques is essential. You will have excellent technical skills and knowledge backed up by previous experience of data warehousing. You will have the ability to interpret complex user requirements and translate these into deliverables. Knowledge of Insource’s Data Academy and/or experience of Oracle Health (Cerner) would be a great advantage
Main duties of the job
Responsible for development, management and maintenance of information and business intelligence database systems including the in-house Data Warehouse system. Development of systems to produce key dataset outputs. Development and enhancement of web-based reporting and managing 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 lead specialist providing advice on 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.
Acts as coach or mentor to junior members in the team, supports their training and development. Coaches individuals in the use of information and systems.
The post holder must have highly developed specialist knowledge of SQL Server, Data Warehousing and web-based technologies including OLAP, Microsoft BI Stack and Data Warehouse Design.
Person Specification
Qualifications
Essential
- Educated to postgraduate level or equivalent i.e. Masters level qualification plus significant development experience gained in a large HealthCare organization or similar
- Degree or equivalent professional qualification in an ICT related discipline, or equivalent experience.
Experience
Essential
- Substantial, relevant experience in Database Management in a highly complex environment
- Advanced experience of MS SQL server gained over a substantial period of time in a complex organisation, including database administration tools and techniques (programming and administration)
- Report development using web/windows technologies e.g. OLAP
- In depth Knowledge of Business Intelligence, including Analysis Services for a significant period
Skills
Essential
- Thorough understanding of relational databases.
- Thorough understanding of Data Warehousing.
- MS-SQL server database administration and programming
- Advanced SQL coding (eg ability to write user-defined functions/procedures) with SSIS and within Application.
- Knowledge of SQL Integration Services
- Knowledge of SQL DML for searching and updating SQL databases
- Project Management
- Specialist knowledge of current windows operating systems
- Data analysis tools e.g. Microsoft Business Intelligence/Microsoft Reporting services
Desirable
- Understanding of Database design and maintenance, including the use of indexes and stored procedures.
- Data Academy experience
- Knowledge of SQL DDL for defining and creating database objects
- HTML/XML web development tools
Personal Qualities
Essential
- Able to prioritise effectively and to work to deadlines.
- Can communicate complex technical information to non-IT staff within meetings and peer groups
- Works on own initiative and self-motivated
- Works well as part of a team
- Maintains an active interest in current IT developments
- Flexible approach to work
- Good interpersonal skills
- Reliable/dependable
Desirable
- Able to train staff to a high level in their area of specialist knowledge
- Able to supervise delivery of projects involving staff from own and other areas, ensuring that deadlines and quality standards are met
Other
Desirable
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.
Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab).
From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab).
Closing Date: 30 September 2025
