Data & AI Solution Architect -- Snowflake

Sage IT Inc
United States
2 days ago
Apply on www.dice.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
10 years minimum
Working hours
Regular working hours
Job source

Tech stack

Artificial Intelligence Airflow Amazon Web Services Amazon S3 ARM Architecture Microsoft Azure BigQuery Cloud Computing Cloud Engineering Encodings Continuous Integration Information Engineering
+25 more
Data Integration Data Transformation Data Sharing Data Vault Modeling DevOps Data Flow Control Github Python (Programming Language) Role-Based Access Control Search Technologies Google Cloud Retrieval-Augmented Generation Large Language Models Snowflake Generative AI Git Data Lakes Apache Kafka Data Management Machine Learning Operations Cloud Optimization Physical Design Terraform Intelligent Document Processing Key Vault

Job 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

Requirements

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

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.dice.com
Prepare application

Good distractions

Loading talks and stories from around this role…