Sr Technical Architect I Snowflake Architecture

Job description

Role: Senior Snowflake Lead

Experience: 12+ Years

Location: Remote

What you ll be doing

We are seeking a Senior Snowflake Lead with strong experience in Snowflake, 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, or Data Platforms.
• 4+ years of hands-on Snowflake 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