Analytics Engineer II

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. 

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

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

1. Initial call with your dedicated Talent Acquisition Partner, carried out remotely. 
2. Sometimes the process will include a take home task, or a presentation of some kind.
3. Skills interview, usually carried out remotely. 
4. Behaviours interview, usually carried out in person.
5. 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. 

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

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.