Analytics Engineer - 39 hours

Are you ready to unleash your data superpowers to make a real impact in the lives of pets and their humans? Pets at Home, the UK's leading pet care business, is on a mission to become the world's best Pet Care Platform, and we're looking for passionate Analytics Engineers to join our dynamic team! This isn't just another data role - this is your chance to transform the pet care journey using innovative solutions and cutting-edge analytics. If you thrive on solving complex problems, building powerful data models, and collaborating with brilliant minds, we'd love to hear from you!,

• Design, develop, and maintain robust, scalable data pipelines.
• Ensure data quality, governance, and reliability for validated datasets. ·
• Transform raw data into well-structured outputs that support self-serve analytics
• Partner with analysts, data scientists, and decision-makers to gather requirements.
• Create accessible, user-friendly data models aligned with business needs.
• Promote adoption of data products and champion the platform's capabilities across teams.
• Evaluate and integrate new tools to enhance data transformation processes.
• Leverage dbt and orchestration tools (e.g., Airflow) to optimize pipeline efficiency.
• Understand, identify and implement improvements to existing practices and processes in use across our platforms
• Provide second-line support for data pipelines and dashboards. ·
• Troubleshoot and resolve issues efficiently, minimising business disruption.
Who You'll Be Working With:
• Data Platform Team: The squad who builds and refines our pipelines.
• Analysts & Data Scientists: Insight champions who make magic from data models.
• Delivery & Testing Teams: Partners ensuring smooth rollouts of features we all bark about., Team Spirit: You thrive in collaboration and bring your pack along for the ride - no lone wolves here!
• Product Thinker: You dig deep to understand core needs, not just surface-level requests.
• Big Picture Builder: You're skilled at zooming in on details while keeping an eye on the system-wide goals.
What We Offer You:
• A chance to work in a fun, mission-driven environment where your work directly impacts pets and their families.
• Opportunities to grow, learn, and shape the future of pet care analytics.
• A workplace where every tail wag counts - literally!
Ready to take the leap and join our team? Bring your skills, passion, and love for pets to Pets at Home - where data meets devotion.

Must-Have Skills:
• Advanced SQL wizardry - you can debug and optimize in your sleep.
• Python prowess for data transformation and automation.
• Cloud know-how, preferably Google Cloud Platform (but AWS or Azure works too!).
• 2+ years crafting data models with dbt.
• Experience designing and normalizing data warehouses.
• Git skills for version control and collaborative magic.
• Familiarity with CI/CD tools (e.g., GitHub Actions, Bitbucket Pipelines).
Bonus Points:
• Experience with tools like R, Power BI, Tableau, or Looker.
• Airflow expertise or other orchestration.
• Agile delivery mindset - you can roll with evolving requirements like a pro.
  
  Pets just see people. They aren't biased and they don't discriminate. We take our inspiration from pets, and we value and respect difference in all its forms. Our aim is to reflect the diversity of the communities we operate in, and every colleague can help us achieve this. We encourage our people to be themselves so even if your skills and experience don't perfectly align, if you think you can make a unique contribution through your values and behaviours, we want to hear from you.