At a Glance
- Tasks: Transform raw data into insights and build robust data models using dbt and BigQuery.
- Company: Join Zigzag, the top app for dog training, backed by Purina.
- Benefits: Competitive salary, hybrid work, generous holiday, and a £1,000 learning budget.
- Other info: Enjoy a dog-friendly office and flexible working arrangements.
- Why this job: Make a real impact in a fast-paced startup while working with cutting-edge AI tools.
- Qualifications: 2+ years in a data-heavy role and strong SQL skills required.
The predicted salary is between 45000 - 55000 € per year.
Zigzag is the #1 app for dog training & life skills, helping pups and their pawrents build a lifelong bond. Our mission is to prevent behavioural issues or even abandonment by making puppy training accessible and enjoyable for everyone.
We are looking for a curious, impact-driven Analytics Engineer to join our lean data team. You will sit at the intersection of data engineering and business analysis, transforming raw data into reliable, scalable insights.
In this role, you will be the "builder and investigator." You will take ownership of the "last mile" of our analytics stack—crafting dbt models, defining metrics, and partnering directly with Product and Marketing stakeholders to answer critical business questions. You will work closely with our Data Lead, who will guide your technical growth.
We are also a highly forward-thinking team when it comes to artificial intelligence. We use AI tools daily to accelerate our data operations, and the data team plays a key role in supporting the development and quality assurance of new AI features within our app. If you love writing clean SQL, embrace modern AI-assisted workflows, and want to see the direct business impact of your work in a fast-paced startup environment, this role is for you.
You will:
- Build the Foundation: Develop, test, and maintain robust data models using dbt and BigQuery. Transform messy, raw data into clean, business-ready datasets.
- Investigate & Solve: Lead ad-hoc data investigations. When business metrics shift or anomalies appear, you will write the SQL and build the dashboards to explain why.
- Accelerate & Innovate: Actively use AI coding assistants and internal tools to speed up your development cycles, and collaborate with Product to monitor the quality and engagement of our app's AI features.
- Empower Stakeholders: Translate complex stakeholder requirements into self-serve dashboards and semantic metrics using Lightdash and Mixpanel.
- Data Quality: Implement dbt tests and maintain clear documentation to ensure our data remains trustworthy and accessible.
- Collaborate & Learn: Work in a "guided autonomy" model. Execute independently on data modeling and reporting tasks while receiving mentorship on advanced architecture from the Data Lead.
Your profile:
Must-haves:
- 2+ years of experience in a data-heavy role (Data Engineer, Data Analyst, BI Analyst, or Junior Analytics Engineer).
- SQL Mastery: You write clean, performant, and readable SQL (CTEs and window functions are second nature).
- dbt Experience: Hands-on experience building and testing models in dbt (Core or Cloud). Understanding of version control (Git) and modular data modeling.
- Commercial Acumen: You care about the "So What?" You want to understand how your data drives product engagement and marketing efficiency.
- AI-Forward Mindset: Excited about the practical applications of AI. Eager to analyse how users interact with AI in our product.
- Communication: Strong ability to translate technical concepts to non-technical stakeholders and vice-versa.
Nice-to-haves (but not dealbreakers):
- Experience with BigQuery.
- Experience with semantic layer BI tools (like Lightdash or Looker) or product analytics tools (like Mixpanel).
- Familiarity with Python (Pandas/scripting) for lightweight data manipulation.
- Previous experience in a high-growth startup environment.
Why us?
Compensation & Rewards:
- Salary £45-55K pending on experience & interview performance, reviewed annually.
- Annual 10% bonus, increasing with tenure.
- Referral bonus.
- Hybrid working (UK-based) with 1-2 days per week in our London Victoria office.
- Flexible working arrangements.
- Work from abroad for up to 2 weeks per year.
- 25 days holiday (increasing to 27), plus your birthday off.
- Summer hours - early finish on Fridays during June, July, and August.
- Dog-friendly office.
- 4 weeks paternity leave.
- 12 weeks maternity leave.
- Summer party.
- LinkedIn Learning access.
- £1,000 annual learning budget.
- 4 giving back days per year.
- 1 paid volunteering day per year.
We’re happy to discuss flexible arrangements and reasonable adjustments throughout the hiring process.
About us:
Values, Inclusion & Diversity: Equal opportunity runs through every aspect of Zigzag. We’re building a workplace where a diverse mix of people can do their best work and be their authentic selves.
Our values guide how we work every day:
- User-led, data-informed: We test and measure to ensure we’re delivering real value.
- Own your patch: Engineers have autonomy and responsibility over what they build.
- Paw-sitive collaboration: Pairing, learning together, and shared ownership.
Analytics Engineer employer: Zigzag Dog Training | B Corp
Zigzag is an exceptional employer that fosters a vibrant and inclusive work culture, where employees are empowered to take ownership of their projects while collaborating closely with a passionate team. With a strong focus on personal and professional growth, we offer generous benefits such as a competitive salary, flexible working arrangements, and a substantial annual learning budget, all within a dog-friendly office environment in the heart of London. Join us to make a meaningful impact in the petcare industry while enjoying a supportive atmosphere that values diversity and innovation.
Contact Detail:
Zigzag Dog Training | B Corp Recruiting Team
StudySmarter Expert Advice🤫
We think this is how you could land Analytics Engineer
✨Tip Number 1
Network like a pro! Reach out to folks in the industry, attend meetups, and connect with people on LinkedIn. You never know who might have the inside scoop on job openings or can refer you directly.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your best projects, especially those involving SQL and dbt. This gives potential employers a taste of what you can do and sets you apart from the crowd.
✨Tip Number 3
Prepare for interviews by practising common analytics questions and case studies. Be ready to discuss how you've used data to drive decisions and how you approach problem-solving. Confidence is key!
✨Tip Number 4
Apply through our website! It’s the best way to ensure your application gets seen. Plus, it shows you're genuinely interested in joining our team at Zigzag and making a difference in the world of dog training.
We think you need these skills to ace Analytics Engineer
Some tips for your application 🫡
Show Your SQL Skills:Make sure to highlight your SQL mastery in your application. We want to see how you write clean and performant SQL, so don’t hold back on showcasing your best work!
Talk About Your Experience with dbt:If you've got hands-on experience with dbt, let us know! Share specific examples of models you've built or tested, as this is a key part of the role we’re looking to fill.
Demonstrate Your Commercial Acumen:We love candidates who understand the 'So What?' of their data. In your application, explain how your work has driven product engagement or marketing efficiency in past roles.
Apply Through Our Website:We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you don’t miss out on any important updates from our team!
How to prepare for a job interview at Zigzag Dog Training | B Corp
✨Know Your SQL Inside Out
As an Analytics Engineer, your SQL skills are crucial. Brush up on writing clean, performant queries, especially CTEs and window functions. Be ready to demonstrate your SQL prowess with practical examples during the interview.
✨Showcase Your dbt Experience
Make sure to highlight your hands-on experience with dbt. Prepare to discuss specific models you've built or tested, and how you’ve used version control with Git. This will show that you understand the importance of modular data modelling.
✨Understand the Business Impact
Zigzag is looking for someone who cares about the 'So What?'. Be prepared to discuss how your previous work has driven product engagement or marketing efficiency. This shows that you’re not just a techie but also have commercial acumen.
✨Embrace AI Tools
Since the team actively uses AI tools, express your excitement about AI applications in data operations. Share any experiences where you've used AI coding assistants or analysed user interactions with AI features, as this aligns perfectly with their forward-thinking approach.
