Return to search

NB: This vacancy closed to applications on 17/02/2019.

  • Add to favourites

Data Warehouse Analyst Band 6

Job Reference: 370-ADM6CIS-7602

Warrington and Halton Hospitals NHS Foundation Trust
Clinical Information Services
£26,565 to £35,577 pa

“Our Mission is to be outstanding for our patients, our communities and each other….

Data Warehouse Analyst

Band 6

Previous applicants need not apply 

Are you a problem solver whose tool of choice is Microsoft’s T-SQL?

Do you know your Outer Apply from your Left Join, and when to use them?

Can you create easy-to-deploy SSIS packages that solve complex technical problems?

Do you like using standards while still being creative with your solutions?

Are you a team-player looking for a flexible, knowledge-sharing environment? 

If the answer is “Yes”, then we want to hear from you. 

We are seeking an enthusiastic, committed, and motivated individual to join our Data Warehouse Team as a Data Warehouse Analyst. Reporting to the Data Warehouse Manager and supporting the Senior Data Warehouse Analyst you will be responsible for the daily operational support and development of the Trust’s data warehouse and business intelligence systems. You'll be undertaking a range of tasks that will challenge your skills and ensure you keep learning, such as: 

    • Keeping existing datasets loading successfully, quickly, and accurately

    • Transforming unfriendly system data into user-friendly reporting data

    • Using SQL and non-SQL technologies to streamline workflows

    • Creating new datasets from existing and new hospital systems

    • Troubleshooting performance issues to deliver a great user experience

    • Liaising with non-technical people to understand and solve problems 

You will require excellent communication skills and a high level of IT literacy.

This job advert may close as soon as sufficient applications have been received, therefore please apply for this job as soon as you can, if interested.

This Trust is an equal opportunities employer and welcomes diverse applications from people with disabilities, from ethnic minorities and all other social groups. We encourage all applicants to share their equality information with us; please read `Be counted` and `8 reasons why’ in the additional information. We operate Family Friendly and Career Break policies.

The Trust operates a Smoke Free Policy which does not permit smoking within the Trust premises and grounds/site.

Please provide e-mail addresses for referees as this will facilitate a quicker recruitment process

Please check your e-mail account regularly as you will receive alerts from the NHS Jobsite informing you of a message (including notification of interview)

Please note pay progression is subject to the NHS Agenda for Change Pay Progression provisions applicable from 1st April 2019.

All posts are subject to NHS Employment Check Standards including a DBS check, if applicable. Depending on the classification of the post, in-line with DBS guidelines, a Standard or Enhanced disclosure will be required which may include a check of the ‘Vulnerable Adults List’, the ‘Children’s List’ and/or the Independent Safeguarding Authorities (ISA’s) barred lists.

A charge of £39 (Standard) or £60 (Enhanced) will be made by the successful candidate which will be deducted from the first 3 months’ salary. In addition to this, you will also be required to re-pay any future costs that may arise in relation to DBS fees.

NB. Current employees of Warrington and Halton Hospitals NHS Foundation Trust who have had a satisfactory DBS check, carried out by this Trust during the last 3 years, will not be required to undertake a new one. Where staff have not had a check (classification appropriate to the post offered) within the last 3 years, they will be required to undertake and pay for this, as per the arrangements above.

Tier 2 Certificate of Sponsorship

Applications from job seekers who require Tier 2 sponsorship to work in the UK are welcome and will be considered alongside all other applications. However, non-EEA candidates may not be appointed to a post if a suitably qualified, experienced and skilled EU/EEA candidate is available to take up the post as the employing body is unlikely, in these circumstances, to satisfy the Resident Labour Market Test. The UK Visas and Immigration department requires employers to complete this test to show that no suitably qualified EEA or EU worker can fill the post. For further information please visit the UK Visas and Immigration website.

From 6 April 2017, Tier 2 skilled worker applicants, applying for entry clearance into the UK, must 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) will also be subject to this requirement.

Guidance can be found here Criminal Records Checks For Overseas Applicants

SAFERJobs To stay safe in your job search we recommend that you visit SAFERjobs (, a non-profit, joint industry and law enforcement organisation working to combat job scams. Visit the SAFERjobs website for information on common scams and to get free, expert advice for a safer job search.

  • Investors in People Gold Logo
  • Disability Confident Employer
  • Positive about Disabed People Logo
  • Improving Working Lives Logo
  • Mindful Employer Logo
  • Smoke Free Logo
  • Apprenticeships Logo
  • Living Wage Employer
  • Listening into Action