Snowflake Solution Designer Contract Sydney
Job Summary
Primary Skills:
Data Platform Development Snowflake Data Engineering Data Integration & Automation Data Quality & Governance Cloud & Platform Engineering
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
Snowpipe
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.
Python programming.
Data warehousing and dimensional modelling.
ETL/ELT development and orchestration.
Snowpipe Streams Tasks Dynamic Tables Snowpark.
Data integration tools (Informatica dbt etc.).
Apache Spark and cloud data platforms.
CI/CD Git DevOps practices.
Azure Data Lake Storage (ADLS)
AWS S3 cloud storage
Required Skills:
Snowflake Solution Designer - Contract - Sydney
Required Education:
BE