Data Lead

Airtree; Sydney; On-site; AUD 120,000 - 170,000; Full time

Benefits offered by this job

5 weeks leave

Parental leave (16 weeks)

Training & development budget

Health and wellness benefits

Job summary

Airtree, Sydney-based VC, is hiring a data-focused engineer to optimise our Snowflake warehouse and pipelines. You’ll work closely with investment and finance teams to scale data infrastructure and deliver improved portfolio reporting.

We seek curious problem-solvers with strong Python/SQL and a passion for turning data into actionable insights, including dashboards built with Streamlit. This is an in-office role three days a week in Sydney with flexible days.

Qualifications

• Strong Python and SQL programming capabilities.
• Experience with data warehousing and analytics workflows.
• Familiarity with Snowflake, dbt and AWS Lambda is a plus.

Responsibilities

• Optimize and scale the Snowflake data warehouse to meet growing data needs.
• Enhance and maintain ETL/ELT pipelines using dbt and AWS Lambda.
• Refine AWS Lambda functions to support data processing and integration.
• Collaborate with investment partners to evolve data-driven tools for opportunities.
• Lead quarterly portfolio reporting with streamlined processes.
• Iterate on Airtree dashboards built with Streamlit for actionable insights.
• Improve data models and infrastructure using best practices and new tech.
• Champion data-driven decision-making across the organization.

Skills

Python

SQL

Snowflake

dbt

AWS Lambda

ETL/ELT

Data dashboards

Streamlit

Data modelling

Tools

Snowflake

dbt

AWS Lambda

Job description

Airtree backs Aussie and Kiwi founders building the iconic technology companies of tomorrow. We’re investors and builders of the technology ecosystem, powered by our network at the frontier of what’s next. As one of the largest and most active early-stage investors in Australia and New Zealand with $2 billion FUM, Airtree’s 145+ portfolio features the region’s breakout tech companies, including Canva, Go1, Employment Hero, Airwallex, Pet Circle, Immutable and Linktree.

Airtree has invested in some of the largest software companies to come out of the ANZ market to date and pride ourselves on being able to support exciting early stage companies with capital, expertise and data.

You will work closely with the investment, fund strategy, investor relations and finance teams to optimise and scale our existing data infrastructure, driving data-informed decision making across our venture capital operations. Your focus will be on enhancing our current Snowflake, AWS Lambda, and dbt ecosystem to further improve our origination process, portfolio reporting, and overall operational efficiency. This full-time, permanent position offers a unique opportunity to take our data initiatives to the next level in the dynamic world of venture capital.

This is a full-time role, based in our Sydney office.

What you'll do:

• Optimise and scale our existing Snowflake data warehouse, ensuring it continues to meet our growing data needs efficiently.
• Enhance and maintain our ETL/ELT pipelines built with dbt and AWS lambda functions, focusing on improving performance, reliability, and extensibility.
• Refine and expand our suite of AWS Lambda functions to support data processing and integration needs.
• Collaborate with investment partners and investment managers to evolve our data-driven tools, continuously improving our ability to surface promising investment opportunities.
• Lead the ongoing analysis and reporting of the Airtree portfolio companies, streamlining processes for more efficient, accurate and insightful quarterly reporting.
• Iterate on Airtree’s existing dashboards and insight packs (built with Streamlit), ensuring they continue to provide actionable insights as Airtree’s needs evolve.
• Proactively identify areas for improvement in our data models and infrastructure, implementing best practices and leveraging emerging technologies where appropriate.
• Champion data-driven decision-making across the organisation, helping stakeholders leverage our data assets more effectively.

• You're passionate about solving problems in eloquent and efficient ways. You thrive in fast-paced environments and are excited by the prospect of enhancing processes through data and automation. Above all, you are curious and obsess about ‘why’ things work the way they do.
• We have a strong preference for candidates with proficient programming skills, particularly in Python, and advanced SQL knowledge (or a demonstrated ability to pick up new programming languages quickly). In addition, you may also have:
• Hands‑on experience with or a strong interest in learning Snowflake, dbt and AWS Lambda, with a focus on optimisation and scaling.
• An understanding of financial and investment concepts or a strong desire to deepen your knowledge of the VC industry.
• A track record of refining data models to balance performance, scalability, and usability in growing data environments.
• Excellent communication skills, with the ability to explain complex technical concepts to non-technical stakeholders.
• A talent for identifying bottlenecks in existing data systems and implementing effective solutions.
• A proactive approach to problem-solving and a commitment to continuous learning and improvement.

We celebrate and value diversity and are committed to being equitable and inclusive in the way we hire and in the way our team works together.

Airtree's headquarters are based in Sydney, and this role will be in‑office three days a week with two flexible days.

We also offer:

• 5 weeks of leave: 4 weeks annual leave plus 1 bonus week of lifestyle and wellbeing leave.
• 16 weeks of paid parental leave, plus a flexible return to work program.
• An annual budget for your training & self‑development.
• A range of health and wellness benefits including EAP, mental health first aid training, skin checks, flu vaccines and more.