OverviewWe’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 enable 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 help develop 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. ResponsibilitiesWorking 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).Collaborating with our in-house data team (analysis and science) to identify areas needing optimisation or more automation.note: this is not an exhaustive list, but rather an indication of what your day-to-day might look like here at Butternut.A bit about youYou 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.Nice to haveExperience with Looker and the Looker API.Python coding skills, particularly in the areas of automation & integrations.Experience with AWS.Location and work arrangementThis role is London-based, with 3 days a week in the office and 2 days working from home (Tuesday & Friday). Our offices are in White City.About ButternutAt 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-HybridAs 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, and we want to feed dogs everywhere. To do this, we need a team of brilliant people who share that ambition to come and work with us.What we offer25 days holiday (plus 8 bank holidays) and an additional day for every year of service5 paid 'paws' days per year to support learning and/or wellbeing£500 personal learning & development budgetButternut Box employee discountEnhanced parental leave (52 weeks’ maternity leave inclusive of 26 weeks fully paid and 6 weeks fully paid paternity/secondary leave)Co-working office spaceFlexible working hours and work from home optionsCycle to work schemePension with NESTPrivate Medical Insurance with VitalityPrivate Dental Insurance with BupaTime off for fertility treatments and pregnancy lossPaid sabbaticals for squad members with 5 or more years at ButternutDiscounted gym access through My Gym DiscountsLots of office dogs (Ajax, Brio, Basil, Chorizo, Lenny, Jasper, Peggy, Pip and many more…)Equality and inclusionButternut Box is an equal opportunity employer and we value diversity and inclusion. We welcome people of different nationalities, backgrounds, experiences, abilities and perspectives.We are committed to social and environmental responsibility and to continually improving our impact.We are building diverse teams from different backgrounds, experiences, and identities to create an inclusive, supportive place for the best work of your career.How to applyPlease read through our Candidate Privacy Notice. It’s important. This posting does not include application forms or additional prompts here. #J-18808-Ljbffr