Senior Data Engineer

Menzies LLP; Horsell; On-site; GBP 80,000 - 110,000; Full time

Benefits offered by this job

Career Development

Competitive Benefits

Flexibility That Works for You

Perks That Go Beyond

Job summary

Menzies LLP is seeking a Senior Data Engineer to lead the development and operation of the firm's GCP data warehouse from our Woking office. You’ll design scalable pipelines, champion data governance, and enable insights through Power BI and automation.

You’ll shape the data platform across the firm, mentor colleagues, and collaborate with teams to deliver secure, scalable data products. Occasional travel to other offices may be required.

Qualifications

• 5+ years in data/analytics platform roles at senior or lead level.
• Strong SQL and Python for production data solutions.
• Experience with Cloud data warehouses, BigQuery and GCP ecosystem.
• Experience with Airflow/Cloud Composer, dbt, Git, CI/CD and Terraform or similar IaC tooling.
• Solid understanding of data modelling, orchestration, testing, data quality and monitoring.
• Ability to design and operate production-grade data pipelines integrating APIs, databases and files.
• Strong focus on data security, GDPR compliance and governance.
• Ability to turn ambiguous business needs into pragmatic technical solutions.
• Excellent communication and willingness to coach others across the team.

Responsibilities

• Lead the design and delivery of scalable data pipelines into BigQuery from diverse sources.
• Shape the engineering approach across GCP with tools like BigQuery, Pub/Sub, Datastream and Airflow.
• Set high engineering standards for modelling, testing, deployments and cost optimization.
• Collaborate with internal teams to create scalable data products and data access through Power BI and automation.
• Embed security and governance by design across data lineage, access controls and sensitive data handling.
• Provide technical leadership, review designs, mentor engineers and strengthen team capabilities.
• Enable data to deliver business value with accessible warehouse outputs and AI workstreams.
• Evaluate build-vs-buy options balancing value, security, and cost.
• Promote data enablement and safe data usage across Menzies; influence roadmap.

Skills

Data engineering

Analytics engineering

SQL

Python

BigQuery

Google Cloud Platform (GCP)

Airflow

dbt

Git

Terraform

CI/CD

Data modelling

Data security and governance

Leadership / mentoring

Education

Degree in Computer Science or related

Tools

Cloud Composer

Power BI

Job description

Department: IT & Innovation

Employment Type: Full Time

Location: Woking Office

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