Senior Snowflake Architect (Snowpark)

Location: Sydney / Melbourne

Employment Type: Contract / Permanent
Work Eligibility: PR / Citizen (No Sponsorship)

Role Overview

Senior Snowflake Architect responsible for designing enterprise-scale data platforms and driving architecture decisions. Strong client-facing experience required. Focus on Snowflake architecture and Snowpark for advanced in-warehouse processing.

Key Responsibilities

• Own end-to-end Snowflake architecture (ingestion transformation consumption)
• Design batch & streaming ingestion frameworks
• Define layered architecture (raw, curated, semantic)
• Architect Snowpark (Python/SQL) solutions for complex transformations, data quality, and custom processing
• Drive Snowflake design decisions: Snowpipe, Streams, Tasks, Time Travel, Zero-Copy Cloning
• Optimize performance (warehouse sizing, clustering, pruning, query tuning)
• Implement security & governance (RBAC, data masking, access control)
• Lead client discussions, architecture reviews, and solution design

Required Skills

• 10+ years in data engineering / architecture
• Deep expertise in Snowflake:
  • Virtual Warehouses, Micro-partitions, Clustering
  • Query performance tuning & cost optimization
• Strong hands-on with Snowpark (Python preferred)
• Experience with data modeling (Dimensional / Data Vault / Hybrid)
• Strong SQL + data warehousing / lakehouse architecture
• Azure cloud experience preferred
• Strong stakeholder engagement & architecture ownership

Good to Have

• Salesforce–Snowflake integrations
• MDM / data quality / deduplication use cases
• ML / analytics workloads in Snowflake
• CI/CD for data platforms
• Data governance frameworks