Snowflake Solution Architect

About the role

We are seeking a highly technical, hands-on Snowflake Solution Architect with deep expertise in cloud data platform architecture, solution design, and AI-accelerated engineering to lead the design and implementation of our enterprise Sales Planning & Financial Forecasting data estate. In this role, you will be the primary technical authority for our Snowflake AI Data Cloud ecosystem. You will architect high-performance, cost-optimized, and secure data platform solutions that ingest, transform, and serve complex planning and forecasting workloads (integrating source feeds from engines such as Oracle Demantra, Anaplan, Hyperion, SAP, and Salesforce). You will leverage modern Snowflake capabilities—including Snowflake CoCo (AI coding agent), Snowpark, Dynamic Tables, Cortex AI, Hybrid Tables, and Snowflake Horizon—to design next-generation data architectures for financial forecasting, demand sensing, and scenario modeling.

Location: Austin, TX

Responsibilities

• End-to-End Technical Architecture: Design and deploy enterprise-grade, multi-region Snowflake data architectures aligned with the Snowflake Well-Architected Framework (WAF) to support high-concurrency FP&A, sales planning, and demand forecasting analytics.
• Storage & Compute Strategy: Define optimal warehouse sizing, auto-scaling multi-cluster configurations, query acceleration, search optimization services, and storage strategies incorporating native tables, Hybrid Tables (Unistore), and Apache Iceberg open storage formats.
• Advanced Pipeline & Orchestration Architecture: Architect robust ELT pipelines leveraging Dynamic Tables, Streams & Tasks, and Snowpark (Python/Scala/Java) for declarative data processing, near-real-time synchronization, and complex time-series aggregation.
• Application & Solution Delivery: Architect write-back capabilities and custom financial planning interfaces using Streamlit in Snowflake (SiS), native stored procedures, and REST APIs.
• AI-Native Engineering Workflows: Lead the adoption of Snowflake CoCo (formerly Cortex Code) across Snowsight, CoCo Desktop, and CLI environments to accelerate data model prototyping, pipeline creation, dbt project generation, and SQL optimization.
• Agentic Frameworks & Cortex AI: Architect intelligent conversational agents and analytics tools using Cortex AI, Cortex Search, and the CoCo Agent SDK, enabling FP&A and sales planning teams to perform natural-language query analysis, variance root-cause analysis, and automated scenario modeling.
• Automated Architecture Assessments: Utilize Snowflake CoCo skills to execute automated Well-Architected reviews, health checks, and continuous code quality audits across Snowflake environments.
• Scalable Data Modeling: Design highly performant data models (Kimball Dimensional, Data Vault 2.0, and Real-Time Operational Data Stores) specifically structured for deep hierarchy traversal, financial roll-ups, multi-currency conversions, and territory re-alignments.
• Snowflake Horizon Governance: Implement zero-trust security and data governance policies using Snowflake Horizon, including Role-Based Access Control (RBAC), Attribute-Based Access Control (ABAC