Analytics Engineer II

Butternut Box | B Corp; Greater London; In loco; GBP 60.000 - 90.000; Tempo pieno

Vantaggi offerti da questo lavoro

25 days holiday + 8 bank holidays

Paws days for learning and development

Learning & development budget £500

Share options

Discount on Fresh food for your dog

Enhanced parental leave

Flexible core working hours

Cycle to work scheme

Pension with NEST

Private Medical Insurance with Vitalty

Private Dental Insurance with Bupa

Paid time off for fertility treatments

Paid sabbaticals for long service

Discounted gym access

Office dogs

Descrizione del lavoro

Butternut Box is hiring a mid-level Analytics Engineer to join the data team and build clean, tested datasets. You’ll work with dbt, Python, SQL, Looker and AWS to support reporting, data science and self-serve analytics across the business.

You’ll partner with data analysts and data scientists to deliver reliable, scalable data pipelines and contribute to AI-enabled data initiatives while improving data quality and accessibility.

Competenze

• Experience building production-grade data models with dbt and test suites.
• Strong Python coding for data processing, automation or integrations.
• Excellent SQL skills and query performance optimisation.
• Familiarity with Looker and data visualisation tooling.
• Version control experience with Git/GitHub.

Mansioni

• Build and maintain data models and transformations for reporting and analytics.
• Develop and test SQL transformations and dbt documentation.
• Automate data workflows using Python and integrate systems.
• Collaborate with data analysts/scientists to improve data quality and performance.
• Support Looker-based dashboards and self-serve analytics initiatives.
• Share best practices for reliable, maintainable data pipelines.

Strumenti

dbt

Python

SQL

Looker

AWS

GitHub

Descrizione del lavoro

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.

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:

• 25 days holiday (plus 8 bank holidays) and an additional day for every year of service up to 5 years
• 5 additional, paid 'paws' days off per year dedicated to your learning, development or personal wellbeing. Hit pause when you need it most
• £500 personal learning & development budget to sharpen your skills
• Share options grant - everyone owns a piece of Butternut's success.
• A significant discount on our Fresh food, to keep your own dogs as healthy as our customers
• Enhanced parental leave
• Flexible core working hours
• Cycle to work scheme
• Pension with NEST
• Private Medical Insurance with Vitality
• Private Dental Insurance with Bupa
• Paid time off for fertility treatments and pregnancy loss
• Paid sabbaticals for squad members with 5 or more years service at Butternut
• Discounted gym access through MyGymDiscounts
• Lots of office dogs (Ajax, Peggy, Chief, Louis, Hansen, Winnie and many more….)

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.