Description

Design and deliver enterprise-scale Snowflake architectures, leading technical workshops and translating business requirements into robust data solutions.

This role is hybrid.

Responsibilities

• Architect and implement enterprise-scale Snowflake environments, including account setup, workload isolation, and secure data sharing patterns.
• Lead client-facing architecture workshops to define data governance, security, and auditability requirements.
• Design medallion-style data models (Bronze/Silver/Gold), handling SCD Type 2, deduplication, and reconciliation logic.
• Implement CI/CD pipelines for Snowflake objects using Git and Terraform, ensuring controlled delivery governance.
• Optimize SQL performance and manage incremental processing via Streams, Tasks, and Stored Procedures.

Required Skills

• 12+ years of experience in data architecture, data warehousing, or cloud data platforms.
• 5+ years of hands-on Snowflake architecture and delivery experience.
• Deep knowledge of Snowflake RBAC, masking policies, row access policies, and lineage monitoring.
• Experience with Snowpipe, data ingestion patterns, and SQL performance tuning.
• Proficiency in AWS integration, including S3, IAM, KMS, and network security dependencies.
• Strong background in data governance, data contracts, and controlled delivery practices.
• Familiarity with CI/CD tooling such as Git and Terraform.

Preferred Skills

• Snowflake SnowPro Core and Advanced Architect certifications.
• Experience with multi-cloud platforms (Azure/GCP) and AWS certifications.

Key Skills

Education

Bachelor's degree