Snowflake Specialist

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

Benefits offered by this job

Mentoring Program

Paid Certifications

Hackathons & Innovation Days

Kudos & Recognition

Job summary

Vivanti is seeking a Snowflake Specialist to architect and optimise large-scale data platforms. You’ll transform raw data into high-performance analytics, collaborating with engineers and stakeholders across client environments.

You will design scalable data models, implement data sharing, and drive cost/performance optimisations while ensuring governance and security. A strong SQL base and hands-on cloud experience are essential for this role.

Qualifications

• Snowflake expertise with production deployments.
• Strong SQL skills with hands-on coding in Python/Scala/Java.
• Experience with dbt and orchestration tools (Airflow, Dagster, etc.).
• Knowledge of cloud platforms (Azure/AWS/GCP).
• Ability to explain trade-offs to non-technical stakeholders.
• Prior consultancy or multi-client delivery is a plus.

Responsibilities

• Architect modern data platforms centered on Snowflake.
• Design scalable data models for complex landscapes.
• Implement data sharing and real-time analytics capabilities.
• Optimize performance, sizing and cost across large environments.
• Establish data governance and security controls.
• Collaborate with data engineers, architects and stakeholders.

Skills

Snowflake

Advanced SQL

Python/Scala/Java

dbt & orchestration

Airflow/Dagster

Cloud platforms

Cost/performance mindset

Client communication

Tools

dbt

Airflow

Fivetran

Matillion

Dagster

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 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.