Data Warehouse Manager

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

Detailed job description and main 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

Essential criteria

• 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

Desirable criteria

• Management / leadership qualifications

Experience

Essential criteria

• 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

Desirable criteria

• 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

Essential criteria

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

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

Closing Dates: Please submit your application form as soon as possible to avoid disappointment; we reserve the right to close vacancies prior to the published closing date if we receive a sufficient number of completed application forms.

Communication: All communication related to your application will be via the email address you have provided. Please ensure you check your email account including your junk email regularly.

Easy read application: if you have a disability and find it difficult to complete our online application form, you can apply via our easy read application which you can find on the intranet https://www.nuh.nhs.uk/easy-read-job-application

NUH are now able to offer application completion support and interview preparation support. Please follow the link to book onto our sessions: Support for NUH Job Applications

If you are aged 16 or 17 and applying for a role that is more than 20 hours a week, please be aware that you will be asked to commence an Apprenticeship within the Trust alongside your role, as long as there is a suitable apprenticeship standard available. This is in line with the current guidance in England that whilst young people under the age of 18 can leave school (on the last Friday in June) they must then do one of the following:

• Stay in full-time education, for example at a college
• Start an Apprenticeship
• Spend 20 hours of more a week working or volunteering, while in part-time education or training

For more details visit; School leaving age - GOV.UK (www.gov.uk)

Salary: The quoted salary will be on a pro rata basis for part time workers.

Disability Confidence: All applicants who have declared a disability and who meet the essential criteria for the post will be shortlisted.

At Risk of redundancy: NHS employees within the East Midlands who are 'at risk' of redundancy will be given a preferential interview where they meet the essential criteria of the person specification.

International Recruitment: If you are applying for a role with us from outside of the UK then please read the guidance on applying for a health or social care job in the UK from abroad.

ID and Right to work checks: NUH authenticate ID and right to work documentation including passports and driving licenses through a system called Trust ID. NUH will scan your ID and right to work documentation in to the Trust ID system at your face to face ID appointment. The system will run a check against the key security features within your documentation. The system will provide us with an outcome of your check which will be stored securely on your personal file along with all other pre-employment check documentation.

Consent:

• Transfer of information: If I have previous NHS service - I consent to the transfer of my Electronic Staff Record (ESR) data between this and other NHS Trusts. I also consent to the Occupational Health Department confidentially accessing my occupational health records from my current or previous employer in order to check the status of my vaccinations, immunisations s and screening tests as relevant to the post. I understand this is an automated process and the information will only be used for these purposes prior to me taking up the position at NUH.
• Disclosure and Barring Service: Your post maybe subject to a DBS check which incur a cost dependent on the level of check required (£42.90 for enhanced and £22.90 for standard). I agree to reimburse Nottingham University Hospitals NHS Trust the cost of a Disclosure and Barring Service (DBS) check if it is required (by deduction from first month's pay). Should I decide to withdraw from my job offer, I agree to reimburse Nottingham University Hospitals NHS Trust the cost of the DBS check undertaken by cheque or other agreed method.
• For more information about our organisation and the career opportunities available, please visit our website and/or follow us on Instagram, Twitter and Facebook

Employer certification / accreditation badges

Documents to download

• Data Warehouse Manager JD (PDF, 816.3KB)
• Data Warehouse Manager PS (PDF, 392.6KB)
• Mindful Employer (PDF, 242.5KB)
• Equality and Diversity (PDF, 122.3KB)
• Equal Opportunities (PDF, 57.4KB)
• Disability Confidence Scheme (PDF, 51.0KB)
• Rehabilitation of Ex Offenders (PDF, 106.0KB)