Data & Analytics Associate

**Who are we?**

Lyka is an Australian founded pet wellness company that's shaking up an outdated industry and paving the way for happier, healthier pets. Sadly, statistics have shown us that approximately eighty percent of pets are suffering from dental disease, with one in every three being diagnosed with cancer, and forty-one percent overweight. As humans we are acutely aware of the positive impact fresh wholefoods can have on our health and wellbeing, however the same hasn't always been said for our furry friends. We're on a mission to change that, starting with nutritionally balanced, wholefood meals delivered direct to doors around Australia. As the world's most sustainable pet wellness company, we're putting pets and our planet first.

Today, we are proud to share we've served and fed over 10 million meals to puppers and their parents across Australia, and this is just the beginning. Our vision is to create multiple nutritional products, adding disease prevention meals and supplements, and take Lyka into new markets.

Currently, we have a team of 140 pet-obsessed people on our team who share our vision. These carefully selected people are dedicated to building the next generation of technology and products to help empower pet parents to take control over their pet's wellbeing. To date, we have raised over $40M in funding from our venture fund investments and pet industry insiders, who believe in our mission and ability to drive change in an outdated industry, providing nutrition that nourishes puppers from the inside out.

Are you ready to shake things up and give pets the life they deserve? Come join your people.

**The Team**

Lyka is growing and is on the hunt for an exceptional Data Analyst that will be working closely with our Data & Analytics team and partner across the organisation to help build up our Analytical Architecture and establish the right data processes and procedures for our stage of growth.

**The role?**

This role sits in the broader Strategy & Operations team reporting to our Senior Strategy, Operations and Analytics Manager, and you will be responsible for helping us scale our Data & Analytics capability with intention. You'll work cross functionally across the whole company to provide tailored data requests to different teams to aid business decision making. As we scale, you'll work on a variety of data related project and making step changes in how we collect, store, analyse and share data across the business. This role is specifically targeting someone with between 1-3 years' experience as a data analyst or similar roles.

As a Data Analyst at Lyka, you will be **responsible** for:

- Working with the technology team and functional stakeholders to manage data capture, transformation and storage for enhanced usability
- Managing ad-hoc analytical products and projects throughout the business
- Solving data integrity and validity constraints to provide clean and normalised datasets
- Defining the ideal future state of business data at Lyka and implementing best practice in how (and what) data is stored, structured and consumed
- Defining and documenting/cataloguing data tables and models used throughout the business
- Building and automating models on large datasets to measure results and outcomes
- Supporting growth, marketing and product teams with data flows to improve the customer experience
- Working with functional stakeholders to assist in business analyses, including providing access to data and helping perform business analyses as required
- Creating a culture of data driven thinking to enable teams to self-serve
- Please note, this role can be either based in _Melbourne or Sydney_._

**About you**
- 1+ years of experience in a Data Analyst, Analytics Engineering, Data Engineering role or other highly analytical and data-heavy role.
- Experience in a fast-paced, rapidly changing environment (start-up experience or experience in E-commerce or subscriptions would be ideal, but not required)
- Strong foundational data skills (incl. good understanding of relational databases and structures, and ability to process data, data cleansing etc.)
- At a minimum, intermediate SQL skills and basic data visualisation skills, including ability to query and manipulate internal databases and external data sources then present this in either a tabular/dashboard output depending on the required output
- Experience in relevant data tools, whilst desirable is not required. This may include (but not limited to):

- Data Pipeline/Data warehousing (e.g. Fivetran, Big Query, Snowflake, Redshift)
- Data transformation/ Data Cleansing (e.g. Alteryx, DBT)
- Data Science/Analytical Programming (e.g. Python, R)
- Dashboarding / BI (e.g. Tableau, Metabase, Sigma)
- Reverse ETL (e.g. Hightouch, Census)
- Strong understanding of upstream systems, the flow of data, workflow design and common data issues and defects
- Good business acumen - an ability to understand and translate busine