Job summary
Data Warehouse Developer
Department/Directorate: Informatics / Quality
Directorate: Quality
Reports to: Senior Data Engineer
Hours per week: 37.5 hours
Job Type: Permanent
Pay Band: Band 6
We currently have a vacancy within the Data Services team in the for a motivated, enthusiastic and innovative person for the role of a Data Warehouse Developer. The successful post holder will support the Senior Data Engineers in the management and development of new and existing data warehouse, reporting, data processes, system administration and dashboards.
This post requires strong problem solving and analysis skills as well as presentation and report building skills.
The post holder will be required to have database and data warehouse development experience with ETL/ELT using SQL, stored procedures and data integration tools. BI reporting experience preferable using SSRS and Power BI, DAX to support the data warehouse and business intelligence and analyst team.
Main duties of the job
This is an excellent opportunity for a talented individual to join an experienced and dynamic team where you will be encouraged to demonstrate your skills and talent.
Knowledge and working in Agile development environments and a willing to research, learn new and exciting technologies will be advantageous.
The post will be based primarily in Parkway (Manchester) and will have the ability to work from home too. The post holder may also be required to travel between all NWAS.
The Trust reserves the right to close this vacancy early if a large number of applications are received. Therefore we encourage early applications to ensure consideration for this post.
About us
North West Ambulance Service NHS Trust provides 24 hour, 365 days a year accident and emergency services to those in need of emergency medical treatment and transport.
Our highly skilled staff provide life-saving care to patients in the community and take people to hospital or a place of care if needed.We also provide non-emergency patient transport services for those patients who require non-emergency transport to and from hospital and who are unable to travel unaided because of their medical condition or clinical need.
Alongside the other emergency services, we also work to ensure the safety of the public and treatment of patients in the event of a major incident.
We also deliver the NHS 111 service in the North West. NHS 111 replaced NHS Direct in 2013. This service was introduced to make it easier for people to access local NHS healthcare services in England. It provides non-emergency medical help fast, and is available 24 hours a day, 365 days a year.
Job description
Job responsibilities
Please note only those candidates who clearly demonstrate how they meet the person specification on their application will be shortlisted for this job. Please ensure you read the full Job Description and Person Specification.
SJT open 08/08/2023 Closes 09/08/2023
Assessment day 14/08/2023 (please be available all day)
Job description
Job responsibilities
Please note only those candidates who clearly demonstrate how they meet the person specification on their application will be shortlisted for this job. Please ensure you read the full Job Description and Person Specification.
SJT open 08/08/2023 Closes 09/08/2023
Assessment day 14/08/2023 (please be available all day)
Person Specification
Skills / Competencies
Essential
- Excellent interpersonal skills.
- Excellent written and verbal communication skills.
- Good analytical and reporting skills.
- Good team building skills with the ability to motivate other people and manage conflict.
- Ability to work well under pressure and to tight deadlines.
- Advanced user of information systems such as Microsoft Office Suite, including Visio, spreadsheets and databases.
- Ability to self-direct in all areas of work and be capable of making decisions within remit of the post.
- Highly skilled in use of SQL Server 2008 R2/2012/2014.
- High level of skills in SQL Server Analysis Services.
- Highly skilled in database design and development.
- Enthusiastic and positive approach to work.
- A team player with self-motivation and drive.
- Good attention to detail.
- Flexible approach to working arrangements.
Qualifications and Knowledge
Essential
- Educated to Degree level or equivalent.
- Evidence of further personal development.
Experience
Essential
- Experience of contributing to projects using a proven Project Methodology. i.e. Prince2 or Agile.
- Experienced user of SQL Server Reporting Services (SSRS).
- Experience of producing detailed reports.
- Experience of overcoming issues & problems.
- Significant experience in the NHS.
- Understanding of Information Governance.
- Understanding of the project lifecycle.
- Knowledge of the NHS.
- Understanding of the Ambulance Service.
Values and Behaviours
Essential
- Working together - demonstrate collaborative and inclusive working and challenge behaviour that is not inclusive or acceptable.
Person Specification
Skills / Competencies
Essential
- Excellent interpersonal skills.
- Excellent written and verbal communication skills.
- Good analytical and reporting skills.
- Good team building skills with the ability to motivate other people and manage conflict.
- Ability to work well under pressure and to tight deadlines.
- Advanced user of information systems such as Microsoft Office Suite, including Visio, spreadsheets and databases.
- Ability to self-direct in all areas of work and be capable of making decisions within remit of the post.
- Highly skilled in use of SQL Server 2008 R2/2012/2014.
- High level of skills in SQL Server Analysis Services.
- Highly skilled in database design and development.
- Enthusiastic and positive approach to work.
- A team player with self-motivation and drive.
- Good attention to detail.
- Flexible approach to working arrangements.
Qualifications and Knowledge
Essential
- Educated to Degree level or equivalent.
- Evidence of further personal development.
Experience
Essential
- Experience of contributing to projects using a proven Project Methodology. i.e. Prince2 or Agile.
- Experienced user of SQL Server Reporting Services (SSRS).
- Experience of producing detailed reports.
- Experience of overcoming issues & problems.
- Significant experience in the NHS.
- Understanding of Information Governance.
- Understanding of the project lifecycle.
- Knowledge of the NHS.
- Understanding of the Ambulance Service.
Values and Behaviours
Essential
- Working together - demonstrate collaborative and inclusive working and challenge behaviour that is not inclusive or acceptable.
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).
.png){kind=logo}
