Information Systems Developer

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.

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.

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.

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.

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.

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.

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.

To be able to decipher the work done by others.

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

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

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

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

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

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.

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

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