Kirklees Council

Azure Data Engineer

Information:

This job is now closed

Job summary

About the Role:

This role is one of several new positions weve created to enhance our Data and Insight Service. As an Azure Data Engineer at the Council, you will work with a variety of high-value datasets.

You will modernise the councils dataflows, collaborating with data management and engineering colleagues. Your work will involve innovation and deploying robust practices, including data pipelines and warehouse structures. This role will directly contribute to improving health, social, and economic outcomes across Kirklees and support statutory outputs.

You will lead database design, development, maintenance, and management, utilizing modern data engineering standards to seek out opportunities for efficiency, effectiveness, and innovation. Additionally, you will identify and deploy effective testing regimes and ensure timely resolutions. Documenting and communicating your work and knowledge with colleagues will be crucial in supporting the service, council, and partnership objectives.

This is an exciting time to join us as we build the Councils data engineering and development practice. You will have the opportunity to enhance your Microsoft Azure skills and be part of a journey that includes embedding agile ways of working.

Main duties of the job

Why Join Us?

  • We are a modern and progressive council, committed to family-friendly, flexible, and agile ways of working.
  • Generous pension scheme.
  • 5 days of annual leave (plus public holidays).
  • Engage in exciting career opportunities and contribute to building a strong local democracy.
  • The Council has recently developed an ambitious Data and Insight Strategy and is building a new Data and Insight Function.

About us

About Us:

Kirklees is set in the heart of beautiful West Yorkshire and has a growing population of approximately 440,000. With the two major centres of Huddersfield and Dewsbury, it also encompasses several smaller towns. It is well served by both rail and road networks and is close to Leeds and Manchester.

Other roles you may have experience of could include: Data Engineer, Azure Specialist, Data Solutions Engineer, Data Infrastructure Engineer, Cloud Data Engineer.

Details

Date posted

29 October 2024

Pay scheme

Other

Salary

£49,764 to £51,802 a year

Contract

Permanent

Working pattern

Full-time, Flexible working

Reference number

F0014-13989

Job locations

Kirklees Metropolitan Council

Albion Street

Huddersfield

HD1 2NW


Job description

Job responsibilities

At Kirklees we want to be innovative and creative in the way we work to deliver our services to our communities. We know we have challenging times ahead, so we are always looking for better and smarter ways to work. The role is based within the Councils Data and Insight Service and will design, develop and deliver data products and services that support delivery of business intelligence, analytics and insights to services across the Council.

Key areas of responsibility

Contribute to a successful, efficient, and effective Data and Insight Service, supporting services and decision-makers to understand how much and how well they are doing and what difference they are making to service users, customers, citizens, and communities in Kirklees.

Act on opportunities for collaboration within and between council services and partner organisations to improve data capability, share good practice and foster a culture of continuous improvement.

Positively contribute to the achievement of service, council, and partnership objectives.

Lead the design, development, and implementation of automated data flows to extract, transform and link data sources for analytics and business intelligence systems.

Lead the review and reengineering of manual data flows to enable scaling and repeatable use.

Write ETL and ELT scripts and code and ensure that processes perform optimally.

Build accessible data models for data analysis.

Lead work on database design, development, maintenance, and management.

Identify and act on opportunities to re-use existing data flows.

Lead the design, development, and maintenance of appropriate metadata repositories.

Lead the creation and implementation of appropriate testing regimes to monitor the effectiveness and quality of data engineering work and identify and resolve problems at the earliest opportunity.

Document source-to-target mappings.

Build strong relationships and work with technical and non-technical stakeholders to gather, interpret and analyse data engineering requirements.

Apply best practice data engineering standards and seek out opportunities for efficiency, effectiveness, and innovation.

Apply agile development practices.

Act as a mentor to our SQL Developers.

Deputise for the Data Engineering and Development Lead as required

Job description

Job responsibilities

At Kirklees we want to be innovative and creative in the way we work to deliver our services to our communities. We know we have challenging times ahead, so we are always looking for better and smarter ways to work. The role is based within the Councils Data and Insight Service and will design, develop and deliver data products and services that support delivery of business intelligence, analytics and insights to services across the Council.

Key areas of responsibility

Contribute to a successful, efficient, and effective Data and Insight Service, supporting services and decision-makers to understand how much and how well they are doing and what difference they are making to service users, customers, citizens, and communities in Kirklees.

Act on opportunities for collaboration within and between council services and partner organisations to improve data capability, share good practice and foster a culture of continuous improvement.

Positively contribute to the achievement of service, council, and partnership objectives.

Lead the design, development, and implementation of automated data flows to extract, transform and link data sources for analytics and business intelligence systems.

Lead the review and reengineering of manual data flows to enable scaling and repeatable use.

Write ETL and ELT scripts and code and ensure that processes perform optimally.

Build accessible data models for data analysis.

Lead work on database design, development, maintenance, and management.

Identify and act on opportunities to re-use existing data flows.

Lead the design, development, and maintenance of appropriate metadata repositories.

Lead the creation and implementation of appropriate testing regimes to monitor the effectiveness and quality of data engineering work and identify and resolve problems at the earliest opportunity.

Document source-to-target mappings.

Build strong relationships and work with technical and non-technical stakeholders to gather, interpret and analyse data engineering requirements.

Apply best practice data engineering standards and seek out opportunities for efficiency, effectiveness, and innovation.

Apply agile development practices.

Act as a mentor to our SQL Developers.

Deputise for the Data Engineering and Development Lead as required

Person Specification

Experience

Essential

  • Undergraduate degree which includes a strong data component (e.g.
  • Computer Science, Engineering, Statistics) or equivalent experience
  • Advanced skills in developing databases and transforming, extracting,
  • and manipulating data using SQL.
  • Advanced skills in and significant experience of SQL Server Integration
  • Services (SSIS) development, administration, and deployment.
Person Specification

Experience

Essential

  • Undergraduate degree which includes a strong data component (e.g.
  • Computer Science, Engineering, Statistics) or equivalent experience
  • Advanced skills in developing databases and transforming, extracting,
  • and manipulating data using SQL.
  • Advanced skills in and significant experience of SQL Server Integration
  • Services (SSIS) development, administration, and deployment.

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

Kirklees Council

Address

Kirklees Metropolitan Council

Albion Street

Huddersfield

HD1 2NW


Employer's website

https://www.kirklees.gov.uk/beta/default.aspx (Opens in a new tab)

Employer details

Employer name

Kirklees Council

Address

Kirklees Metropolitan Council

Albion Street

Huddersfield

HD1 2NW


Employer's website

https://www.kirklees.gov.uk/beta/default.aspx (Opens in a new tab)

Employer contact details

For questions about the job, contact:

Jobs

jobs@kirklees.gov.uk

01484221000

Details

Date posted

29 October 2024

Pay scheme

Other

Salary

£49,764 to £51,802 a year

Contract

Permanent

Working pattern

Full-time, Flexible working

Reference number

F0014-13989

Job locations

Kirklees Metropolitan Council

Albion Street

Huddersfield

HD1 2NW


Privacy notice

Kirklees Council's privacy notice (opens in a new tab)