Job summary
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
Main duties of the job
- 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.
About us
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.
Job description
Job responsibilities
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.
Job description
Job responsibilities
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.
Person Specification
Qualifications
Essential
- Educated to degree level in relevant discipline or equivalent professional and management experience Business Intelligence design & development related experience
- Evidence of continuing professional development
Knowledge and Experience
Essential
- Significant experience within similar role ideally within healthcare or other public sector
- Proven ability to multi task working Able to deliver to tight deadlines Expert in developing data extraction, transformation and loading solutions in SQL Server
- Able to successfully extract data from organisation wide systems
- In Depth knowledge of Microsoft SQL Server Business Intelligence tools including TSQL and SQL Integration services
- Proven experience in data mapping Experience of interpreting and analysing national guidance / requirements Understanding of NHS Information and IT policies / agenda
Desirable
- Experience of work in information within NHS
Person Specification
Qualifications
Essential
- Educated to degree level in relevant discipline or equivalent professional and management experience Business Intelligence design & development related experience
- Evidence of continuing professional development
Knowledge and Experience
Essential
- Significant experience within similar role ideally within healthcare or other public sector
- Proven ability to multi task working Able to deliver to tight deadlines Expert in developing data extraction, transformation and loading solutions in SQL Server
- Able to successfully extract data from organisation wide systems
- In Depth knowledge of Microsoft SQL Server Business Intelligence tools including TSQL and SQL Integration services
- Proven experience in data mapping Experience of interpreting and analysing national guidance / requirements Understanding of NHS Information and IT policies / agenda
Desirable
- Experience of work in information within NHS
Disclosure and Barring Service Check
This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service (formerly known as CRB) to check for any previous criminal convictions.
Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab).
From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to 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) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab).
Additional information
Disclosure and Barring Service Check
This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service (formerly known as CRB) to check for any previous criminal convictions.
Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab).
From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to 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) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab).
