Snowflake Architect - Westwood, RI/ Phoenix, AZ

Required Skills

Snowflake

• Snowflake Architecture and Data Cloud
• Snowpipe, Snowpipe Streaming
• Streams & Tasks
• Dynamic Tables
• Materialized Views
• Secure Data Sharing
• Zero Copy Cloning
• Time Travel & Fail-safe
• Snowpark
• Performance Tuning & Query Optimization
• Cost Optimization Strategies

Data Engineering

• Data Warehousing Concepts
• Data Modeling (Dimensional, Data Vault)
• ETL/ELT Architecture
• Data Lakes and Lakehouse Architecture
• CDC (Change Data Capture)
• Metadata Management and Data Governance

Programming

• SQL (Expert Level)
• Python
• PySpark
• Shell Scripting

Cloud Platforms

• AWS / Azure / Google Cloud Platform
• Object Storage (S3, ADLS, GCS)
• IAM and Security Services

Integration & Orchestration

• Airflow / Azure Data Factory / Informatica / Matillion / Talend / DBT
• Kafka (Preferred)
• REST APIs

Required Experience

• 10+ years of overall data engineering and warehouse experience.
• 4+ years of hands-on Snowflake architecture experience.
• Experience designing enterprise data platforms and modern analytics solutions.
• Experience with cloud migration and modernization programs.
• Strong experience with large-scale data transformation and integration projects.
• Exposure to AI/ML data platforms and advanced analytics is a plus.

Preferred Qualifications

• SnowPro Advanced Architect Certification.
• AWS/Azure/Google Cloud Platform Cloud Certifications.
• Experience with DBT, Snowpark, and Data Mesh architecture.
• Experience managing large enterprise data ecosystems.

Key Competencies

• Solution Architecture
• Stakeholder Management
• Technical Leadership
• Problem Solving
• Cost Optimization
• Performance Engineering
• Client Communication
• Team Mentoring
• GenAI/LLM integration with Snowflake Cortex.
• Experience with Data Governance tools (Collibra, Alation, Purview).
• Knowledge of real-time analytics and streaming architectures.