What you'll be doing
We are seeking a Senior Snowflake Architect with strong experience in Snowflake architecture, administration, and cloud data platforms. This is a hands-on role responsible for designing, managing, securing, and optimizing the Snowflake environment while working closely with data engineering, analytics, and cloud teams.
Key Responsibilities:
Architecture & Development
- Design and build scalable Snowflake data warehouse and data lake solutions.
- Develop data models, ETL/ELT pipelines, and analytics-ready datasets.
- Implement Snowflake Data Sharing and advanced features such as Cortex AI.
- Create secure and governed data solutions using masking, encryption, and access controls.
- Partner with business and technical teams to translate requirements into scalable solutions.
- Evaluate and adopt new Snowflake capabilities to improve performance, security, and cost efficiency.
Platform Administration
- Manage Snowflake environments across development, testing, and production.
- Administer databases, schemas, warehouses, users, roles, and permissions.
- Monitor platform performance, availability, and costs.
- Troubleshoot performance, data pipeline, and access issues.
- Implement disaster recovery, replication, backup, and failover strategies.
- Maintain documentation, architecture diagrams, and operational procedures.
- Ensure compliance with data governance, privacy, and security standards.
- Provide technical guidance to Snowflake administrators and support teams.
Required Skills:
- 8+ years of experience in Data Engineering, Data Architecture, or Data Platforms.
- 4+ years of hands-on Snowflake architecture and administration experience.
- Strong expertise in:
- Snowflake Architecture & Administration
- Data Warehousing & Dimensional Modeling
- Advanced SQL
- ETL/ELT Pipeline Development
- Performance Tuning & Cost Optimization
- Snowflake Security & Governance
- Experience with AWS and/or Azure cloud platforms.
- Experience with GitHub and CI/CD pipelines.
- Strong troubleshooting, communication, and stakeholder management skills.
Preferred Skills:
- Python
- Terraform, Bash, or other automation tools
- Snowflake Horizon
- Cortex AI
- Snowflake Data Sharing
- SnowPro Core Certification