Data Warehouse Manager
Job summary
We have an excellent temporary opportunity for a highly skilled Data Warehouse Manager to join our team and to work help us drive forward the Trust's Data Warehousing strategy whilst we are implementing a new Patient Administration System.
Main duties of the job
In addition to the below summary, you need to familiarise yourself with the full Job Description and Person Specification documents attached to this advert.
The successful candidate will be based at the City Hospital Campus, will be working closely with the current Data Warehouse Manager, and will be expected to provide both the day-to-day line-management as well as the technical leadership for a number of staff in the wider team; in addition, the role also encompasses a significant amount of hands-on involvement in all phases of the full development lifecycle for the Trust's data warehousing and data migration projects.
We are looking for an enthusiastic, self-motivated and forward thinking individual who possesses highly expert technical knowledge of SQLServer, T-SQL, and SSIS, combined with excellent proven mentoring and leadership skills. Experience of working within a Quality Management System (ISO9001:2008 or similar), and knowledge of the NHS and NHS data structures would be highly advantageous.
About us
With over 19,000 staff, we are one of the biggest employers in the city with a central role in supporting the health and wellbeing of our local population. We play a leading role in research, education and innovation.
Come and join our wonderful team at NUH. We are big believers in diversity and welcome new ideas to help develop our team in order to deliver world class healthcare to the vast patient populations we serve. With endless personal development opportunities available, at NUH we will endeavour to turn your job into a career!
We particularly welcome applications from people who identify as Black, Asian and Minority Ethnic, or Disabled, as we are striving to be better represented at NUH.
Job description
Job responsibilities
Your work will be varied and interesting, encompassing e.g. line management and team leadership, the investigation of acquiring potential new datasets from various clinical systems into the Trust data warehouse, building new data pipelines, ongoing monitoring of existing packages, providing architectural and strategic advice, etc.
In your application, please make sure you address the key points outlined in the Person Specification so we can assess your suitability for this role, specifically with regards to your practical experience in managing staff, working with standard NHS datasets, SQLServer / SSIS, data mapping, requirements gathering, analysis and design, and providing any and all associated project documentation.
Person Specification
Training & Qualifications
- Educated to Master's degree level in an IT related discipline or equivalent experience
- Evidence of continued professional development within data warehousing and business intelligence discipline
- Management / leadership qualifications
Experience
- Proven recent team management experience
- Extensive proven experience of designing and implementing data warehousing within a busy and large acute healthcare Trust with a complex applications landscape
- Highly expert in the use of T-SQL and the MS BI toolstack (in particular, SSMS and SSIS)
- A minimum of 5 years' experience of software development within a structured environment following Quality Management principles and encompassing the full software development lifecycle.
- Highly expert knowledge and experience of user requirements analysis and solution design
- Experience of working with JSON and/or XML
- Practical experience in the use of other ETL tools such as Business Objects, Qlik, etc.
- Practical experience with data warehousing data from some or all of the main current NUH Trust systems, including (but not limited to) : Careflow PAS, NerveCentre, CRIS
Communication and Relationship skills
- Excellent written communication skills (-1 for spelling mistakes, -1 for grammatical mistakes, -2 for unanswered questions, -2 for unclear/confused answers)
- Demonstrable experience in writing standards documents, best practice guides, etc.
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
Nottingham University Hospitals NHS Trusts
Address
City Hospital Campus
Hucknall Road
Nottingham
NG5 1PB
https://www.nuh.nhs.uk/
- Company
- Nottingham University Hospitals NHS Trusts
- Location
- Nottingham, United Kingdom NG5 1PB
- Employment Type
- Fixed-Term
- Salary
- £50952.00 - £57349.00 a year
- Posted
- Company
- Nottingham University Hospitals NHS Trusts
- Location
- Nottingham, United Kingdom NG5 1PB
- Employment Type
- Fixed-Term
- Salary
- £50952.00 - £57349.00 a year
- Posted