Senior Snowflake Data Warehouse Architect / Lead Snowflake Data Engineer

Hybrid in West Sacramento, CA, US • Posted 2 hours ago • Updated 1 hour ago
Contract W2
Contract Corp To Corp
Contract Independent
2 Years
No Travel Required
Hybrid
Depends on Experience
Fitment

Dice Job Match Score™

🔢 Crunching numbers...

Job Details

Skills

  • Snowflake
  • Snowflake Architect
  • Snowflake Data Warehouse
  • Snowflake Data Cloud
  • Snowflake Implementation
  • Snowflake Architecture
  • Snowflake Data Engineering
  • SnowSQL
  • Snowflake Stored Procedures
  • Snowflake UDF
  • Snowpipe
  • Streams and Tasks
  • Data Warehouse Architect
  • Data Warehouse Design
  • Enterprise Data Warehouse
  • Data Modeling
  • Star Schema
  • Snowflake Schema
  • Data Vault
  • SQL
  • Advanced SQL
  • SQL Development
  • Query Optimization
  • Performance Tuning
  • Python
  • Python Development
  • ETL
  • ELT
  • Data Engineering
  • AWS Glue
  • AWS Lambda
  • Amazon S3
  • S3 Data Lake
  • AWS Step Functions
  • AWS Data Lake
  • Cloud Data Engineering
  • Data Integration
  • Batch Processing
  • Data Pipelines
  • Data Migration
  • Data Transformation
  • Cloud Architecture
  • Data Governance
  • Data Quality
  • Analytics Platform
  • Big Data
  • Data Platform
  • AWS
  • SnowPro
  • Cloud Migration
  • Data Architecture
  • Enterprise Analytics
  • Database Design
  • Data Ingestion Frameworks
  • Real-Time Processing
  • Data Orchestration
  • Metadata Management
  • Data Security
  • Business Intelligence
  • Reporting Solutions
  • Data Modernization
  • Cloud Native Architecture
  • Lakehouse Architecture.

Summary

Position Overview

We are seeking a highly experienced Senior Snowflake Data Warehouse Architect with deep expertise in designing, architecting, and implementing enterprise-scale data warehouse solutions on the Snowflake Data Cloud Platform. The ideal candidate will have a proven track record of leading Snowflake data warehouse initiatives from inception through production deployment, including data modeling, ETL/ELT framework design, cloud-native data pipelines, performance optimization, and operational excellence.

This role requires a hands-on technical leader with strong experience across Snowflake, AWS Data Lake technologies, Python, SQL, and modern cloud-based data integration services. Candidates must possess a minimum of 5+ years of full-time hands-on experience specifically focused on Snowflake architecture, design, and implementation.

Required Experience

Snowflake Architecture and Data Warehousing

  • 5+ years of full-time, hands-on experience designing, architecting, and implementing enterprise data warehouse solutions using Snowflake.
  • Proven experience building Snowflake platforms from the ground up, including:
    • Data warehouse architecture design
    • Data modeling (Star Schema, Snowflake Schema, Data Vault)
    • Security architecture and governance
    • Data ingestion frameworks
    • Performance tuning and workload optimization
    • Storage and compute optimization
  • Experience designing scalable, high-performance data platforms supporting analytics, reporting, and advanced data processing workloads.
  • Strong understanding of Snowflake architecture components including:
    • Virtual Warehouses
    • Micro-partitions
    • Clustering
    • Time Travel
    • Data Sharing
    • Streams and Tasks
    • Snowpipe
    • Secure Views
    • RBAC Security Model

Cloud Data Engineering

  • Extensive experience building and maintaining cloud-native data pipelines on AWS.
  • Hands-on experience with:
    • AWS Glue
    • AWS Lambda
    • Amazon S3 Data Lake Architecture
    • AWS Step Functions
    • IAM Security and Access Controls
  • Experience designing and implementing scalable ETL/ELT frameworks for batch and near real-time data processing.
  • Strong knowledge of data integration patterns, orchestration workflows, and data quality controls.

