Snowflake Architect (Data Engineering)

Experience Required

10+ years of overall Data Engineering experience with 5+ years of hands-on Snowflake architecture and implementation experience.

Job Summary

We are seeking an experienced Snowflake Architect with strong Data Engineering expertise to design, build, and optimize scalable cloud data platforms. The ideal candidate will have deep knowledge of Snowflake architecture, data modeling, ELT/ETL pipelines, cloud technologies, and modern data engineering practices.

This is a hands-on technical leadership role responsible for defining architecture standards, optimizing data solutions, and guiding engineering teams in building enterprise-grade data platforms.

Key Responsibilities

• Design and implement scalable, secure, and high-performing Snowflake data warehouse solutions.
• Define enterprise data architecture, data models, and data governance standards.
• Build and optimize ELT/ETL pipelines for large-scale data ingestion and transformation.
• Architect end-to-end cloud-based data platforms.
• Optimize Snowflake performance, storage, compute usage, and cost management.
• Implement Snowflake features such as:
  • Virtual Warehouses
  • Data Sharing
  • Streams & Tasks
  • Dynamic Tables
  • Materialized Views
  • Snowpipe
  • Time Travel
  • Zero Copy Cloning
• Develop and maintain data pipelines using Python and SQL.
• Collaborate with business stakeholders, product teams, and data consumers to translate business requirements into technical solutions.
• Establish CI/CD and DevOps best practices for data platforms.
• Mentor Data Engineers and provide technical leadership.
• Ensure data quality, security, compliance, and governance standards are followed.

Required Skills

Snowflake

• 5+ years of hands-on Snowflake architecture and implementation experience.
• Strong expertise in Snowflake performance tuning and optimization.
• Deep understanding of Snowflake security, RBAC, masking policies, and governance.
• Experience with Snowflake native capabilities and advanced features.

Data Engineering

• 10+ years of Data Engineering experience.
• Strong SQL skills.
• Expertise in data modeling (Star Schema, Snowflake Schema, Dimensional Modeling).
• Experience building large-scale ETL/ELT pipelines.
• Strong understanding of Data Warehousing concepts.

Cloud Platforms

Experience with at least one:

• AWS
• Azure
• Google Cloud Platform

Programming

Strong experience in:

• Python
• SQL
• Shell Scripting (preferred)

Data Integration Tools (Any)

Experience with one or more:

• DBT
• Apache Airflow
• Informatica
• Matillion
• Talend
• Fivetran

DevOps (Preferred)

• Git
• CI/CD pipelines
• Terraform
• Docker

Preferred Qualifications

• Snowflake certification preferred.
• Cloud certifications (AWS/Azure/Google Cloud Platform) are a plus.
• Experience working in Agile environments.
• Strong communication and stakeholder management skills.