Data Warehouse Manager

This job is brought to you by Jobs/Redefined, the UK's leading over-50s age inclusive jobs board.

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

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

South Warwickshire NHS Foundation Trust (SWFT) is an integrated acute and community Trust, and is looking for an outstanding individual to manage the Data Warehouse Development Team.

The post holder will provide expert strategic and operational technical management and development of information and data processing systems. They will manage further development of the Trust's data warehouse and business information systems. The role will also include technical development work including support and maintain existing application databases.

The post holder will be responsible for managing the Data Warehouse Development Team. 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 department promotes agile working.

Requirements include:
• Relevant degree, or suitable equivalent qualifications and experience.
• Advanced experience of MS SQL server in a complex organisation
• Excellent technical skills and knowledge backed up by previous experience of data warehousing.
• Experience of Managing a SQL Development Team
• Ability to interpret complex user requirements and translate these into deliverables.
• Strong communication skills

We are unable to sponsor visas for this post

Main duties of the job

Responsible for management of the Department's information and data processing systems.

Recommend and implement strategic improvements to streamline and enhance existing processes and systems, promoting greater efficiency and effectiveness within the Information Department. Determine and implement improvements to departmental data processing and information production systems.

Supporting and maintaining application databases, developing and supporting the department's Data Warehouse and Business Intelligence systems.

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.

Create policies and procedures for Software Development within the Information Team

Acts as coach or mentor of junior members in the team, supports their training and development. Coaches individuals in the use of information and systems.

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

Information and Performance

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

Lead and manage the Trust's 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 data
sources.

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

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

To lead and manage the database administration.

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

To ensure data is available for key performance indicators dashboard
within 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 data
aggregation and analysis by information staff.

To lead and manage upgrades to data warehouses and reporting tools to
ensure the department keeps up with the latest technologies and SQL
server upgrades.

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

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

To respond to queries regarding data integrity within the department's
databases. Investigating, raising and resolving issues with the Information
analysts.

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

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

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.

Assess and manage the risks in relation to the roles and responsibilities of
the 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 external
stakeholders.

To ensure that the Data Protection Act recommendations relating to the
provision 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 Data
Warehouse Development staff - to line manage staff according to the
policies and procedure of the Trust. These duties include holding regular
1:1 meetings, ensuring personal development plans are in place, setting
objectives and appraising performance and monitoring sickness and
attendance.

Staff Development

To provide day to day management and motivation for the Development
Team.

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

Acts as a coach and mentor for other less knowledgeable and experienced
colleagues, raising the standard of professional excellence through
example.

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

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

General Duties

Maintaining a good understanding of available new technologies /
techniques.

Participate in appraisal and personal review and work to agreed set
objectives

Participate in appropriate training and development activities

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

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

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

Person specification

Qualifications

Essential criteria

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

Desirable criteria

• Microsoft certification in SQL Server, Visual basic

Experience

Essential criteria

• 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

Desirable criteria

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

Skills

Essential criteria

• 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

Desirable criteria

• 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

Essential criteria

• 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

Essential criteria

• Able to travel to meetings

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

• Data Warehouse Manager Job Description (PDF, 168.6KB)
• Data Warehouse Manager Person Specification (PDF, 64.7KB)
• Occupational Health Functional Requirements Form (PDF, 207.6KB)