Analytics Engineer II

Butternut Box; Greater London; On-site; GBP 55,000 - 75,000; Full time

Job summary

Butternut Box in London is looking for a mid-level Analytics Engineer to join our data team. You will work with data analysts and data scientists to create clean, tested, well-documented datasets that support experimentation through production analytics.

Our stack includes Snowflake, dbt, Looker, Python and AWS, with GitHub for CI/CD. You’ll build foundational data models and advance analytics using AI tools to help colleagues make data-driven decisions and improve data reliability across the

Qualifications

• You have experience using dbt to build production-grade data models and test suites.
• You have practical experience writing maintainable Python code for data processing, automation or integrations.
• You bring an engineering mindset to data, with a focus on testing, documentation and maintainability.
• You have excellent SQL skills, including a solid understanding of how to optimise query performance.
• You have a good practical understanding of version control and Git.
• You have natural curiosity and a keen eye for detail.
• You can explain complex processes, requirements and data concepts to both technical and non-technical stakeholders.
• You work collaboratively with technical teams and business stakeholders to understand requirements and develop useful solutions.
• Experience building and maintaining ETL or ELT pipelines.
• Experience with AWS.
• Experience with BI tools, Looker/LookML/Looker API.
• Experience with generative AI or agentic tools, or an interest in learning how to use them safely to provide value from data.

Responsibilities

• Build and maintain foundational data models that support reporting, data science and self-serve analytics.
• Build next generation analytics using generative AI and agentic tools to help colleagues get more value from data.
• Use Python to automate workflows and improve reliability and efficiency of data systems.
• Collaborate with data analysts and data scientists to support experimentation to production.
• Work with in-house product engineering to ensure source data supports downstream requirements.
• Develop SQL transformations, tests and documentation in dbt.

Skills

dbt

Python

SQL

Git

Communication

Team collaboration

Problem solving

Tools

Snowflake

dbt

Looker

Python

AWS

GitHub

Job description

We believe dogs deserve the healthiest, most natural and tastiest meals - with none of the nasties. That’s why we make FRESHly prepared food, cooked just like you would at home and delivered direct to our customers in perfect portions. As a B-Corp certified company, you’re joining a sustainable business that genuinely cares about our people, our products and our impact on the planet. Our goal is simple: to help dogs live healthier, happier, and longer lives, while leaving humans smiling after every interaction.

We’ve come a long way since our co-founders (Kev & Dave), hand delivered the very first Butternut Box. Today, we feed hundreds of thousands of hungry dogs across the UK and Europe - but we won’t stop until we’re feeding dogs everywhere. To get there, we need a team of brilliant people who share that ambition to come and work for us.

The job:

A bit about data at Butternut: We’re hiring a mid-level Analytics Engineer to join our data team at Butternut. In this role, you'll work closely with our data analysts and data scientists to create clean, tested, well-documented and well-modelled datasets. Your work will support teams and projects across the business, from experimentation to production.

Our data stack includes Snowflake for data warehousing, dbt for data transformation and testing, and Looker for business intelligence. We also use Python for automation and integrations, AWS for infrastructure, and GitHub for version control and CI/CD.

You’ll build and maintain foundational data models that support reporting, data science and self-serve analytics. You’ll have the opportunity to build next generation analytics using generative AI and agentic tools to help your colleagues across the business get more value from the data. Alongside this, you’ll use Python to automate workflows and improve the reliability and efficiency of our data systems, making it easier for colleagues to access and use data confidently.

If you enjoy solving problems, building reliable systems and helping people make better decisions with data (and you love dogs), this might be the role for you.

You can expect to get stuck into:

• Working with our in-house product engineering teams to ensure source data supports downstream requirements.
• Building and maintaining SQL transformations, tests and documentation in dbt.
• Developing Python code to automate data workflows and integrate systems.
• Contributing to data modelling best practices and advising the team on how to write reliable, maintainable transformations.
• Working with stakeholders across the business to make clean, intuitive datasets available through Looker and AI data analyst tools.
• Working with our analysts and data scientists to identify opportunities to improve data quality, optimise performance and automate manual processes.

Please note that this is not an exhaustive list, but is intended to give you an indication of what your day-to-day might look like here at Butternut.

What we're looking for:

• You have experience using dbt to build production-grade data models and test suites.
• You have practical experience writing maintainable Python code for data processing, automation or integrations.
• You bring an engineering mindset to data, with a focus on testing, documentation and maintainability.
• You have excellent SQL skills, including a solid understanding of how to optimise query performance.
• You have a good practical understanding of version control and Git.
• You have natural curiosity and a keen eye for detail.
• You can explain complex processes, requirements and data concepts to both technical and non-technical stakeholders.
• You work collaboratively with technical teams and business stakeholders to understand requirements and develop useful solutions.

It would be a bonus if you have:

• Experience building and maintaining ETL or ELT pipelines.
• Experience with AWS.
• Experience with BI tools, particularly Looker, LookML or the Looker API.
• Experience with generative AI or agentic tools, or an interest in learning how to use them safely to provide value from data.

The interview process:

• Initial call with your dedicated Talent Acquisition Partner, carried out remotely.
• Sometimes the process will include a take home task, or a presentation of some kind.
• Skills interview, usually carried out remotely.
• Behaviours interview, usually carried out in person.
• Depending on the seniority of the role you're applying for, there may be a final Leadership interview as a final step.

We usually expect our interview process to take 3-5 weeks, end to end.

Important things to note:

• We recommend getting your application in as soon as possible. We reserve the right to close the role early.

Our team thrives on collaboration. We spend3 days a week in our West London office (Monday, Wednesday, and Thursday) and 2 days working from wherever you’re most productive. Because being together is a big part of our culture, we’re looking for someone within a comfortable commutable distance to London.

We’re a small (but mighty!) recruitment team. We aim to respond to everyone personally, but if we’re flooded with brilliant applications, we may need to close the role early. We appreciate your patience while we review applications.

For this specific role, we’re unable to offer visa sponsorship, so you’ll need the right to work in the UK.

We believe in a seat at the table for everyone.

Butternut Box is an equal opportunity employer. We believe that to make the best food for all dogs, we need a team that represents all humans. We celebrate different nationalities, backgrounds, experiences and perspectives. We are specifically committed to increasing representation from underrepresented groups. We want a strong, diverse team built from different identities and lived experiences. We’re not perfect, but we are dedicated to the ongoing work of building an inclusive, supportive place where you can do the best work of your career.