Location
London, with a hybrid working model: 3 days a week in the West London office (Monday, Wednesday, Thursday) and 2 days remote.

Hours
Full Time

Salary
£500 per annum

About the Role
Butternut Box is a B-Corp certified company dedicated to providing fresh, natural, and healthy meals for dogs. We are on a mission to help dogs live healthier, happier, and longer lives while delivering exceptional experiences to our customers. As an Analytics Engineer II, you will join our data team to build clean, tested, and well-documented datasets that support business-wide projects from experimentation to production. You will work closely with data analysts, data scientists, and product engineering teams to maintain and improve our data infrastructure using Snowflake, dbt, Looker, Python, AWS, and GitHub.

Your responsibilities will include building and maintaining SQL transformations and tests in dbt, developing Python automation scripts, contributing to data modelling best practices, and collaborating with stakeholders to deliver intuitive datasets through Looker and AI tools. You will also explore next-generation analytics using generative AI to enhance data accessibility and value across the business.

This role is ideal for someone who enjoys solving problems, building reliable data systems, and helping teams make better data-driven decisions in a collaborative and mission-driven environment.

Experience
- Proven experience using dbt to build production-grade data models and test suites.
- Practical experience writing maintainable Python code for data processing, automation, or integrations.
- Strong SQL skills with a solid understanding of query performance optimization.
- Familiarity with version control systems, particularly Git.
- Experience collaborating with technical teams and business stakeholders to deliver data solutions.

About you
- An engineering mindset focused on testing, documentation, and maintainability.
- Natural curiosity and keen attention to detail.
- Ability to explain complex data concepts clearly to both technical and non-technical audiences.
- Collaborative team player who thrives in a fast-paced environment.

Qualifications
- While formal qualifications are not specified, relevant experience in analytics engineering, data modelling, and Python development is essential.

Desirable
- Experience building and maintaining ETL or ELT pipelines.
- Familiarity with AWS infrastructure.
- Experience with BI tools such as Looker, LookML, or the Looker API.
- Interest or experience in generative AI or agentic tools to enhance analytics capabilities.

Additional Information
- Right to work in the UK is required; visa sponsorship is not available.
- The role requires presence in London for office days, so candidates should be within a comfortable commuting distance.