Data Architecture Lead
Snowflake · Menlo Park, CA · 2 wk ago
Art & Creative$214k–$281k/yrFull-time
About the role
This is a senior individual contributor role within the Data, Analytics, and AI organization at Snowflake. The role requires an in-office presence for a minimum of 3 days per week.
Responsibilities
- Define and deploy architectural standards across analytics and data engineering teams, covering data modeling patterns in dbt, RBAC frameworks, deployment workflows, and code quality standards
- Build and deploy AI-powered tooling and skills — including agent frameworks, prompt-driven workflows, and LLM-enabled automation — for use across analytics and data engineering teams
- Elevate the RBAC framework for the data platform, including designing and implementing row access policies, column masking policies, and role-based access control patterns at scale in Snowflake
- Partner with Snowflake's product and engineering teams on feature testing and feedback — write meaningful product specifications, develop proof-of-concepts, and help push the Snowflake platform forward
- Represent Snowflake's internal data capabilities externally, meeting with customers to demonstrate what is possible on the platform and sharing real-world architectural patterns and learnings
- Act as a strategic lever across teams — bridging data engineering and analytics engineering to drive alignment, reduce redundancy, and raise the technical bar organization-wide
- Enable the team through documentation, knowledge sharing, and mentorship — setting standards that scale beyond your own direct contributions
Requirements
- 8+ years of experience in data engineering, analytics engineering, or data architecture roles
- Deep expertise in Snowflake, including advanced data modeling, performance optimization, RBAC design, and the broader Snowflake feature set (Cortex, Dynamic Tables, Streams, Tasks, etc.)
- Expert-level dbt skills (dbt Core and/or dbt Platform), including macro development, testing frameworks, CI/CD integration, and large-scale project management
- Strong proficiency with AI development tools, including experience with LLM-powered workflows, agent frameworks (e.g., Cortex Agents, Claude Code, Cortex Code), and prompt engineering for data use cases
- Experience designing and implementing RBAC frameworks at scale — including row access policies, masking policies, and role hierarchies in Snowflake or similar platforms
- Excellent written and verbal communication skills, with a track record of writing clear technical specs, architecture documents, and stakeholder-facing materials
- Ability to operate with principal-level scope: driving cross-functional initiatives, influencing without authority, and delivering outcomes across multiple teams
Preferred Experience
- Experience working at a technology company with a large-scale internal data platform
- Prior experience building or contributing to internal developer tooling, shared libraries, or platform-as-a-product initiatives
- Familiarity with Python for data pipeline development, scripting, and automation
- Experience presenting technical content to external audiences (customers, conferences, etc.)
Qualifications
Every Snowflake employee is expected to follow the company’s confidentiality and security standards for handling sensitive data. Snowflake employees must abide by the company’s data security plan as an essential part of their duties. It is every employee's duty to keep customer information secure and confidential.
Skills
- Strong proficiency with AI development tools, including experience with LLM-powered workflows, agent frameworks (e.g., Cortex Agents, Claude Code, Cortex Code), and prompt engineering for data use cases
- Expert-level dbt skills (dbt Core and/or dbt Platform), including macro development, testing frameworks, CI/CD integration, and large-scale project management
- Strong proficiency with Snowflake, including advanced data modeling, performance optimization, RBAC design, and the broader Snowflake feature set (Cortex, Dynamic Tables, Streams, Tasks, etc.)
Benefits
Additional details about benefits can be found on the Snowflake Careers Site: careers.snowflake.com