Data Warehouse Manager

Job description

Job responsibilities

Information and Performance

Lead and manage the data and information flow from operational /departmental systems into the Information Department databases and datawarehouse. Key systems that feed the data warehouse are the PatientAdministration system (PAS and A&E), Maternity and Radiology systems.

Lead and manage the Trusts Business Intelligence (BI) data warehouse(Insource Health Data Enterprise) and reporting tools (PowerBI and SSRS),that provide flexible on-line reporting covering a wide range of datasources.

Lead discussions and specification of new information processing andreporting requirements. To use knowledge and expertise to recommendand implement agreed solutions. Ensure that the process is robust, efficientand well documented.

To improve and streamline existing processes and systems to promotegreater efficiency and effectiveness within the information department.

To lead and manage the database administration.

Ensure that the data warehouses and processes fully supportContracting/SLA reporting requirements including Payment by Results(PbR) and SUS data submissions. This includes feeds to third partysystems including the Civica SLAM commissioning system.

To ensure data is available for key performance indicators dashboardwithin the Trust BI solution.

To ensure Finance staff have access to data required to feed the SLR /PLICS system.

Ensure that the data warehouses are structured to support efficient dataaggregation and analysis by information staff.

To lead and manage upgrades to data warehouses and reporting tools toensure the department keeps up with the latest technologies and SQLserver upgrades.

Ensure appropriate development software and hardware is procured /upgraded to support maintaining existing set up and new projects withinbudget restraints.

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

To respond to queries regarding data integrity within the departmentsdatabases. Investigating, raising and resolving issues with the Informationanalysts.

Assisting Information staff with database analysis and data interpretation,including problem solving using SQL programming, use of advancedfunctions and complex methodology.

Develop and improve information reporting systems to meet therequirements of managers within the Trust.

To support the Trust in the development and implementation of newinformation systems.

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

Assess and manage the risks in relation to the roles and responsibilities ofthe Development Team.

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

Create, develop and sustain good working relationships with externalstakeholders.

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

Assist other teams within Information Department as required.

Staff Management

The post holder is responsible for the line management of a number of DataWarehouse Development staff to line manage staff according to thepolicies and procedure of the Trust. These duties include holding regular1:1 meetings, ensuring personal development plans are in place, settingobjectives and appraising performance and monitoring sickness andattendance.

Staff Development

To provide day to day management and motivation for the DevelopmentTeam.

Support the Senior Information System Developers to ensure they receivethe appropriate training and development to carry out their role effectively

Acts as a coach and mentor for other less knowledgeable and experiencedcolleagues, raising the standard of professional excellence throughexample.

To cascade knowledge and skills and train colleagues with any newtechniques and technologies as necessary. Procure external training asrequired within department or project budgets.

To ensure Information Analysts are using the most appropriate tools tocarry out data analysis

General Duties

Maintaining a good understanding of available new technologies /techniques.

Participate in appraisal and personal review and work to agreed setobjectives

Participate in appropriate training and development activities

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

With other senior staff within the Information department, take a sharedresponsibility for all aspects of data quality and information

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

Person Specification

Qualifications

• Educated to postgraduate level or equivalent i.e. Degree level qualification plus at extensive development experience gained in a large commercial organisation.
• Degree or equivalent professional qualification in an ICT related discipline, or equivalent experience.

• Microsoft certification in SQL Server, Visual basic

Experience

• Extensive relevant experience with IM&T in a highly complex environment
• Experience of managing a SQL development team
• Advanced experience of MS SQL server in a complex organisation, including database administration tools and techniques (programming and administration)
• Data conversion and transformaReport development using windows technologies, e.g. OLAPtion
• Report development using windows technologies, e.g. OLAP

• NHS Experience.
• Understanding of NHS information requirements
• Experience of integration technologies

Skills

• Thorough understanding of relational databases
• MS-SQL server database administration and programming
• Proficient ability to write SQL (e.g. ability to write user -defined functions/procedures).
• Understanding of Database design and maintenance, including the use of indexes and stored procedures.
• Understanding of the NHS
• Knowledge of SQL DML for searching and updating SQL databases
• Knowledge of SQL DDL for defining and creating database objects
• Specialist knowledge of server side and client side scripting technologies
• Specialist knowledge of current windows operating systems
• Data analysis tools e.g. Microsoft Business Intelligence/Microsoft Reporting services
• Experience of staff management including staff recruitment, appraisals, training, and career development.
• Ability to liaise with staff at varying levels and being confident in working through technical issues with senior managers is essential.
• Ability to ensure development software and hardware is procured / upgraded to support maintaining existing set up and new projects within budget restraints

• Visual basic
• PowerBI dashboard tool
• HTML/XML web development tools
• Sharepoint 2010 Administration
• Knowledge of other programming languages and/or scripting languag
• HL7

Personal Qualities

• Able to prioritise effectively and to work to deadlines.
• Able to train staff to a high level in their area of specialist knowledge
• Able to manage delivery of projects involving staff from own and other areas, ensuring that deadlines and quality standards are met
• Can communicate complex technical information to non IT staff within meetings and peer groups
• Strong leadership skills, ability to lead and develop the team and provide guidance
• Works on own initiative
• Maintains an active interest in current IT developments
• Flexible approach to work
• Good interpersonal skills
• Reliable/dependable

Other

• Able to travel to meetings

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.

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.

Employer details

Employer name

South Warwickshire University NHS Foundation Trust

Address

Warwick Hospital

Lakin Road

Warwick

CV34 5BW

https://www.swft.nhs.uk/