Full-Time Analytics Engineer

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