Snowflake Data Architect: AI-Powered Cloud Lead

Socket.dev; New York (NY); On-site; USD 180,000 - 240,000; Full time

Job summary

DATAECONOMY in NYC seeks an experienced Snowflake Data Architect to design and implement modern cloud data platforms and AI-powered analytics using Snowflake Cortex AI. The role focuses on data engineering, architecture, and governance, delivering scalable, secure data solutions.

You'll lead end-to-end Snowflake implementations, build ELT/ETL pipelines with Snowpark, Python, dbt, and design Cortex AI-powered data products with RBAC and cost optimization; collaboration with stakeholders is

Qualifications

• 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.
• Hands-on experience with Snowflake Cortex AI: Cortex AI Functions, Cortex Search, Cortex Agents, RAG Architecture, Semantic Search, Vector Embeddings.
• 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.

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.

Skills

Snowflake Architecture

Snowflake Data Cloud

Snowpark (Python/Scala)

SQL

Data Modeling

ELT/ETL Design

RAG Architecture

Semantic Search

Cortex AI Functions

CI/CD

Education

Bachelor's or Master's in CS/IT

Tools

dbt

Kubernetes

Docker

Airflow

Databricks

Terraform

REST APIs

Kafka

PostgreSQL

Job description

DATAECONOMY in NYC seeks an experienced Snowflake Data Architect to design and implement modern cloud data platforms and AI-powered analytics using Snowflake Cortex AI. The role focuses on data engineering, architecture, and governance, delivering scalable, secure data solutions.

You'll lead end-to-end Snowflake implementations, build ELT/ETL pipelines with Snowpark, Python, dbt, and design Cortex AI-powered data products with RBAC and cost optimization; collaboration with stakeholders is