Snowflake Data Lead/ Architect

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.

Role:SnowflakeLead Data Engineer/ Architect

Location: NYC, NY

Full time role

We are seeking an experiencedSnowflakeData Architectwith expertise inSnowflakeCortex AIto design, architect, and implement modern cloud data platforms and AI-powered analytics solutions. The ideal candidate will have strong experience inSnowflakearchitecture, 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.SnowflakeCortex enables AI applications, semantic search, AI functions, and agentic workflows directly withinSnowflakewhile keeping data governed inside the platform.

Key Responsibilities

• Design enterprise-scale data architectures usingSnowflake.
• Lead end-to-end implementation ofSnowflakeData 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 usingSnowflakeCortex 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.
• OptimizeSnowflakeperformance, 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-onSnowflakeimplementation experience.

Strong expertise in

SnowflakeArchitecture

Snowflake Data Cloud

Snowpark (Python/Scala)

Data Modeling (Dimensional & Data Vault)

ELT/ETL Design

Hands-on experience withSnowflakeCortex AI

Cortex AI Functions

Cortex Search

Cortex Agents

RAG Architecture

Semantic Search

Vector Embeddings

Prompt Engineering

LLM Integration

• Experience with Structured and Unstructured Data.
• Experience building enterprise AI applications onSnowflake.
• 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

Apache Iceberg

Kafka

Airflow

Talend

Denodo

Azure, AWS, or GCP

Databricks

Terraform

Docker & Kubernetes

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.
• SnowflakeSnowPro Advanced Certifications.
• Cloud certifications (AWS, Azure, or GCP).
• AI/ML or Generative AI certifications are a plus.

Preferred Experience

• Designing enterprise-scaleSnowflakeplatforms.
• Implementing AI-driven analytics and intelligent search solutions.
• Building production-grade RAG applications.
• Architecting semantic layers and enterprise knowledge retrieval.
• Delivering AI-powered data products with strong governance and security.
• Leading architecture reviews, technical strategy, and client engagements.

Requirements

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

Benefits

Full-time