Snowflake Solution Designer - Contract - Sydney

Hastha Solutions; Sydney; Hybrid; AUD 138,000 - 248,000; Full time

Job summary

Hastha Solutions is seeking a Snowflake Solution Designer for a 6-month contract in Sydney, Australia. The role focuses on designing, building, and maintaining Snowflake data warehouse solutions, and developing scalable data pipelines across batch, near real-time, and streaming data.

You will work with AWS and modern integration tools to enable analytics and reporting. The candidate should be proficient in Snowflake objects, advanced SQL, data modelling, and CI/CD practices, with experience in

Qualifications

• Experience designing and maintaining Snowflake data warehouse solutions.
• Develop scalable ETL/ELT pipelines for batch, near real-time, and streaming data.
• Implement data modelling techniques to support analytical reporting.

Responsibilities

• Design, build, and maintain Snowflake data warehouse solutions.
• Develop scalable ETL/ELT pipelines for batch, near real-time, and streaming data.
• Integrate structured and unstructured data from multiple sources.
• Implement data modelling to support analytics.
• Develop Snowflake objects (Databases, Schemas, Tables, Views, Streams, Tasks, UDFs).
• Monitor and optimise Snowflake performance and cost.

Skills

Snowflake

SQL

ETL/ELT

Data warehousing

Dimensional modelling

CI/CD

AWS

Snowpipe

Snowpark

Apache Spark

Tools

Informatica

dbt

Kafka

Job description

Snowflake Solution Designer - Contract - Sydney

Sydney, Australia | Posted on 08/14/2026

Urgentrequirement of Snowflake Solution Designer - Contract - Sydney

Requirements

Primary Skills:

Technical Skills

• Design, build, and maintain Snowflake data warehouse solutions.
• Develop scalable ETL/ELT pipelines for batch, near real-time, and streaming data.
• Integrate structured and unstructured data from multiple internal and external sources.
• Implement data modelling techniques to support analytical and operational reporting.
• Develop Snowflake objects including:
  • Databases, Schemas, Tables and Views
  • Streams and Tasks
  • Dynamic Tables
  • Stored Procedures and UDFs
  • Snowpark and Cortex capabilities
• Monitor and optimise Snowflake performance, storage, and compute utilisation.
• Snowflake AI (Cortex agent, Cortex analyst, Cortex search)
• Build data pipelines using technologies such as Informatica, dbt, Kafka, or cloud-native integration tools.
• Automate data ingestion, transformation, validation, and reconciliation processes.
• Support CI/CD deployment practices and infrastructure automation
• Ensure compliance with enterprise security, privacy, and records management standards.
• Support data classification, masking, auditing, and access control requirements.
• Work with cloud platforms such as AWS
• Develop and support lakehouse and data lake architectures.
• Strong experience with Snowflake Data Cloud.
• Advanced SQL development and query optimisation.
• Data warehousing and dimensional modelling.
• ETL/ELT development and orchestration.
• Snowpipe, Streams, Tasks, Dynamic Tables, Snowpark.
• Apache Spark and cloud data platforms.

Duration: 06 Monthsndpossible extension

Eligibility:Australian/NZCitizens/PR Holders only