Senior Data Engineer

Menzies LLP; City Of London; On-site; GBP 90,000 - 120,000; Full time

Benefits offered by this job

Career development

Private medical cover

Pension matching

Flexible working

Job summary

Menzies LLP is seeking a Senior Data Engineer to lead the development and operation of our GCP data warehouse. You will design scalable data pipelines and champion best practices across data modelling, testing and governance.

You’ll mentor engineers, partner with stakeholders, and enable accessible data outputs via Power BI and internal apps. London-based with flexible hybrid options may apply.

Qualifications

• Strong SQL and Python skills with production data solutions.
• Experience with cloud data warehouses, preferably BigQuery.
• Knowledge of GCP ecosystem and data security/governance responsibilities.
• Ability to lead, mentor and raise engineering standards across the team.

Responsibilities

• Lead design and delivery of scalable data pipelines into BigQuery from diverse sources.
• Shape engineering approach across GCP including BigQuery, Cloud Storage, Pub/Sub, Datastream, Cloud Composer/Airflow.
• Set high engineering standards across data modelling, dbt, testing, monitoring, deployment and cost optimization.
• Collaborate with teams to turn business needs into scalable data products.

Skills

SQL

Python

BigQuery

GCP

Airflow/Cloud Composer

dbt

Git/GitHub

Terraform

Data modelling

Data security & governance

Leadership

Education

Degree in computer science or related field

Tools

BigQuery

Cloud Composer/Airflow

dbt

Git

Terraform

Job description

Senior Data Engineer

Department: IT & Innovation

Employment Type: Full Time

Location: London Office

Description

Menzies is an equal opportunities employer which means that we recruit, employ, train, pay, and promote regardless of race, religion, national origin, gender, sexual orientation, disability or age. We are building a first-class team and, to do so, we know that we need a diverse mix of talented people doing their best work.

If you’re ready to make an impact, lead with purpose, and work in a place where your voice truly matters, keep reading!

We have a great opportunity for a Senior Data Engineer to join our team and can be based from any of our Menzies offices.

The purpose of this role is to lead the development and operation of Menzies’ GCP data warehouse, creating a trusted, secure and accessible data foundation that enables insightful reporting, automation and AI, and supports smarter decision-making across the firm.

Why Menzies?

At Menzies, our culture is our cornerstone. We blend technical excellence with genuine care for our people and clients. With over 1100 colleagues in the UK, we’ve built a culture based on shared values and mutual respect. Here’s why you’ll love working with us:

• People First: Our work-life balance isn’t just talk. From agile working to generous leave, we create space for what matters to you and this is why we were recognised as one of the Best Places to Work 2024, 2025 and now also 2026
• Work with Inspiring Clients: You’ll be working with a range of clients so no two days will be the same.
• Collaborate Across The Firm: Working with various people across the firm to raise the profile of Menzies Academy
• Innovate with Purpose: We’re always looking for better ways to work—leveraging tech, simplifying complexities, and delivering value.
• Empathy at Our Core: We don’t just serve our clients; we build trusted relationships that stand the test of time.

Key Responsibilities

Here’s what you’ll be doing:

• Lead the design and delivery of scalable, resilient data pipelines into BigQuery, integrating data from a wide range of internal systems, APIs, databases, files, webhooks and event streams.
• Shape the engineering approach across Google Cloud Platform (GCP), working with technologies including BigQuery, Cloud Storage, Pub/Sub, Datastream and Cloud Composer/Airflow, alongside Terraform and infrastructure-as-code.
• Set and champion high engineering standards across data modelling, dbt (data build tool) transformations, testing, monitoring, documentation, deployment, version control and cost optimisation.
• Partner with teams across the firm to turn business needs into scalable, reusable data products, bringing together data from external and internal sources such as Companies House, HMRC, Exchange Online, Active Directory, iManage and Dayshape.
• Embed security, governance and data quality by design, ensuring appropriate controls around data lineage, access, GDPR compliance, least-privilege security and the handling of sensitive client, HR, payroll and financial information.
• Provide technical leadership to the wider team, reviewing designs and code, mentoring data engineers and analysts, and helping to strengthen engineering capability across the Innovation Team.
• Enable data to deliver real business value by working with developers and analysts to make warehouse outputs accessible through Power BI, automation workflows, AI agents and internal applications.
• Evaluate technology and integration options, making pragmatic build-versus-buy recommendations that balance business value, security, scalability, supportability and cost.
• Champion data enablement across Menzies, supporting colleagues to confidently access, understand and use data safely and effectively.
• Help shape the Innovation Team roadmap, prioritising strategic, repeatable platforms and solutions that can deliver value across the firm rather than one-off fixes.

Skills, Knowledge & Expertise

What We’re Looking For

We’re looking for an experienced and curious data professional who combines strong technical expertise with a practical, people-focused approach. You’ll be comfortable taking ownership, making sound technical decisions and bringing others with you; whether you’re mentoring colleagues, partnering with stakeholders or turning a complex business challenge into a scalable solution.

You don’t need to tick every box. We’re interested in people who can bring the right mix of experience, technical capability and ambition to help us continue developing our data and innovation capability.

What you’ll bring

• Strong hands-on experience in data engineering, analytics engineering or data platform roles, typically gained over 5+ years, with experience operating at a senior or leadership level.
• Advanced SQL and Python skills and experience using them to build reliable, production-ready data solutions.
• Strong experience with cloud data warehouses, ideally BigQuery, and a good working knowledge of the wider Google Cloud Platform (GCP) ecosystem.
• Experience with modern data engineering tools and practices such as Airflow/Cloud Composer, dbt, Git/GitHub, CI/CD and Terraform or other infrastructure-as-code tooling.
• A solid understanding of data modelling, dimensional modelling, orchestration, testing, data quality and operational monitoring, with a focus on building solutions that are scalable and maintainable.
• Experience designing and operating production-grade data pipelines, integrating data from sources such as APIs, databases, flat files, webhooks and message queues.
• A strong appreciation of data security and governance, including GDPR, role-based access, secrets management and the responsible handling of sensitive information.
• The ability to take an ambiguous business challenge and turn it into a clear, pragmatic technical solution, balancing immediate needs with longer‑term value.
• Strong communication and stakeholder skills, with the confidence to make complex technical concepts accessible to non-technical audiences and influence decisions at different levels.
• A collaborative leadership style, with a genuine interest in coaching others, sharing knowledge and raising engineering standards across the team.

Qualifications & experience

A degree or equivalent experience in computer science, data engineering, software engineering, mathematics, statistics or a related technical discipline would be beneficial. Google Cloud, dbt or other relevant data engineering certifications are also welcomed, although practical experience and demonstrable expertise are just as important to us.

Experience within professional services, finance, accounting, legal, tax, audit or another regulated environment would be an advantage, but it isn’t essential.

Above all, we’re looking for someone who brings ownership, sound judgement and a delivery mindset. You’ll enjoy solving problems, challenging how things are done and finding better ways of working, while maintaining a strong focus on quality, security and risk.

The role may involve occasional travel to other Menzies offices for workshops, discovery sessions, implementation support and team meetings.

Job Benefits

Why Join Us?

At Menzies, we know that success starts with our people. That’s why we offer:

• Career Development: From learning opportunities to career coaching, we’ll help you achieve your goals.
• Competitive Benefits: Private medical cover, pension matching, and enhanced parental leave, to name a few.
• Flexibility That Works for You: Agile working is embedded in our culture.
• Perks That Go Beyond: From volunteering days to wellbeing initiatives, we care about your whole self.

To find out more about our benefits please read here.