Data Engineer

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

Benefits offered by this job

Private Medical Insurance

Holiday Buy/Sell Days

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 design and build data pipelines, data models and integrations to support analytics and reporting.

You will work with the Data Engineering Lead, Architects and Analysts to deliver reliable, scalable data solutions. Strong hands-on experience with Azure Data Factory, Databricks, Python and SQL is required. A hybrid working pattern is offered.

Qualifications

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

Responsibilities

• 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 to support analytics and reporting, following modelling standards.
• Contribute to data lineage, metadata management and cataloguing practices, including exposure to Purview.
• Collaborate with Lead Data Engineer, Analysts and Architects to develop and improve engineering standards.
• Collaborate with other engineers through pairing, code reviews and shared problem-solving.

Skills

Python

SQL

Spark

Data Modelling

ETL/ELT

Star Schema

Dimensional Modelling

Tools

Azure Data Factory

Databricks

Azure 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

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