Hastha Solutions - Snowflake Solution Designer - Contract - Sydney

Data Engineer is needed in Sydney, Australia.

Client: Hastha Solutions

Location: Sydney, NSW, au

Contract: Contract

Job Description

Urgent requirement for a Snowflake Solution Designer on a contract basis in Sydney. The role involves designing, building, and maintaining Snowflake data warehouse solutions, developing ETL/ELT pipelines, and ensuring data quality and governance in a cloud environment.

Requirements

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.