Information Systems Develope

South Warwickshire University NHS Foundation Trust is one of the top performing organisations within the NHS. Our staff think this is a great place to work and we hope you will agree. We have recently been rated as 'Outstanding' by the Care Quality Commission (CQC) following our most recent inspection.
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 whole county. This includes our Community Teams in North Warwickshire.
We are a progressive, expanding organisation with great ambition around improving quality, integrating pathways and delivering high levels of productivity. Over 5300 people work for the Trust and many of them have been here a long time. People find they don't need to go elsewhere to find a fulfilling career in healthcare.
The first thing you will notice about us is how we take our values seriously. We believe that our values underpin everything we do. If you are interested in a role with us you need to make sure our values match your own.
Our values can be summed up in one sentence. We are 'Trusted to provide inclusive, safe, 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.
Probationary Period
All new staff to the Trust will be subject to a standard 6 month probationary period, the details of which will duly follow in your contract of employment.
Equality, Diversity, and Inclusion
South Warwickshire University NHS Foundation Trust is committed to creating and sustaining a positive and inclusive working environment for all our employees. Our aim is to ensure that employees are equally valued and respected and that our organisation is representative of all members of society. We define diversity as valuing everyone as an individual - we value our employees, job applicants, students, patients and visitors as people. This is reflected within our values of being Inclusive, Safe, Effective, Compassionate and Trusted.
Agile and Flexible Working
All our staff will have a work base. However the Trust operates as an Agile Working Team therefore staff may be working from home on a regular basis as required by the service. However, occasionally travel around Warwickshire and into your base will be required so access to your own transport would be helpful.
The Trust also welcome staff to work flexibly and we would welcome the conversation at interview regarding flexible working.
Staff Benefits
The Trust offer a wide range of additional benefits to staff. Anyone who joins us on a substantive basis can assess things such as the Lease Car Scheme, Electronics Scheme, Discounted Leisure and Travel, Cycle to work scheme amongst many others available.
Car Parking
The Trust have recently completed the construction of a multi-storey car park at our Warwick Hospital site which has allowed us to reduce waiting times for car parking passes. The Trust have also been able to freeze car parking charges.
To keep up to date on our latest recruitment activity follow us on twitter @swftrecruit or look us up on Facebook (Recruitment - South Warwickshire NHS Foundation Trust).
Job overview
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 community services to the whole of Warwickshire.
The role, in the Data Warehouse Team, is to cover maternity leave but has the potential to be extended due to the Trust project on replacing Patient administration system.
The successful candidate will we 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 have to attend the occasional meeting on site.
Main duties of the job
To develop, manage and maintain the Trust's Data Warehouse business intelligence system 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 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.
Working for our organisation
Come and join a Trust rated Outstanding by the CQC. South Warwickshire University NHS Foundation Trust have been rated as outstanding following our latest inspection by the CQC and we are recruiting new staff to come and 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. We are '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.
Detailed job description and main responsibilities
Organisation Chart:
Associate Director of Information and Performance
I
Head of Information
I
Data Warehouse Manager
I
Senior Information Systems Developers x 4
Information Systems Developer x 1
Key Result Areas:
1. Provide technical assistance to the Information Department to help ensure that the Trust's Data Warehouse and its processes fully support Contracting/SLA reporting requirements including Payment by Results (PbR) and SUS data submissions.
2. To 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.
3. To 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.
4. Working closely with Line Manager, manage the development of new information databases, information processing systems, and deployment working closely with other Information and ITSS Services staff in Warwickshire.
5. To help develop the use of web based reporting tools, including designing, maintaining and developing reports, for different audiences, assisting colleagues in the use of these tools. Also responsible for guidance to report writers.
6. To 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.
7. To work with the line manager to 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.
8. To be able to decipher the work done by others.
9. To maintain a good understanding of available new technologies/techniques and be able to apply as appropriate.
10. Assisting Information staff with database analysis and data interpretation, including problem solving using SQL programming, use of advanced functions and highly complex methodology.
11. Develop and improve information reporting systems to meet the requirements of managers within the Trust including availability, Data quality etc.
12. To support the Trust in the development and implementation of new information systems.
13. Investigate technical issues in areas of expertise related to software or databases, and identify solutions and options for resolution.
14. Ensure that all developed systems are documented to the appropriate level, and that documentation is maintained and up to date
15. 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.
16. Create, develop and sustain good working relationships with external stakeholders.
17. To ensure that the Data Protection Act recommendations relating to the provision of information are followed at all times.
18. Ensure all processes have written currently procedures and that they are followed and maintained at all times.
19. With other senior staff within information, take a shared responsibility for all aspects of data quality and information. Act as a Deputy to Data Warehouse Manager.
20. 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
General Items:
To provide short-term cover for colleagues during periods of leave.
To ensure that all Trust standards are maintained and monitored to improve the quality of care to all whom come into contact with services provided by South Warwickshire NHS Foundation Trust.
Every employee has a duty to take reasonable care of the health and safety of him/herself and of other persons who may be affected by his/her acts or omissions at work, and to co-operate with the South Warwickshire NHS Foundation Trust to ensure that statutory and Trust regulations are complied with.
To participate in appraisals and personal reviews and work to achieve agreed set objectives.
To participate in appropriate training and development activities
To participate in team, professional and personal development activities and promote commitment to continuous development and improvement.
Ensure that all staff consciously review mistakes, complaints and incidents/near misses as well as successes to improve performance and the level of customer care.
All employees will have an organisational and individual responsibility towards safeguarding vulnerable adults, young people and children. Where employees are working with children, young people and families they have a responsibility to cooperate in national safeguarding policy around early intervention activities appropriate to improving health outcomes.
As a major provider of health care, South Warwickshire NHS Foundation Trust operate a Smoke Free Policy by providing a totally smoke free environment to help aid patients' recovery, promote health and wellbeing and minimize the risks of complications attributed to smoking tobacco and second hand smoke.
Ensure that the Trust Smoke Free Policy is adhered to and that staff, patients and visitors are signposted to smoking cessation services.
Identify any appropriate support or interventions for staff to support their wellbeing.
To abide by Infection Prevention and Control policies relevant to their area of work, and undertake the necessary level of training. This will be appraised through the KSF review process or other relevant professional review process.
To accept responsibility for the provision of effective infection prevention and control within the Trust in liaison with the Trust's Infection Control Team.
To act as a role model in applying good infection control practice and ensures compliance with all Infection Control policies.
To promote and demonstrate implementation of the Trust's Carbon Management strategy and policy, ensuring team members are fully aware of the policy and are contributing to this.
This job description is subject to review at any time in consultation with the post holder.
Person specification
Qualifications
Essential criteria
Degree or equivalent professional qualification in an ICT related discipline, or equivalent experience
Desirable criteria
Relevant recognised qualification or training in database design and maintenance
Experience
Essential criteria
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
An in-depth understanding of the principals of relational database design, maintenance and optimisation
Desirable criteria
Knowledge of programming database tasks using SQL Server Integration Services and Stored Procedures
Understand of SSRS reporting system
A 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
Essential criteria
Understanding of relational databases
Understanding of Data Warehousing
MS-SQL server database administration and programming
SQL coding (eg ability to write user-defined functions/procedures) with SSIS and within Application
The 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
Desirable criteria
Detailed knowledge of the Trust's standard Microsoft software packages
Personal Qualities
Essential criteria
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
Essential criteria
Ability to work with PC/VDU for long periods
Desirable criteria
Car Driver
IMPORTANT INFORMATION
Sometimes we get a lot of applications for our roles. On those occasions we might close the job early. If you don't want to miss out we recommend submitting your application as early as possible.
The Trust use an Applicant Management System called TRAC which helps us manage the recruitment process. All communications regarding your application will come via TRAC (even if you applied via NHS Jobs).
Please check your TRAC account regularly and ensure your email is set up to accept messages so they don't go into your junk/spam folder.
We aim to shortlist all vacancies within 2 days of the vacancy closing, we will get back to all candidates ASAP.
Please ensure all sections of the application form are completed fully. Please particularly ensure that you provide full details of all referees including business email address, telephone contact details and postal address.
South Warwickshire University NHS Foundation Trust is an equal opportunities employer who is committed to Equality and Diversity and does not tolerate discrimination or harassment on the grounds of any protected characteristic as defined by the Equality Act 2010.
All South Warwickshire University NHS Foundation Trust sites are smoke free. We feel it's a great way to help our patients, visitors and staff stay healthy.
The Trust is part of a 'Foundation Group' through a strategic alliance with Wye Valley NHS Trust, George Eliot Hospital NHS Trust and Worcestershire Acute Hospitals NHS Trust. This partnership is great for the sustainability of all four organisations and allows us to share learning and maximise opportunities to ensure the delivery of high quality health and care services for our local populations.
Employer certification / accreditation badges
Documents to download
JD (PDF, 160.6KB)
PS (PDF, 152.6KB)