Data & AI Solution Architect -- Snowflake
Posted Updated
Description
Job Description This is a hands-on Senior role at the intersection of data engineering, cloud architecture, and generative AI. You will serve as the primary technical authority on our Snowflake Data Cloud strategy - designing scalable, secure, and cost-efficient data platforms that underpin enterprise analytics, operational reporting, and AI-native applications. You will get hands-on with complex architectural problems while influencing direction at the executive level. Skills & Experience: Overall, 10-15 years of experience in Solution Architecture, Data Management, Data Lake and Lakehouse design and development. Snowflake (expert): Virtual warehouses, Snowpark, Cortex AI (LLM functions, vector search, Document AI, Cortex Guard), Dynamic Tables, Streams & Tasks, Data Sharing Data modelling (expert): Data vault 2.0, Kimball dimensional, hybrid schemas; conceptual, logical, and physical design for analytics and AI workloads dbt (advanced): Core and Cloud; modular transformation layer design, testing frameworks, and CI/CD integration with Snowflake Python / Snowpark (proficient): Custom UDFs, ML pipelines, data transformation logic running natively inside Snowflake compute RAG & GenAI (proficient): End-to-end pipeline design - chunking, embedding, vector search, LLM integration, source citation, output validation Cloud (advanced in one, working in others): AWS (S3, Glue, Step Functions), Azure (Data Factory, Key Vault, Synapse), Google Cloud Platform (Dataflow, Composer, BigQuery) Data integration: Fivetran, Airbyte, Kafka, Snowpipe - batch and streaming ingestion patterns at enterprise scale Security & governance: RBAC, dynamic data masking, row-level security, column encryption, private link, SOX / GDPR / HIPAA compliance patterns DevOps & IaC: Git, CI/CD for dbt and Snowflake (GitHub Actions, dbt Cloud), Terraform for infrastructure-as-code Orchestration: Apache Airflow, Prefect, or Dagster in production - dependency management, alerting, and retry patterns Preferred Qualifications SnowPro Core Certification (required within 90 days); SnowPro Advanced: Architect strongly preferred AWS Certified Solutions Architect Professional, Azure Solutions Architect Expert, or Google Cloud Platform Professional Cloud Architect
Skills
- AI
- Airbyte
- Airflow
- Analytics
- AWS
- Azure
- Azure Data Factory
- BigQuery
- CI/CD
- Cloud
- Dagster
- Data Engineering
- Data Lake
- Data Modeling
- Data Vault
- dbt
- DevOps
- Fivetran
- GCP
- Gdpr
- Generative AI
- Git
- GitHub
- GitHub Actions
- Hipaa
- Infrastructure as Code
- Kafka
- Lakehouse
- LLM
- Machine Learning
- Prefect
- Python
- RBAC
- S3
- Snowflake
- Snowpark
- Terraform
- Vault
- Vector Search
Sign in to read and join the discussion.