Senior Data Warehouse Manager

Job description

Job responsibilities

Data Warehousing

• Develop and maintain a robust data architecture that supports the storage, retrieval, and analysis of healthcare data within the Oracle Millennium system.
• Collaborate with cross-functional teams to design and implement ETL (Extract, Transform, Load) processes for the integration of data from various sources into the Oracle data warehouse

Leadership and Management

• Maintain regular contact with designated areas/staff members in providing support and advice to ensure that objectives are met and outcomes achieved and that these are documented and available to both staff and the line management structure.
• Effective coordination with internal and external IT teams.
• Where appropriate support the completion of investigations both patient and staff related.

Problem Solving

• Ability to make use of appropriate information to help analyse a range of common types of problem.
• Work with the requestor of the analysis to understand the underlying question and apply own knowledge to plan the preferred approach to the analysis.

Project Management

• Ensure the team's work conforms to project scope, adjusting as necessary following any authorised changes, allocating work efficiently whilst maintaining quality standards within the allocatedtimescales.
• Report progress effectively using the project management framework in use demonstrating accountability for the team's output

Most Challenging Part of the Job

• The post holder must balance the conflicting priorities and demands of the organisation against the resource available.
• Produce accurate and timely information analysis in a constantly changing information environment.
• Understand how to take information analysis forward in line with the Trusts priorities and the available technologies.
• The post holder will be accountable for the accuracy of all Information produced and so, we cannot trade speed of delivery over accuracy.

For a full comprehensive list of main responsibilities and duties, please kindly refer to job description and personal specification attached.

Person Specification

Technical

• Proven ability to lead, influence and motivate with project / resource planning experience.
• Extensive experience of SQL Database Administrator tools and utilities including advanced scripting and basic coding.
• A Masters' degree or equivalent relevant experience to achieve expert status in the use MS-SQL, SSRS and MS Excel.
• Experience of designing, coding, testing and implementation of efficient and robust database schemas.
• Ability to understand a broad range of complex information quickly and making decisions where opinions differ/no obvious solution

• Knowledge of the information needs and processes of the Clinical and Operational functions within an Acute hospital.
• Expert knowledge of the NHS Data Manual, Information Standards, data flows and statistical returns gained through at least 2 years in an NHS informatics role.

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

George Eliot Hospital NHS Trust

Address

George Eliot Hospital

College Street

Nuneaton

CV10 7DJ

Employer's website

http://www.geh.nhs.uk/