Trade Me is one of New Zealand's most popular websites with over four million members and more than 650,000 Kiwis visiting our site every day.

We're looking for someone to help us in the biggest data transformation in Trade Me's history.  We're on the path to consolidate our data platform to one cloud data warehouse.  This involves re-architecting our data from source through to reporting, enabling Analysts to self-service their own models and reinventing our ways of working to match.  The practice of Analytics Engineering has been in place at Trade Me for 2 years, and is closely aligned to our Data Engineering practice.  Together our goal is to build robust, efficient, consistent and intuitive data models across our Data Platform.  

This role will perform the important function of understanding the data models that will help our teams at Trade Me move faster.  Using the strong relationships built with our Data Engineering and Data Analytics teams, this role is responsible for bringing those robust, efficient and integrated data models to life. 

#Flexible Flexible working is the new normal. We have a guideline for our people to be in the office 60% of the time, with the remaining time being flexible. We support you with a home office setup and a utilities allowance to ensure you can work comfortably
#Wellness Being your best self means caring for your physical and mental wellbeing, we offer lots of resources to help you along the way
#Leave We support you with leave when you need it, including 5 days of wellness leave each year and 10 days of sick leave from day 1
#Social Nothing beats getting together to have some fun and celebrate our success. Join us in the office on payday for company paid lunches. Friday drinks and nibbles every fortnight, annual Trade Me company awards, celebrations and more
#Learning Whether it's on the job, formal training, mentoring or something else, you'll grow with us from day 1

* Help to establish best practice and integration within our data stack
* Implement the conceptual, logical and physical models of our Snowflake warehouses and datamarts
* Collaborate with team members and internal stakeholders to collect business requirements, define successful analytics outcomes, and design data models
* Implement the DataOps philosophy in everything you do
* Craft code that meets our internal standards for style, maintainability, and best practices for a high-scale database environment. Maintain and advocate for these standards through code review
* Approve data model changes as a reviewer and code owner for specific database and data model schemas
* Provide data modelling expertise to all Trade Me data teams through code reviews, pairing, and training to help deliver optimal, DRY, and scalable database designs and queries in Snowflake

 

* 3+ years experience as an Analytics Engineer or related discipline - Data Engineering, BI Developer, Insights Analyst
* Understanding of the full data lifecycle - how data is created, ingested, stored, and used
* Understanding of data ethics and privacy, and the ability to apply this to everything you do
* A passion for automation and reducing toil in the development lifecycle
* Self-motivated, takes initiative, adaptable and has a proactive approach to problem-solving
* Experience in all aspects of a continuous delivery (architecture, culture, and patterns)
* Understanding of common software architecture concerns with practical experience working in large complex systems
* You are proficient in writing analytical SQL and understand the difference between SQL that works, and performant SQL
* Knowledge of dbt, creating and understanding dbt macros and dbt projects
* Have experience using the command line and git
* Have a solid understanding of data warehouses, business intelligence tools, data activation tools, and the Modern Data Stack
* Can communicate clearly and directly about complex technical topics with empathy for your stakeholders
* Experience working with ingestion tools like Stitch and orchestration tools like Prefect/Airflow would be advantageous
* Experience working with Cloud data platforms, Snowflake in particular
* Expertise in JIRA (preferred) 

We know some candidates can be reluctant to apply for roles if they feel they don't 'tick all the boxes'. If you're excited about this opportunity, we'd still really like to hear from you.

Trade Me is an INZ accredited employer. We truly value diversity and embrace a flexible workplace where people are encouraged to achieve their potential.