Go to job search

Data Warehouse Analyst

Countess of Chester Hospital NHS Foundation Trust, Chester

Data Warehouse Analyst

Salary not available. View on company website.

Countess of Chester Hospital NHS Foundation Trust, Chester

  • Full time
  • Permanent
  • Onsite working

Posted today, 16 Oct | Get your application in now to be one of the first to apply.

Closing date: Closing date not specified

job Ref: 3a8fbd6f46934306b9902e6c712f4b4f

Full Job Description

  • Opportunities to work on interesting projects supporting the wider organisation (e.g. data warehouse modelling & builds, process automation)
  • An excellent defined benefit pension scheme
  • Potential for Level 5 apprenticeship support to be considered (as part of a development role opportunity)
    • Good to know
  • Hybrid working with at least 2 days a week on-site in Chester (more during induction period)
  • Flexible working hour, Liaise with Data & Digital Teams to ensure that the most up to date datasets and feeds are available via the data warehouse, tables and databases to ensure that reporting and submissions are based on the most accurate data definitions available.
  • Work with users to resolve problems and issues with data and associated software.
  • To play a key role in the on-going support of IT solutions developed within the Data & Analytics Department, mentoring staff on likely issues that may arise and how to resolve them.
  • To play a key supporting role in the development and support of the Trust's Data Strategy and Service Line reporting agenda.
  • To troubleshoot issues regarding data tables and to consistently work toward improving and automating the processes.
  • To maintain the Trust's data warehouses and related data feeds ensuring data integrity.
  • To receive, manage and schedule requests from clients and colleagues for the development of data loads into the data warehouse.
  • To carry out system/application testing in accordance with agreed policy on a regular basis.

    A head for numbers and technology (evidenced either academically or through relevant experience)
  • A proactive problem solver with a keen attention to detail
  • Experience with T-SQL as well as some of our tech stack (SSRS, SSIS, Power BI), or similar tools
  • Excellent communication skills, verbal and written
  • The ability and desire to proactively learn new skills
  • Previous NHS or healthcare experience (beneficial but not required)

    The Countess of Chester Hospital NHS Foundation Trust provides services to West Cheshire and to Welsh patients covered by Betsi Cadwaladr University Health Board. The Trust works collaboratively within the wider Cheshire and Merseyside Health and Care Partnership. Its services are provided from three locations:
  • The Countess of Chester Hospital: providing 438 general and acute beds
  • Ellesmere Port Hospital: providing 56 beds as a rehabilitation, intermediate and outpatient facility
  • Tarporley War Memorial Hospital: a base for community services which serve the local rural population.
    • The Trust employs over 6258 staff (headcount) which includes temporary bank staff and provides acute emergency and elective services, primary care direct access services and obstetric services to a population of approximately 407,000. This includes 357,000 residents in Chester and West Cheshire which includes Ellesmere Port and Neston as well as the Deeside area of Flintshire which has a population of approximately 50,000. The Trust is a busy district general hospital and in 2022/2023, there were more than 503,342 patient attendances (inpatient, outpatient and diagnostic) ranging from a simple outpatient appointment to major cancer surgery. This is an increase of nearly 10,000 compared to the previous year when there were 494,387 patient attendances.