SQL and Snowflake Development

  • 5+ years of hands-on SQL development experience.
  • Advanced expertise writing complex SQL queries for:
    • Data transformation
    • Data validation
    • Data profiling
    • Data reconciliation
    • Performance optimization
  • Extensive experience creating and maintaining:
    • Snowflake Stored Procedures
    • User Defined Functions (UDFs)
    • Views and Materialized Views
    • Streams and Tasks
  • Experience tuning large-scale Snowflake workloads and optimizing query performance.

Python Development

  • 5+ years of hands-on Python programming experience.
  • Strong expertise developing data engineering solutions using Python.
  • Experience building:
    • Data ingestion frameworks
    • ETL/ELT workflows
    • Data quality validation processes
    • Automation solutions
    • Monitoring and alerting utilities
  • Experience integrating Python applications with Snowflake and AWS services.

Key Responsibilities

  • Lead the architecture, design, and implementation of enterprise data warehouse solutions on Snowflake.
  • Design and develop scalable cloud data platforms leveraging AWS and Snowflake technologies.
  • Build end-to-end batch and real-time data ingestion frameworks.
  • Develop and optimize SQL-based transformations, Snowflake stored procedures, and data pipelines.
  • Design and implement data lake and data warehouse integration patterns using Amazon S3.
  • Create robust orchestration workflows using AWS Step Functions.
  • Develop AWS Lambda functions and AWS Glue jobs to support data integration requirements.
  • Define enterprise data architecture standards, best practices, and governance frameworks.
  • Collaborate with business stakeholders, data analysts, engineers, and architects to deliver scalable analytical solutions.
  • Optimize Snowflake performance, storage utilization, and query execution.
  • Establish data quality, security, governance, and monitoring standards.
  • Mentor junior engineers and provide technical leadership across data engineering initiatives.

Preferred Qualifications

  • Experience with CI/CD for data engineering solutions.
  • Knowledge of infrastructure as code (Terraform, CloudFormation).
  • Experience with enterprise data governance and metadata management.
  • Familiarity with Agile and DevOps methodologies.
  • Snowflake Certifications preferred:
    • SnowPro Core Certification
    • SnowPro Advanced Architect Certification
  • AWS Certifications are a plus.

Must-Have Requirements (Screening Criteria)

  • 5+ years of full-time hands-on Snowflake Data Warehouse Architecture experience.
  • Experience designing and implementing Snowflake Data Warehouse platforms from day one.
  • 5+ years of hands-on Snowflake implementation and development experience.
  • 5+ years of advanced SQL development experience.
  • 5+ years of hands-on Python programming experience.
  • Extensive experience developing Snowflake Stored Procedures.
  • Hands-on experience with AWS Glue, Lambda, S3 Data Lake, and Step Functions.
  • Strong understanding of enterprise data modeling and cloud data architecture.
  • Ability to lead architecture discussions and provide technical leadership.

Snowflake, Snowflake Architect, Snowflake Data Warehouse, Snowflake Data Cloud, Snowflake Implementation, Snowflake Architecture, Snowflake Data Engineering, SnowSQL, Snowflake Stored Procedures, Snowflake UDF, Snowpipe, Streams and Tasks, Data Warehouse Architect, Data Warehouse Design, Enterprise Data Warehouse, Data Modeling, Star Schema, Snowflake Schema, Data Vault, SQL, Advanced SQL, SQL Development, Query Optimization, Performance Tuning, Python, Python Development, ETL, ELT, Data Engineering, AWS Glue, AWS Lambda, Amazon S3, S3 Data Lake, AWS Step Functions, AWS Data Lake, Cloud Data Engineering, Data Integration, Batch Processing, Data Pipelines, Data Migration, Data Transformation, Cloud Architecture, Data Governance, Data Quality, Analytics Platform, Big Data, Data Platform, AWS, SnowPro, Cloud Migration, Data Architecture, Enterprise Analytics, Database Design, Data Ingestion Frameworks, Real-Time Processing, Data Orchestration, Metadata Management, Data Security, Business Intelligence, Reporting Solutions, Data Modernization, Cloud Native Architecture, Lakehouse Architecture.

 

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 10126850
  • Position Id: #DW-SNOWFLK#
  • Posted 2 hours ago
Contact the job poster
PV

Pradeep Vashishtha

Recruiter @ Projas Technologies, LLC

Create job alert
Never miss an opportunity! Create an alert based on the job you applied for.