Data Architect

DATAECONOMY; New York (NY); On-site; USD 140,000 - 200,000; Full time

Job summary

DATAECONOMY in NYC seeks an experienced Snowflake Data Architect to design cloud data platforms with Snowflake Cortex AI capabilities. Lead data warehouses, data lakes, and Lakehouse solutions, and build ELT/ETL pipelines using Snowpark, SQL, Python and dbt while ensuring governance and security.

The ideal candidate has 10+ years in data engineering/architecture, deep Snowflake expertise, Cortex AI features, and strong collaboration to translate requirements into scalable AI-powered data

Qualifications

• 10+ years of Data Engineering/Data Architecture experience.
• 5+ years of hands-on Snowflake implementation experience.
• Strong expertise in Snowflake Architecture and Snowflake Data Cloud.
• Experience with Snowpark (Python/Scala) and SQL.
• Knowledge of data modeling (Dimensional & Data Vault).
• Experience with Cortex AI Functions, Cortex Search, Cortex Agents, and Semantic Search.

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 solutions.
• 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, masking policies, and data governance.
• Optimize Snowflake performance, storage, clustering, and cost.

Skills

Snowflake

Snowflake Cortex AI

Snowpark (Python)

SQL

Data Modeling

Education

Bachelor's or Master's in CS/IT

Tools

dbt

Python

Kafka

Job description

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.

About the Role:

Snowflake Data Architect – Snowflake Cortex AI

NYC, NY

Full-time

Job Summary

We are 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.

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 Architecture
• 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

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

• Designing enterprise-scale Snowflake platforms.
• Implementing AI-driven analytics and intelligent search solutions.
• 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.

Must Have Skills

• Snowflake
• Snowflake Cortex AI (RAG, Semantic Search, Cortex Agents, AI Functions)
• Snowpark (Python)
• SQL
• Data Modeling
• Strong communication and client-facing experience

Nice to Have Skills

• Talend
• Legacy database migrations (Oracle, DB2)
• dbt
• CI/CD and Terraform