Information Systems Developer

Job 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 Trusts 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 departments 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.

Allemployees will havean 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.

Qualifications

Essential

• Degree or equivalent professional qualification in an ICT related discipline, or equivalent experience

Desirable

• Relevant recognised qualification or training in database design and maintenance

Experience

Essential

• 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

• 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

• 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

• Detailed knowledge of the Trust's standard Microsoft software packages

Personal Qualities

Essential

• 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

• Ability to work with PC/VDU for long periods

Desirable

• 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.

Certificate of Sponsorship

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).