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. For further details / informal visits contact: Name: Andy Hughes Job title: Data Warehouse Manager Email address: andrew.hughes5nhs.net Due to working arrangements - please email to arrange a call in advance if possible.