Snowflake Specialist: Build Scalable Analytics & Growth

Vivanti Consulting; Sydney; On-site; AUD 140,000 - 190,000; Full time

Benefits offered by this job

Sponsored certifications

Mentoring program

Guilds & Training

Paid certifications

Hackathons & Innovation Days

Team socials

Job summary

Vivanti Consulting is seeking a Snowflake Specialist in Sydney to architect and optimize data platforms centered on Snowflake for enterprise clients. You will design scalable data models, implement data sharing, ensure governance, and drive cost-efficient analytics.

You’ll collaborate with data engineers and business stakeholders, apply advanced SQL, and leverage dbt, Airflow, and cloud services to deliver production-grade solutions that scale.

Qualifications

• For Snowflake experience, demonstrated hands-on use; SnowPro cert is nice but not required.
• Delivered production data solutions, not just lab work.
• Advanced SQL proficiency; familiarity with Python/Scala/Java.
• Hands-on with dbt or equivalent & orchestration tools (Airflow, Dagster, etc).
• Cloud knowledge in at least one of AWS, Azure or GCP.
• Ability to balance cost/performance in data platform decisions.
• Strong ability to explain technical trade-offs to non-technical stakeholders.

Responsibilities

• Architect, build, and optimise Snowflake-based data platforms for enterprise clients.
• Design scalable data models (Data Vault, Star Schema, 3NF) for complex landscapes.
• Implement secure data sharing and real-time analytics on Snowflake.
• Optimize performance, sizing, and cost across large environments.
• Ensure data governance and RBAC/security policies; collaborate with stakeholders.

Skills

Snowflake experience

Hands-on data delivery

Advanced SQL

Python/Scala/Java

Modern data stack

Cloud fluency

Cost & performance mindset

Client communication

Tools

dbt

Airflow

Dagster

Fivetran

Matillion

Databricks

Iceberg

Schema Registry

Job description

Vivanti Consulting is seeking a Snowflake Specialist in Sydney to architect and optimize data platforms centered on Snowflake for enterprise clients. You will design scalable data models, implement data sharing, ensure governance, and drive cost-efficient analytics.

You’ll collaborate with data engineers and business stakeholders, apply advanced SQL, and leverage dbt, Airflow, and cloud services to deliver production-grade solutions that scale.