Data Lead

Airtree-Ventures; Sydney; On-site; AUD 150,000 - 210,000; Full time

Benefits offered by this job

5 weeks leave

16 weeks parental leave

Training budget

Health & wellness benefits

Job summary

Airtree is seeking a data engineer to optimise Snowflake data warehouse, dbt pipelines, and the AWS Lambda ecosystem. You will collaborate with investment and finance teams to scale data infrastructure for origination, portfolio reporting, and quarterly analytics.

Based in Sydney, this full-time, in-office role three days a week with two flexible days offers ownership, experimentation, and a focus on data-driven decision making across our venture capital operations.

Qualifications

• Experience building data pipelines and dashboards.
• Strong SQL and Python skills.
• Familiarity with Snowflake, dbt and Lambda.
• Excellent communication and collaboration abilities.

Responsibilities

• Optimise and scale Snowflake data warehouse to meet growing data needs.
• Enhance ETL/ELT pipelines built with dbt and AWS Lambda.
• Refine and expand Lambda functions for data processing and integration.
• Collaborate with investment teams to surface investment opportunities.
• Lead analysis and reporting of Airtree portfolio companies for quarterly reporting.
• Iterate on dashboards and insight packs with Streamlit for actionable insights.
• Improve data models and infrastructure using best practices.

Skills

Python

SQL

Snowflake

dbt

AWS Lambda

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.