V

Snowflake Specialist

vivanti consulting Greater Sydney Area
Visa Sponsorship
Apply
AI Summary

Architect and optimize high-performance, cost-efficient data platforms centered on Snowflake for global enterprise clients. Design scalable data models, implement robust governance and security policies, and manage warehouse sizing and performance. Requires advanced SQL, hands-on Snowflake experience, and proficiency in modern data stack tools like dbt and cloud platforms.

Key Highlights
Architecting and optimizing modern data platforms using Snowflake
Designing scalable data models and implementing data governance
Collaborating with stakeholders to solve complex data challenges
Key Responsibilities
Architecting, building, and optimising modern data platforms centred on Snowflake
Designing scalable data models 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
Collaborating with data engineers, architects, and business stakeholders to solve complex data challenges
Technical Skills Required
Snowflake SQL Python
Benefits & Perks
Mentoring Program
Paid Certifications
Hackathons & Innovation Days
Kudos & Recognition Programs
Socials & Team Days
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

Job Description


About the job


Your Career, Accelerated


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!


Similar Jobs

Explore other opportunities that match your interests

Visa Sponsorship Relocation Remote
Job Type Full-time
Experience Level Mid-Senior level

Tech Observer

United State
Visa Sponsorship Relocation Remote
Job Type Contract
Experience Level Mid-Senior level

Hire IT People, Inc

United State

Senior Machine Learning Scientist – Advertising Cloud Optimization (RTB)

Devops
8h ago

Premium Job

Sign up is free! Login or Sign up to view full details.

•••••• •••••• ••••••
Job Type ••••••
Experience Level ••••••

creative tokyo

Greater Tokyo Area

Subscribe our newsletter

New Things Will Always Update Regularly