Data Engineer

ICAEW; Milton Keynes; Hybrid; GBP 48,000 - 53,000; Full time

Benefits offered by this job

Private Medical Insurance

24 days holiday

Gym discounts

Travel loans

Retail perks

Enhanced family leave

Wellbeing support

Volunteer day

Job summary

ICAEW in Milton Keynes is seeking a Data Engineer to join the team on a permanent basis with a hybrid work pattern. The role offers a salary of £48,000 - £53,000 per annum.

You will help evolve how data is ingested, modelled and shared across the organisation to improve analytics, reporting and decision-making across business areas.

Qualifications

• Solid hands-on experience with Azure Data Factory, including end-to-end pipeline delivery.
• Proficient in Python, Spark and SQL for data processing and transformation.
• Experience with Databricks in a production or near-production environment.
• Practical experience building and maintaining ETL/ELT pipelines in a cloud environment.
• Working knowledge of data modelling concepts including star schema and dimensional modelling.

Responsibilities

• Build and maintain data pipelines, ingestion processes and integrations as part of data engineering initiatives.
• Develop and maintain datasets and data models to support analytics and reporting.
• Contribute to data lineage, metadata management and cataloguing practices.
• Collaborate with Lead Data Engineer, Analysts and Architects to improve engineering standards.
• Pairing with other engineers, code reviews and shared problem-solving.

Skills

Azure Data Factory

Python

Spark

SQL

Databricks

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 Engineer to join our team in Milton Keynes on a permanent basis. This role offers a salary of £48,000 - £53,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 a Data Engineer, you will design and build data pipelines, integrations and data models that support these initiatives. Working closely with the Data Engineering Lead, Architects and Analysts, you'll contribute to the team's engineering practices and help deliver reliable, scalable data solutions that enable colleagues to make better use of data.

What you will be doing:

• Build and maintain robust data pipelines, ingestion processes and integrations using Azure Data Factory and Databricks and related services.
• Develop and maintain datasets and data models that support analytics and reporting, following established modelling standards
• Contribute to data lineage, metadata management and cataloguing practices, including exposure to Purview
• Work closely with the Lead Data Engineer, Analysts and Architects to develop and improve engineering standards and practices
• Collaborate with other engineers through pairing, code reviews and shared problem-solving

What you will need:

• Solid hands‑on experience with Azure Data Factory, including end‑to‑end pipeline delivery
• Proficient in Python, Spark and SQL for data processing and transformation
• Experience with Databricks in a production or near‑production environment
• Practical experience building and maintaining ETL/ELT pipelines in a cloud environment
• Working knowledge of data modelling concepts including star schema and dimensional modelling

Please see full job description attached.

What you can expect from us

We believe doing your best work starts with feeling supported both professionally and personally. That's why we offer a range of benefits designed to give you flexibility, security, and peace of mind:

• 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