Analytics Engineer

Petcircle • Philippines

Company

Petcircle

Location

Philippines

Type

Full Time

Job Description

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 eCommerce 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.

This role is responsible for completing the build-out of this environment by adding and refining data feeds, transforming the data into models and more, and ensuring that these are highly available and highly reliable for use within the business. Expected technical skills are solid SQL and a good understanding of "big data" databases & engineering in Python with a mindset of testable accuracy, observable performance, and sound design. 

The right candidate will have a genuine interest in using data to achieve business goals, and work with a variety of engineers, data scientists, analysts, and stakeholders around the business to help them achieve their goals. Expect to collect requirements, propose solutions, and work through post-launch with project leads.

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.

This role is fully remote based out of the Philippines. You will be working closely with distributed team members based in Australia, New Zealand and the Philippines. You would be expected to work on standard hours for Philippines Standard Time, or a few hours earlier as it suits you.


Your Responsibilities:
  • Write feeds to collect data from external systems
  • 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
  • Create visualisations and interactive reports
  • 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


  • Your Experience:
  • 2-5+ years experience in data engineering or analytics engineering
  • Extensive experience and expertise in SQL and 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)
  • Demonstrated experience in collaborating and supporting non-technical users
  • Autonomous, reliable, and great communication skills
  • Comfortable working with remote and distributed teams
  • Role Location
    Our Philippines team are highly autonomous and empowered to do their best work remotely - so you will be working from your home office. You should have a good home office set-up and a reliable internet connection.

    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.
    Apply Now

    Date Posted

    10/25/2024

    Views

    0

    Back to Job Listings ❤️Add To Job List Company Info View Company Reviews
    Positive
    Subjectivity Score: 0.8

    Similar Jobs

    Principal Database Engineer - TTEC Digital

    Views in the last 30 days - 0

    TTEC Digital is a company that values its employees and aims to provide an exceptional customer experience They are seeking a Principal Database Engin...

    View Details

    Intermediate QA Analyst - SaaS - InnoCraft

    Views in the last 30 days - 0

    InnoCraft is seeking a skilled Intermediate QA Analyst to join their Quality Assurance team The role involves designing and executing manual and autom...

    View Details

    Senior Full Stack Engineer - CC.Talent

    Views in the last 30 days - 0

    CCTalent is seeking a Senior Full Stack Engineer with extensive experience in building enterprisegrade solutions The ideal candidate should be profici...

    View Details

    Automation & BI Analyst - Aprio

    Views in the last 30 days - 0

    Aprio is a progressive fastgrowing firm looking for an Automation and BI Analyst to join their dynamic Technology Advisory team The position involves ...

    View Details

    Data Scientist - TE Connectivity

    Views in the last 30 days - 0

    TE is seeking a Data Scientist to join their team and drive digital strategy forward The ideal candidate will leverage data analytics and digital tran...

    View Details

    JR-202418990 GBST Reporting Analyst - General Motors

    Views in the last 30 days - 0

    General Motors is seeking a candidate for a hybrid role in the Transformation team within Global Business Solutions The role involves providing worldc...

    View Details