Data Warehouse Analyst

at  Countess of Chester Hospital NHS Foundation Trust

Working Full time : 37.5 hours per week
The Data Engineering Team has a Data Warehouse Analyst role available for the right person to come and join our friendly and hard-working team.
The Trust is committed to the use of data and information as a critical asset and aims to be a data-driven organisation. For the right candidate this will be a rewarding and satisfying position and an excellent career move in a forward-thinking Trust, with a real opportunity to develop your technical and personal skills.
Who we’re looking for
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)
What we can offer you
A dedication to your development based on the National Competency Framework
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.
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.
See Job Description for further details.
Recruitment selection processes are based on competence (see Person specification) and values.
Please note applicants will be required to pay for their DBS check. Costs are deducted from salary following appointment. The cost of the DBS application is £23 (standard) or £43 (enhanced), this cost will be deducted from your salary over the first three months of employment.
You are encouraged to enrol for the DBS Update Service. A small annual fee of £13 per year applies.
New entrants to the NHS will commence on the minimum of the scale stated above.
Applicants are advised to apply early as if a large number of applications are received for this post, we reserve the right to close the vacancy prior to the advertised date.
Good luck with your application

Please refer the Job description for details