Data Analytics Engineer

Dogs, cats, budgies and everything in between - pets deserve the world. They make us want to be better humans. That’s why we’ve made it our mission to build the most engaged and passionate community of pets and pet parents across the world. And we’re looking for talented team mates who can help us do it.

Founded in Sydney, our team of 500+ pet obsessives span Australia, New Zealand and the Philippines. We’ve scaled to become one of Australia's top five eComm companies and the no.1 online pet store. But we’re just getting started. Like a whippet who’s spotted their mate across the dog park, our growth is only going to accelerate, as we continue to disrupt the way that pet parents shop.

Excitingly, the pet industry is booming (as in $15 billion kind of booming) and online pet retail is set to grow exponentially in the next five years. So this is a unique career opportunity to be part of our epic growth story.

The opportunity

Pet Circle is implementing a company-wide data governance program to manage the organisation's data assets. The framework encompasses the policies, procedures, roles, responsibilities, and standards that ensure data availability, quality, consistency, and security across the enterprise. Our team’s mission is to leverage data and analytics to drive strategic decision-making, optimise operations, and enrich pet care with personalised experiences for pets and their parents.

The technical environment

Pet Circle runs a Big Query/GCP data environment with several continuously increasing inbound data feeds. While Java is the primary language used to build our internal systems, the Data & Analytics team uses Python. You will work directly in Google Cloud Platform and Big Query, coding extracts and transforms using Python and Dataform (Google’s alternative to DBT). There are relational databases that you will use to inform and build the data models.

What you’ll be doing

• Create visualisations and interactive reports
• Write feeds to collect data from external systems
• Translating business requirements into technical specifications
• Write transforms to process data into more information-rich data models
• Ensure data assets are automatically monitored for performance, reliability, and availability
• Create one-off or recurring data sets for statistical or advanced analysis
• Maintenance tasks to handle changing environment (e.g. address upstream schema changes by modifying transform)
• Document processes and data structures so that they are maintainable and usable by others
• Perform basic security and privacy management
• Participate in the team roster to support business users using our data and platform
• Work with other teams in scrums, ideation sessions, and various other formats to make the value of Data realisable across different parts of the business
  

The ideal toolbox

• 2-5+ years experience in data engineering or analytics engineering
  
• Very strong SQL
  
• Experience in Python
  
• Experience with BI tools (PowerBI, Tableau), preferably Looker
  
• Experience modelling data and creating transformation pipelines with Dataform or DBT Worked with cloud-based data warehouses (Redshift, BigQuery, Snowflake, Databricks, etc)
  
• Demonstrate experience in conceptual and physical modelling
  
• Demonstrated experience in collaborating and supporting non-technical users
  
• Autonomous, reliable, with solid communication skills
  

What success looks like

In this role, your focus over the medium term will be to bring our data environment to life - expanding and refining data feeds, transforming raw data into powerful, well-structured models, and ensuring they’re highly available and rock-solid reliable for the business to use every day.

We’re looking for someone with strong SQL skills, a solid grasp of big data engineering in Python, and a mindset that values accuracy, performance visibility, and clean, scalable design.

Just as important are your soft skills. This is a highly collaborative role, working closely with engineers, data scientists, and analysts across the company. You’ll need a genuine curiosity about how data drives the business, a knack for gathering requirements, proposing practical solutions, and partnering with project leads from initial idea through to post-launch success.

Role location

We believe that building connections and collaborating as Pet Circlers is super important. The role is ideally based in Sydney with a hybrid arrangement of 3 days per week in our pet friendly offices (your pet might love coming to the office even more than you). However, we are open to considering candidates based in other states across Australia.

Juicy perks

• Heaps of development opportunities - stretch projects, secondments and unlimited learning courses via Go1
• Flexible working environment
• Up to 50% employee discount
• Product sample giveaways
• Pawrental leave and wellbeing leave
• Team charity volunteer days
• Classpass subsidy

Why Join?

We reckon our mission to help the world Pet Better is an important one, but also an incredibly fun and rewarding one. Becoming a Pet Circler means you’re committed to help shape an entire industry - it’s pretty exciting stuff. Here’s what we stand for:

• We're better together
• We operate with humble hearts and hungry minds
• Pets matter' so pets and pet parents always have a seat at our table
• We're instinctively curious. Always.

Belong at Pet Circle

Our unique perspectives and expertise is our superpower - we value diversity in all forms. So, no matter your background, please apply if this role makes you excited to bring your full self to work each day.