Senior Data Engineer

North West Ambulance Service NHS Trust

Information:

This job is now closed

Job summary

Job Title: Senior Data Engineer

Department/Directorate: Informatics / Quality

Directorate: Quality

Reports to: Business Analyst

Hours per week: 37.5 hours

Job Type: Permanent

Pay Band: Band 7

An exciting opportunity has arisen within the Data Services team for a motivated, enthusiastic and innovative person for the role of a Senior Data Engineer. The successful post holder will support the Data Services team where you will be involved in the production, management and development of new and existing data warehouse and data marts. Additionally you will be involved in requirement gathering, design, development, testing, roll out and training.

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 significant data warehousing development experience within Microsoft environment. Advanced SQL development, ETL/ELT, BI Reporting, dimensional modelling experience required. Working experience of SSRS, Power BI, DAX, Azure will be beneficial.

Knowledge and working in Agile development environments and a willing to research, learn new and exciting technologies will be advantageous.

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.

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 sites.

NWAS is an inclusive employer and welcomes applications from all under represented groups to ensure our workforce reflects the diversity of the communities we serve.

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.

Date posted

17 July 2023

Pay scheme

Agenda for change

Band

Band 7

Salary

£43,742 to £50,056 a year per annum

Contract

Permanent

Working pattern

Full-time

Reference number

242-3841

Job locations

Business Intelligence (Parkway 4)

Parkway 4

Parkway Manchester

M14 7LU


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 before applying.

SJT Live date 04/08/2023 Closes 09/08/2023

Assessment Date 15/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 before applying.

SJT Live date 04/08/2023 Closes 09/08/2023

Assessment Date 15/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 presentation 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.
  • Ability to delegate responsibility and tasks to ensure delivery to agreed objectives.
  • Advanced user of information systems such as Microsoft Office Suite.
  • Highly skilled in use of SQL Server.
  • High level of Database Administrative Skills.
  • Ability to self-direct in all areas of work and be capable of making decisions within remit of the post.
  • High level of skills in SQL, SharePoint BI products, ASP and .NET.
  • High level of skills in ASP/VB .NET / HTML.
  • Enthusiastic and positive approach to work.
  • A team player with self-motivation and drive.
  • Good attention to detail.
  • Flexible approach to working arrangements.
  • Advanced keyboard skills and a high level of accuracy when manipulating data.

Qualifications and Knowledge

Essential

  • Educated to Degree level or equivalent.
  • Relevant postgraduate level qualification (e.g. Informatics, Operational Research).
  • Evidence of further personal development.

Experience

Essential

  • Experience of contributing to projects using a proven Project Methodology.
  • Experienced user of SQL Server Reporting Services (SSRS).
  • Experience of working in a development environment.
  • Experience of producing detailed reports.
  • Experience of modelling of business activities.
  • Experience of overcoming issues & problems.
  • Significant experience in the NHS.
  • Understanding of Information Governance.
  • Understanding of Information reporting methods.
  • Understanding of NHS information requirements.
  • A sound understanding of business process and importance of quality data.
  • Understanding of the project lifecycle.
  • Knowledge of the NHS and Health and Social Care Information Centre.
  • Understanding of the Ambulance Service.
  • Budget management.

Working Practice

Essential

  • Physical skills - Keyboard and driving skills required.
  • Freedom to Act - Ability to act on own decisions
  • Physical Effort - Combination of sitting, standing, walking and driving is a requirement.
  • Working Conditions - Office based with requirement to travel throughout the region and nationally.

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 presentation 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.
  • Ability to delegate responsibility and tasks to ensure delivery to agreed objectives.
  • Advanced user of information systems such as Microsoft Office Suite.
  • Highly skilled in use of SQL Server.
  • High level of Database Administrative Skills.
  • Ability to self-direct in all areas of work and be capable of making decisions within remit of the post.
  • High level of skills in SQL, SharePoint BI products, ASP and .NET.
  • High level of skills in ASP/VB .NET / HTML.
  • Enthusiastic and positive approach to work.
  • A team player with self-motivation and drive.
  • Good attention to detail.
  • Flexible approach to working arrangements.
  • Advanced keyboard skills and a high level of accuracy when manipulating data.

Qualifications and Knowledge

Essential

  • Educated to Degree level or equivalent.
  • Relevant postgraduate level qualification (e.g. Informatics, Operational Research).
  • Evidence of further personal development.

Experience

Essential

  • Experience of contributing to projects using a proven Project Methodology.
  • Experienced user of SQL Server Reporting Services (SSRS).
  • Experience of working in a development environment.
  • Experience of producing detailed reports.
  • Experience of modelling of business activities.
  • Experience of overcoming issues & problems.
  • Significant experience in the NHS.
  • Understanding of Information Governance.
  • Understanding of Information reporting methods.
  • Understanding of NHS information requirements.
  • A sound understanding of business process and importance of quality data.
  • Understanding of the project lifecycle.
  • Knowledge of the NHS and Health and Social Care Information Centre.
  • Understanding of the Ambulance Service.
  • Budget management.

Working Practice

Essential

  • Physical skills - Keyboard and driving skills required.
  • Freedom to Act - Ability to act on own decisions
  • Physical Effort - Combination of sitting, standing, walking and driving is a requirement.
  • Working Conditions - Office based with requirement to travel throughout the region and nationally.

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.

Certificate of Sponsorship

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.

Certificate of Sponsorship

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).

Employer details

Employer name

North West Ambulance Service NHS Trust

Address

Business Intelligence (Parkway 4)

Parkway 4

Parkway Manchester

M14 7LU


Employer's website

https://www.nwas.nhs.uk/ (Opens in a new tab)


Employer details

Employer name

North West Ambulance Service NHS Trust

Address

Business Intelligence (Parkway 4)

Parkway 4

Parkway Manchester

M14 7LU


Employer's website

https://www.nwas.nhs.uk/ (Opens in a new tab)


For questions about the job, contact:

Business Analyst

Alal Miah

Alal.Miah@nwas.nhs.uk

Date posted

17 July 2023

Pay scheme

Agenda for change

Band

Band 7

Salary

£43,742 to £50,056 a year per annum

Contract

Permanent

Working pattern

Full-time

Reference number

242-3841

Job locations

Business Intelligence (Parkway 4)

Parkway 4

Parkway Manchester

M14 7LU


Supporting documents

Privacy notice

North West Ambulance Service NHS Trust's privacy notice (opens in a new tab)