A bit about the role

We\'re hiring a Senior 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 MyGymDiscounts
• 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 environmental performance.
• 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.