Data Engineering Lead

ICAEW; Milton Keynes; Hybrid; GBP 75,000 - 85,000; Full time

Benefits offered by this job

Private Medical Insurance

24 days holiday (plus ability to buy/s

Gym discounts

Family leave up to 6 months

Wellbeing support

Volunteer day

Job summary

ICAEW in Milton Keynes is seeking a Data Engineering Lead to provide technical leadership of a two-person team. The role combines hands-on engineering with team management and close work with the Data Analytics & Reporting function.

You will design scalable data architectures, enforce engineering standards and drive delivery across ICAEW's data platforms. A Microsoft-first skill set and cloud data warehouse experience are essential.

Qualifications

• Substantial experience in data engineering with a lead or senior role.
• Proven track record delivering data engineering in a Microsoft-first environment (Azure Data Factory, Databricks, Synapse, Azure Data Lake).
• Hands-on experience building and managing ETL/ELT pipelines, data lakes and data warehouses in a cloud environment.
• Proficient in Python and SQL; familiarity with Scala or R is advantageous.
• Experience with data orchestration and workflow management tooling such as Azure Data Factory or Airflow.

Responsibilities

• Lead, mentor and develop the data engineering team to deliver robust pipelines and platforms.
• Manage delivery of data engineering projects aligned to ICAEW's transformation programme.
• Define and enforce engineering standards and best practices across the team.
• Design scalable data architectures including data lakes, warehouses and integration layers.
• Ensure data is accessible, well-structured and compliant with governance, quality and security requirements.
• Collaborate with Data Analytics & Insights Lead to align engineering and analytics capabilities.

Skills

Azure Data Factory

Databricks

Synapse

Azure Data Lake

Python

SQL

Airflow

Team Leadership

Job description

At The Institute of Chartered Accountants England & Wales (ICAEW), you'll be part of an organisation that's shaping the future of business, finance and the accountancy profession on a global scale. Our bold Direction 2030 strategy puts members, innovation, sustainability and trust at the heart of everything we do; creating an exciting, forward looking environment where your work has real impact. We invest in our people through our benefits package, continuous development and a supportive, inclusive culture that empowers you to grow and thrive. If you're looking for a role with purpose, influence and opportunity, ICAEW is a place where your future can truly take shape.

We're looking for a Data Engineering Lead to join our team in Milton Keynes on a permanent basis. This role offers a salary of £75,000 - £85,000 per annum with a hybrid working pattern.

ICAEW is evolving the way it manages and uses data by modernising how data is ingested, modelled and shared across the organisation. This work will help improve analytics, reporting and decision-making across a wide range of business areas.

As Data Engineering Lead, you will provide technical leadership for ICAEW's data engineering capability, combining hands-on engineering with the leadership of a small team of two data engineers. Working closely with the Data Analytics & Reporting team, Data Architect, Data Governance Manager and wider Technology colleagues, you will establish and embed best practice in data engineering, ensuring data platforms, pipelines and models are secure, scalable and fit for purpose.

What you will be doing:

• Lead, mentor and develop the data engineering team, ensuring delivery of robust, reliable pipelines and platforms
• Manage delivery of data engineering projects, ensuring timely outputs aligned to ICAEW's transformation programme
• Define and enforce engineering standards, patterns and best practices across the team
• Design and implement scalable data architectures including data lakes, warehouses and integration layers
• Ensure data is accessible, well-structured and compliant with governance, quality and security requirements
• Work as a peer to the Data Analytics & Insights Lead, ensuring engineering and analytics capability develop in step with each other

What you will need:

• Substantial experience in data engineering, with a previous role in a lead or senior engineering capacity
• Proven track record leading data engineering delivery within a Microsoft-first environment - Azure Data Factory, Databricks, Synapse, Azure Data Lake
• Hands-on experience building and managing ETL/ELT pipelines, data lakes and data warehouses in a cloud environment
• Proficient in Python and SQL, familiarity with Scala or R advantageous
• Experience with data orchestration and workflow management tooling such as Azure Data Factory or Airflow

Please see full job description attached.

What you can expect from us

• Private Medical Insurance
• 24 days' holiday, and the option to buy or sell extra days
• Everyday savings through gym discounts, travel loans, and retail perks
• Enhanced family leave, including up to 6 months on full pay
• Ongoing wellbeing support, including access to CABA
• A paid day each year to volunteer for a cause that matters to you

It's all part of creating an environment where you can thrive, in work and beyond. For a full overview of our benefits package please see below.

Additional Information

Who We Are

Diversity & Inclusion

Governance