Analytics Engineer

Butternut Box; City Of London; On-site; GBP 40,000 - 55,000; Full time

Job summary

A pet food company in London is hiring a mid weight Analytics Engineer to enhance data systems and reporting capabilities. This role involves building and maintaining data models and working closely with teams to derive clean datasets. Ideal candidates should have robust SQL and dbt skills, with a passion for data-driven decision making. The position offers a hybrid working environment.

Benefits

25 days holiday plus 8 bank holidays

£500 personal learning & development budget

Flexible working hours and work from home options

Private Medical Insurance

Discounted gym access

Qualifications

• Experience using dbt to build production-grade data models.
• Excellent SQL skills with knowledge on query performance optimisation.
• Ability to explain complex data concepts to both technical and non-technical stakeholders.

Responsibilities

• Work with engineering teams to ensure source data modeling meets requirements.
• Maintain and develop SQL data transformations in dbt.
• Define best practices for data modeling and advise data analysts.

Skills

SQL

dbt

Looker

Python

Tools

AWS

Git

Job description

Overview

We’re hiring a mid weight 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.

Responsibilities

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

Role location and work pattern

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…)

Notes

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

#LI-Hybrid