Snowflake Data Lead/ Architect

DATAECONOMY Inc

New York (NY)

On-site

USD 150,000 - 210,000

Full time

6 days ago

Be an early applicant

Application generator

An application made for this job — a tailored resume and cover letter that speak straight to the posting.

Get past ATS filters

Job summary

DATAECONOMY is seeking an experienced Snowflake Data Architect to design and implement modern cloud data platforms with AI-powered analytics. The role emphasizes Snowflake architecture, data engineering, and Generative AI capabilities including Cortex AI Functions, Cortex Search, and Cortex Agents for secure, scalable solutions.

The ideal candidate will lead architecture decisions, mentor teams, and collaborate with business stakeholders to translate requirements into scalable data and AI

Qualifications

10+ years of Data Engineering/Data Architecture experience.
5+ years of hands-on Snowflake implementation experience.
Strong expertise in Snowflake Data Cloud, Snowpark, and SQL.
Experience with Cortex AI and enterprise AI capabilities on Snowflake.
Knowledge of data governance, security, and RBAC within cloud data platforms.
Experience with CI/CD and DevOps practices in data projects.
Excellent communication and stakeholder management skills.

Responsibilities

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 RAG solutions using Cortex Search and vector embeddings.
Implement Semantic Search and enterprise knowledge retrieval.
Design and deploy Cortex Agents and multi-agent AI workflows.
Develop AI-powered data applications using Cortex AI Functions.
Design secure AI architectures with RBAC and governance.
Optimize Snowflake performance, storage, clustering, and cost.
Collaborate with stakeholders to translate requirements into scalable data/AI solutions.
Mentor engineering teams and establish architecture best practices.

Skills

Snowflake Data Cloud

Snowpark Python/Scala

SQL

Data Modeling

ELT/ETL Design

Cortex AI Functions

Cortex Search

Cortex Agents

Semantic Search

Vector Embeddings

LLM Integration

Governance & Security

CI/CD & DevOps

Data Governance

Communication & Stakeholder Mgmt

Education

Bachelor's or Master's degree in Computer Science / IT

Tools

dbt

Kafka

Airflow

Talend

Job description

New York, United States | Posted on 09/10/2026

DATAECONOMY is one of the fastest-growing Data & Analytics company with global presence. We are well-differentiated and are known for our Thought leadership, out-of-the-box products, cutting-edge solutions, accelerators, innovative use cases, and cost-effective service offerings.

We offer products and solutions in Cloud, Data Engineering, Data Governance, AI/ML, DevOps and Blockchain to large corporates across the globe. Strategic Partners with AWS, Collibra, cloudera, neo4j, DataRobot, Global IDs, tableau, MuleSoft and Talend.

Location: NYC, NY

Full time role

Job Description

We are seeking an experienced Snowflake Data Architectwith expertise in Snowflake Cortex AIto 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 asRAG (Retrieval-Augmented Generation), Semantic Search, Cortex AI Functions, Cortex Agents, and Snowparkto 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.

Key Responsibilities

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.

Required Skills

10+ years of Data Engineering/Data Architecture experience.
5+ years of hands-on Snowflake implementation experience.
Strong expertise in:
Snowflake Data Cloud
Snowpark (Python/Scala)
SQL
Data Modeling (Dimensional & Data Vault)
ELT/ETL Design
Hands-on experience with Snowflake Cortex AI:
Cortex AI Functions
Cortex Search
Cortex Agents
Semantic Search
Vector Embeddings
Prompt Engineering
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.

Nice to Have

Capital Markets, Banking, or Financial Services experience.
Experience with PostgreSQL, Oracle, SQL Server, or DB2 migrations.
dbt
Kafka
Airflow
Talend
Databricks
Terraform
REST APIs
LangChain or similar GenAI orchestration frameworks

Preferred Qualifications

Bachelor's or Master's degree in Computer Science, Information Technology, or a related field.
Snowflake SnowPro Advanced Certifications.
Cloud certifications (AWS, Azure, or GCP).
AI/ML or Generative AI certifications are a plus.

Preferred Experience