Snowflake Specialist

Vivanti Consulting; Sydney; On-site; AUD 120,000 - 180,000; Full time

Benefits offered by this job

Mentoring Program

Paid Certifications

Hackathons & Innovation Days

Guilds & Regular Training

Sponsorship opportunities

Job summary

Vivanti is seeking a Snowflake Specialist to architect and optimise modern data platforms built around Snowflake. You’ll design scalable models, implement data governance, and work with data engineers and stakeholders to deliver production-ready solutions.

The role requires hands-on Snowflake experience, advanced SQL, and proficiency with a modern data stack and cloud environments. Sponsorship opportunities and ongoing learning support are available.

Qualifications

• Snowflake expertise with hands-on delivery in production environments.
• Strong SQL skills and one of Python/Scala/Java for data engineering.
• Experience with modern data stack tools and cloud platforms.
• Ability to explain trade-offs to non-technical stakeholders.

Responsibilities

• Architect and build high-performance data platforms centered on Snowflake.
• Design scalable data models and manage data governance and security.
• Collaborate with data engineers, architects, and business stakeholders.
• Optimise costs and performance across large client environments.

Skills

Snowflake

Advanced SQL

Python/Scala/Java

Cloud fluency

Client communication

Cost & performance instincts

Tools

dbt

Airflow

Fivetran

Matillion

Terraform

Job description

You’ve got the skills. The curiosity. The hunger to grow, try new things and make a real impact.

We’re a growing global tech consultancy. Some of the world’s biggest businesses turn to us to help bring their data, AI, cloud and digital solutions to life.

We’re the home base for talented technologists who want more and are looking to take their career to the next level by having more learning, more variety, more support and more chances to do meaningful work.

If that sounds like the kind of place you’d thrive in, keep reading.

The Role...

As a Snowflake Specialist, you're the architect and engine room – turning raw business data into high-performance, cost-efficient analytics powerhouses.

What you might work on:

• Architecting, building, and optimising modern data platforms centred on Snowflake.
• Designing scalable data models (Data Vault, Star Schema, 3NF, Semantic) tailored for complex enterprise landscapes.
• Implementing robust data sharing, real-time analytics and the latest Snowflake capabilities.
• Optimising performance, warehouse sizing, and cost management across large-scale client environments.
• Establishing rock-solid data governance and security policies (RBAC, row/column-level security).
• Collaborating with data engineers, architects, and business stakeholders to solve complex data challenges.

What we’re looking for from you:

• Snowflake experience - SnowPro certification is ideal, but if you’re not certified, we will expect demonstrable hands-on Snowflake experience.
• Real delivery experience with data – you've built and shipped data solutions in production, not just in a lab.
• Advanced SQL – non-negotiable. Plus at least one of Python, Scala or Java.
• Hands-on with a modern data stack – dbt or similar transformation tooling, and orchestration (Airflow, Dagster, Fivetran, Matillion, etc).
• Cloud fluency – working knowledge of at least one of Azure, AWS or GCP.
• Cost and performance instincts – you understand that a query that works isn't the same as a query that should ship.
• Client-ready communication – you can explain a technical trade-off to a non-technical stakeholder in language they understand.

Nice to have:

• Infrastructure-as-code (Terraform) and CI/CD pipeline experience.
• Exposure to Iceberg, Databricks, Starburst or Schema Registry.
• Prior consultancy or multi-client delivery experience.

What You’ll Get

Your work matters and so do you. That's why we back your skills with a structure that supports your development, celebrates your wins, and helps you keep growing – professionally and personally.

Here’s what's waiting for you:

• A platform for growth: Work across industries, clients and technologies that stretch your thinking and build your personal and professional skills.
• Mentoring Program: With a Senior Support Lead
• 360° Progress Reviews: Annual reviews based on honest feedback and clear goals.
• Guilds & Regular Training: Weekly training and learning from your peers and our key vendor partners
• Paid Certifications: Across all major technologies
• Hackathons & Innovation Days: Challenge yourself, build cool stuff
• Kudos & Recognition Programs: We celebrate wins, reward impact and offer long-term incentives
• Socials & Team Days: Monthly "fun for the sake of it" days, Friday socials, video games, board games, and soon an F1 racing simulator

Final Word

If you're looking for the place where your growth will go into overdrive, where you'll work with great humans, get access to cutting-edge tools and genuinely enjoy the ride…

Welcome to Vivanti.

The AI Native People Shaping Tomorrow

Vivanti was founded as a haven for talented technologists who want to make a real impact for their clients. Our mission is to transform businesses and to create a smarter, more connected world through the power of data and technology. Together, we are making the future happen – today.

*We also offer sponsorship opportunities, so whether you’re already based in Australia or considering a move from overseas, we’d still love to hear from you!