Snowflake Data Lead/ Architect

DATAECONOMY•New York, NY

1d•Onsite

About The Position

DATAECONOMY is seeking an experienced Snowflake Data Architect with expertise in Snowflake Cortex AI to design, architect, and implement modern cloud data platforms and AI-powered analytics solutions. The ideal candidate will have strong experience in Snowflake architecture, data engineering, and Generative AI capabilities such as RAG (Retrieval-Augmented Generation), Semantic Search, Cortex AI Functions, Cortex Agents, and Snowpark to deliver scalable, secure, and intelligent data solutions. Snowflake Cortex enables AI applications, semantic search, AI functions, and agentic workflows directly within Snowflake while keeping data governed inside the platform.

Requirements

10+ years of Data Engineering/Data Architecture experience.
5+ years of hands-on Snowflake implementation experience.
Strong expertise in Snowflake Architecture
Strong expertise in Snowflake Data Cloud
Strong expertise in Snowpark (Python/Scala)
Strong expertise in SQL
Strong expertise in Data Modeling (Dimensional & Data Vault)
Strong expertise in ELT/ETL Design
Hands-on experience with Snowflake Cortex AI: Cortex AI Functions, Cortex Search, Cortex Agents
Hands-on experience with RAG Architecture
Hands-on experience with Semantic Search
Hands-on experience with Vector Embeddings
Hands-on experience with Prompt Engineering
Hands-on experience with LLM Integration
Experience with Structured and Unstructured Data.
Experience building enterprise AI applications on Snowflake.
Strong understanding of Data Governance, Security, and AI Governance.
Experience with CI/CD and DevOps.
Strong communication and stakeholder management skills.
Snowflake
Snowflake Cortex AI (RAG, Semantic Search, Cortex Agents, AI Functions)
Snowpark (Python)
SQL
Data Modeling
Data Architecture
Cloud (AWS/Azure/GCP)
Strong communication and client-facing experience

Nice To Haves

Capital Markets, Banking, or Financial Services experience.
Experience with PostgreSQL, Oracle, SQL Server, or DB2 migrations.
dbt
Apache Iceberg
Kafka
Airflow
Talend
Denodo
Azure, AWS, or GCP
Databricks
Terraform
Docker & Kubernetes
REST APIs
LangChain or similar GenAI orchestration frameworks

Responsibilities

Design enterprise-scale data architectures using Snowflake.
Lead end-to-end implementation of Snowflake Data Cloud solutions.
Architect modern data warehouses, data lakes, and Lakehouse solutions.
Design scalable ELT/ETL pipelines using Snowpark, SQL, Python, and dbt.
Build AI-powered data products using Snowflake Cortex AI.
Develop Retrieval-Augmented Generation (RAG) solutions using Cortex Search and vector embeddings.
Implement Semantic Search and enterprise knowledge retrieval solutions.
Design and deploy Cortex Agents and multi-agent AI workflows.
Develop AI-powered data applications using Cortex AI Functions (AI_COMPLETE, AI_CLASSIFY, AI_FILTER, AI_SUMMARIZE, AI_TRANSLATE, etc.).
Design secure AI architectures with RBAC, masking policies, row/column-level security, and governance.
Optimize Snowflake performance, storage, clustering, and cost.
Build metadata-driven and reusable data frameworks.
Collaborate with business stakeholders to translate requirements into scalable data and AI solutions.
Mentor engineering teams and establish architecture best practices.