Snowflake Solution Architect

Role description

Position Overview

Location - Austin, TX

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.

Key Responsibilities

1. Core Snowflake Platform Architecture & Solution Design
   

· 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.

1. AI-Accelerated Engineering & Snowflake CoCo Integration
   

· 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.

1. Data Modeling
   

· 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.

1. Enterprise Governance, Security & FinOps
   

· 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), Dynamic Data Masking, Row Access Policies, and Tag-Based Masking.

· FinOps & Resource Optimization: Establish platform cost control guardrails, budget s, resource monitors, and query performance tuning, leveraging CoCo governance frameworks and system usage views to optimize credit consumption across virtual warehouses and AI features.

Required Qualifications

Technical & Architectural Expertise

· Education: Bachelor’s or Master’s degree in Computer Science, Software Engineering, Data Engineering, or a related technical discipline.

· Snowflake Mastery: 5+ years of hands-on experience as a technical architect designing, building, and optimizing enterprise platforms on the Snowflake Data Cloud.

· Data Platform & Solution Design: 10+ years in data platform engineering, enterprise software architecture, and solution design across cloud environments (AWS, Azure, or GCP).

· Snowflake Ecosystem Components:Expert-level mastery of:

· Snowpark (Python/Java/Scala) and Snowpark Container Services (SPCS).

· Dynamic Tables, Streams, Tasks, and event-driven data pipelines.

· Snowflake CoCo (Cortex Code) for AI-driven development, CLI automation, and agent building.

· Cortex AI functions, Cortex Search, and Streamlit in Snowflake.

· Snowflake Horizon security controls (RBAC, Row Access Policies, Data Masking).

· Data Modeling & Engineering: Deep proficiency in SQL, Python, dbt, Data Vault 2.0, Kimball dimensional modeling, and API-based data ingestion frameworks.

Key Competencies

· Solution Architecture Leadership: Ability to take vague business requirements and convert them into concrete, well-architected, and scalable Snowflake design patterns.

· Technical Communication: Excellent technical design documentation skills (data flow diagrams, architecture blueprints, security topologies) and executive presentation abilities.

· Performance Tuning: Advanced skills in analyzing Query Profiles, micro-partitioning, clustering keys, search optimization, and resolving data skew issues.