Analytics Engineer

Butternut Box; London; Hybrid; GBP 50,000 - 70,000; Full time

Job summary

Butternut Box is seeking a mid-level Analytics Engineer to join our data team in London. You'll play a vital role in building and maintaining efficient data systems to enable data-driven decisions across the business. If you're skilled in SQL, dbt, and enjoy collaborative environments, this role offers the chance to impact our analytics and reporting capabilities significantly.

Benefits

25 days holiday plus bank holidays

5 paid 'paws' days for well-being

£500 personal development budget

Flexible working hours and WFH options

Pension with NEST

Private Medical and Dental Insurance

Employee discounts

Cycle to work scheme

Qualifications

• Experience using dbt to build production-grade data models.
• Excellent SQL skills with an understanding of query optimization.
• Familiarity with BI tools, ideally Looker.

Responsibilities

• Constructing and maintaining foundational data models using dbt.
• Enhancing reporting capabilities and ensuring data integrity.
• Working with stakeholders to surface clean, intuitive datasets.

Skills

SQL

dbt

Data Modeling

Version Control

Automation

Tools

Looker

Job description

We’re hiring a mid-level Analytics Engineer to join our data team at Butternut. In this role, you'll work closely with our business intelligence analysts to create clean, tested, well-documented, and well modelled data sets. Your work will be key in enabling both our data team and business users across the business, so you’ll feel the impact of your work quickly.

You'll actively contribute to enhancing our reporting capabilities, by building robust systems that prioritise integrity and reliability. Additionally, you'll play a role in developing a self-serve analytics approach, empowering more team members at Butternut to conduct independent analysis. Your focus will be on constructing and maintaining foundational data models using dbt, forming the backbone for data science and analytics at Butternut.

If you're passionate about addressing challenges head on, fostering innovation, and contributing to data-driven decision-making (and you love dogs), this might be the role for you.

You can expect to get stuck into:

• Working with in-house product engineering teams to ensure modelling of source data meets downstream requirements.
• Maintaining and developing SQL data transformations in dbt.
• Defining best practices for data modelling, whilst also advising data analysts on how best to write data transformations.
• Working with stakeholders across the business to surface clean, intuitive datasets in our BI tool (we use Looker).
• Working with our in-house data team (analysis and science) to identify areas needing optimisation or more automation.

*please note that this is not an exhaustive list, but rather intended as an indication of what your day to day might look like here at Butternut.

A bit about you.

• You have experience using dbt to build production-grade data models and test suites.
• You bring an engineering mindset to data (our data team sits within the software engineering department).
• Excellent SQL skills, including a solid understanding of how to optimise query performance.
• Good practical understanding of version control and git.
• Experience with BI tools, ideally Looker.
• You have technical expertise regarding data models and database design development.
• You have natural curiosity and a keen eye for detail.
• You can break down and explain complex processes, requirements and data concepts to both technical and non-technical stakeholders.
• You are a team-player who can work effectively within technical and with non-technical stakeholders to understand requirements.

It would be a bonus if you have:

• Experience with Looker and the Looker API.
• Python coding skills, particularly in the areas of automation & integrations.
• Experience with AWS.

This role is London-based, with 3-days a week being in the office, and 2-days being work from home (Tuesday & Friday). Our offices are in White City.

A bit about us.

At Butternut, we put the food back into dog food. We believe dogs deserve to eat the healthiest, most natural and tastiest food with none of the nasties. That’s why we make freshly prepared dog food. Cooked like you would at home. Delivered in perfect portions. #LI-Hybrid

As a B-Corp certified company; you can be sure you are joining a sustainable company who care about our people, product and our impact on the environment.

Our goal is to help dogs live healthier, happier and longer lives whilst leaving humans smiling after every interaction. We’ve come a long way since our co-founders (Kev & Dave) hand-delivered the first Butternut Box, we now feed a lot of dogs across the UK - but we want to feed dogs everywhere. And to do this, we need a team of brilliant people who share that ambition to come and work with us.

A bit about what we offer.

• 25 days holiday (plus 8 bank holidays) and an additional day for every year of service
• 5 paid 'paws' days per year to support to learning and/or wellbeing
• £500 personal learning & development budget
• Butternut Box employee discount
• Enhanced parental leave (52 weeks’ maternity leave inclusive of 26 weeks fully paid and 6 weeks fully paid paternity/secondary leave)
• Co-working office space.
• Flexible working hours and work from home options
• Cycle to work scheme
• Pension with NEST
• Private Medical Insurance with Vitality
• Private Dental Insurance with Bupa
• Time off for fertility treatments and pregnancy loss
• Paid sabbaticals for squad members with 5 or more years at Butternut
• Discounted gym access through My Gym Discounts
• Lots of office dogs (Ajax, Brio, Basil, Chorizo, Lenny, Jasper, Peggy, Pip and many more….)

️A few things to note:

• Butternut Box is an equal opportunity employer and we value diversity and inclusion. We welcome people of different nationalities, backgrounds, experiences, abilities and perspectives.
• As our business has grown so has our responsibility to our community, our planet and our business. We are not perfect, but we are committed to doing business the right way and continually improving our social and environmentalperformance.
• We're not afraid of putting extra weight on candidates from underrepresented groups. We want strong, diverse teams built from different backgrounds, experiences, and identities. We're ready for the ongoing work that goes into building an inclusive, supportive place for you to do the best work of your career.

Create a Job Alert

Interested in building your career at Butternut Box? Get future opportunities sent straight to your email.

Apply for this job

*

indicates a required field

First Name *

Last Name *

Email *

Phone *

Location (City) *

Resume/CV *

Enter manually

Accepted file types: pdf, doc, docx, txt, rtf

Enter manually

Accepted file types: pdf, doc, docx, txt, rtf

Are you happy to work in our office in White City 3 days a week (Mon, Wed, Thu)? * Select...

What are your salary expectations for this role? (gross/annual) * Select...

Keep in mind that this is an indication only, we will continue this topic of discussion with you during the interview process.

Let us know your UK Right to Work status: * Select...

We need to know if you have the Right to Work (RTW) in the UK before you join us. Telling us this information will not change the result of your application, unless you do need sponsoring and it's a role we can't sponsor.

Anything else you'd like to add...

How did you hear about us? * Select...

Please read through our Candidate Privacy Notice.It's im-pawtent. * Select...

At Butternut Box, we understand and value that every team member is unique and should be supported to do amazing work as their authentic selves. This demographic survey will help us better understand the people that apply to work with us. It’ll help us see how different groups progress through our hiring process and where we need to make improvements to be more inclusive. If you choose to fill it out (optional) your response will not be used in any hiring decision. Select...