At a Glance
- Tasks: Transform raw data into insights and collaborate with Product and Marketing teams.
- 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 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). You understand the value 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: You are genuinely excited about the practical applications of AI and 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:
- 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?
- 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:
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, offering a vibrant work culture that prioritises collaboration and innovation in the heart of London. With a strong focus on employee growth, we provide generous learning budgets, flexible working arrangements, and a supportive environment where your contributions directly impact our mission to enhance dog training accessibility. Join us for a rewarding career where you can thrive alongside a passionate team dedicated to making a difference in the petcare industry.
Contact Details:
Zigzag Dog Training | B Corp Recruitment 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 put in a good word for you.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your best work, especially any projects related to data modelling or analytics. 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 questions and scenarios specific to analytics roles. Think about how you can demonstrate your SQL mastery and your experience with dbt. 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, where we’re all about making puppy training accessible and fun.
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 previous work has driven product engagement or marketing efficiency—this will really catch our eye!
Keep It Conversational:While we appreciate professionalism, we also value authenticity. Write your application in a way that reflects your personality and passion for the role. And remember, apply through our website for the best chance!
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 mastery 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 and 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?' of data. 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 to enhance your workflow, as this aligns perfectly with their forward-thinking approach.
