North East Ambulance Service NHS Foundation Trust

Senior Data Warehouse Developer

Information:

This job is now closed

Job summary

The Informatics Department in the North East Ambulance Service, has an opportunity for a Senior Data Warehouse Developer to join a growing, dynamic and busy team.

As a Data Warehouse Developer, you will be part of the Development Team where you will be involved in the production of data marts on the Trusts Data Warehouse to specification (which includes: requirement gathering, design, development, testing, roll out and training) to enable integrated reporting across the Trust. You will be involved in the complete ETL process and will lead the Trust in the development of SQL Server and PowerBi based reporting solutions alongside other developers and analysts. You will also be part of a team of like-minded developers working together to ensure Data Warehouse development is of the highest standard. You will be one of the primary points of contact and the point of escalation for all data warehouse related issues.

You will be educated to a degree level or equivalent and have experience working as a Data Warehouse Developer. Experience of working in an agile development environment would be beneficial.

We offer flexible/agile/home working alongside side office-based working.

Main duties of the job

You will carry out application support by dealing with service desk requests, which make up a part of the day-to-day work of the team. This role also includes maintenance and development of the Trusts extensive database infrastructure, and web-based solutions.

The right applicant will be expected to liaise with the services customers to identify their requirements and produce suitable Data Warehouse builds within agreed timescales. Experience of Data Warehousing in a Microsoft environment is required as is experience of the complete ETL and dimensional modelling process. Also, an ability to learn quickly is required and experience of, Azure, SSAS or similar analysis modelling will be a definite advantage.

As a Data Warehouse Developer, we will also ask you to contribute technical advice and direction for the team and to mentor our Developers.

About us

We employ 3,500 staff in 63 locations and serve a population of 2,600,000 in Northumberland, Tyne & Wear, County Durham, and Tees over 3230 square miles.

Many people think the job of the ambulance service is to collect patients and take them to hospital, but we do much more!

Paramedic skills have developed hugely in recent years, meaning we carry out more treatment at the scene and en-route to hospital.

We have a dedicated clinical assessment service that allows us to provide patients with the most appropriate care from the beginning of the patient journey.

We have a specialised branch of the Trust called HART which deal with explosions or terrorist attacks.

Ultimately patients are the heart of everything that we do to support our mission of "safe, effective and responsive care for all".

We value and respect the diversity employees bring to our workplace. We recruit a workforce that reflects the community we serve, and welcome applications from people from all backgrounds. To ensure we deliver on our aims in relation to diversity and inclusion we assess ourselves against a range of frameworks. We are ENEI Gold employer, Disability Confident Leader, Dyslexia Smart Award employer, Dementia Friendly, and part of Mind Blue Light programme and the Race at Work Charter from the Princes Responsible Business Network and are achieving across all objectives in NHS Equality Delivery System.

Details

Date posted

06 July 2023

Pay scheme

Agenda for change

Band

Band 6

Salary

£35,392 to £42,618 a year

Contract

Permanent

Working pattern

Full-time, Flexible working, Home or remote working

Reference number

C9340-SDWD-07-23

Job locations

Ambulance HQ, Bernicia House

Goldcrest Way, Newburn Riverside

Newcastle upon Tyne

NE15 8NY


Job description

Job responsibilities

Please ensure you refer to the job description attached to this advert for full details and responsibilities for the role.

Please be aware although your Base is our Headquarters at Newburn, you will predominately working agile or at home and will be expected to go into our HQ when required

Job description

Job responsibilities

Please ensure you refer to the job description attached to this advert for full details and responsibilities for the role.

Please be aware although your Base is our Headquarters at Newburn, you will predominately working agile or at home and will be expected to go into our HQ when required

Person Specification

Qualifications

Essential

  • Evidence of continued professional development.
  • Qualified to Degree level in an Information Systems related subject.
  • Advanced knowledge of Data Warehousing, Microsoft SQL Server 2012
  • including T-SQL, stored procedures and functions significant experience
  • designing, developing and administrating data warehouse based solutions.
  • Proven knowledge and experience of Microsoft SQL Server Analysis Services and Integration Services.

Experience

Essential

  • Experience in development of data warehouses using star and snowflake schema data models.
  • Experience of SQL Service Analysis Services Tabular Model or development of PowerPivot Models.
  • Experience with DAX expressions and exposure to MDX.
  • Experience with SQL Server Performance monitoring including
  • indexing and ability to isolate issues.
  • Experience of the Microsoft SQL Server Business Intelligence skillset with specific focus on Data Warehousing.
  • Relevant experience in a health or social care setting with an information system development focus.

Desirable

  • Proven experience developing web and windows applications using C# and VB.Net
  • Experience of Microsoft SharePoint and Microsoft SQL Server Reporting Services integration.
Person Specification

Qualifications

Essential

  • Evidence of continued professional development.
  • Qualified to Degree level in an Information Systems related subject.
  • Advanced knowledge of Data Warehousing, Microsoft SQL Server 2012
  • including T-SQL, stored procedures and functions significant experience
  • designing, developing and administrating data warehouse based solutions.
  • Proven knowledge and experience of Microsoft SQL Server Analysis Services and Integration Services.

Experience

Essential

  • Experience in development of data warehouses using star and snowflake schema data models.
  • Experience of SQL Service Analysis Services Tabular Model or development of PowerPivot Models.
  • Experience with DAX expressions and exposure to MDX.
  • Experience with SQL Server Performance monitoring including
  • indexing and ability to isolate issues.
  • Experience of the Microsoft SQL Server Business Intelligence skillset with specific focus on Data Warehousing.
  • Relevant experience in a health or social care setting with an information system development focus.

Desirable

  • Proven experience developing web and windows applications using C# and VB.Net
  • Experience of Microsoft SharePoint and Microsoft SQL Server Reporting Services integration.

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

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 East Ambulance Service NHS Foundation Trust

Address

Ambulance HQ, Bernicia House

Goldcrest Way, Newburn Riverside

Newcastle upon Tyne

NE15 8NY


Employer's website

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

Employer details

Employer name

North East Ambulance Service NHS Foundation Trust

Address

Ambulance HQ, Bernicia House

Goldcrest Way, Newburn Riverside

Newcastle upon Tyne

NE15 8NY


Employer's website

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

Employer contact details

For questions about the job, contact:

Stephen.Woodey@neas.nhs.uk

Stephen Woodey

Stephen.Woodey@neas.nhs.uk

Details

Date posted

06 July 2023

Pay scheme

Agenda for change

Band

Band 6

Salary

£35,392 to £42,618 a year

Contract

Permanent

Working pattern

Full-time, Flexible working, Home or remote working

Reference number

C9340-SDWD-07-23

Job locations

Ambulance HQ, Bernicia House

Goldcrest Way, Newburn Riverside

Newcastle upon Tyne

NE15 8NY


Supporting documents

Privacy notice

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