Snowflake Architect

DATAECONOMY; New York (NY); On-site; USD 150,000 - 190,000; Full time

Job summary

DATAECONOMY in Manhattan, NYC is seeking a seasoned Data Architect with Snowflake expertise to design scalable cloud data platforms for Capital Markets clients. You will lead architecture discussions, drive delivery, and mentor teams while delivering AI-enabled data solutions using Snowflake Cortex.

The role requires hands-on Snowflake Cortex AI experience, strong client-facing skills, and deep knowledge of cloud data platforms and governance.

Qualifications

• 10+ years in Data Engineering, Data Warehousing, Cloud Data Platforms.
• Strong expertise in Snowflake Architecture, data modeling, performance tuning, security, governance.
• Hands-on Snowflake Cortex AI: RAG, Semantic Search, Multi-Agent frameworks.
• Experience designing scalable ELT/ETL pipelines using Snowflake.
• Experience in Capital Markets domain (Trading, Risk, Market Data, Securities, Asset Management).
• Strong SQL and Snowflake Scripting skills.
• Cloud experience (AWS or Azure) and data governance.
• Excellent communication and client-facing consulting skills.

Responsibilities

• Design and implement enterprise-scale Snowflake data platform architectures.
• Build AI-powered data solutions using Snowflake Cortex AI, RAG pipelines, Semantic Search, and Multi-Agent frameworks.
• Develop secure, scalable Snowflake solutions for Capital Markets use cases.
• Lead migration from Oracle/DB2 to Snowflake.
• Design and optimize ELT pipelines using Talend and cloud-native tech.
• Implement Snowflake best practices for performance, security, governance, and cost.
• Integrate Snowflake with cloud services, AI/ML platforms, APIs, and enterprise apps.
• Collaborate with stakeholders to translate requirements into scalable solutions.
• Conduct architecture reviews, workshops, and client presentations.
• Mentor teams and establish engineering best practices.

Skills

Snowflake architecture

RAG pipelines

Semantic search

Cortex Analyst

Cortex search

Multi-agent AI systems

LLM integration

ELT/ETL pipelines

SQL

Snowflake Scripting

Capital Markets domain

Cloud platforms (AWS/Azure)

Data governance and security

Client-facing / leadership

Education

Bachelor's/Master's in CS/IT/Engineering

Tools

Snowpark (Python/Java)

Talend

Azure

AWS

Denodo

Apache Iceberg

Terraform

Job description

Full-time

Data Architect – Snowflake

Manhattan, NYC

Full-time

We are seeking an experienced Snowflake Architect with expertise in Snowflake AI/Cortex capabilities to design and implement scalable cloud data platforms for Capital Markets clients. The ideal candidate will have hands‑on experience with Snowflake Cortex AI (RAG, Semantic Search, and Multi‑Agent Systems), enterprise data architecture, and cloud‑based analytics solutions. This role requires strong client‑facing experience, excellent communication skills, and the ability to lead technical discussions, solution design, and delivery.

Must-Have Skills

• 10+ years of experience in Data Engineering, Data Warehousing, and Cloud Data Platforms.
• Strong expertise in Snowflake Architecture, data modeling, performance tuning, security, and governance.
• Hands-on experience with Snowflake Cortex AI, including:
• Retrieval-Augmented Generation (RAG)
• Semantic Search
• Cortex Analyst
• Cortex Search
• Multi-Agent AI Systems
• LLM integration and AI-powered analytics
• Experience designing scalable ELT/ETL pipelines using Snowflake.
• Strong SQL and Snowflake Scripting skills.
• Experience in Capital Markets domain (Trading, Risk, Market Data, Securities, Asset Management, or Investment Banking).
• Strong understanding of cloud platforms (AWS or Azure).
• Experience with data governance, security, RBAC, masking policies, and data sharing.
• Excellent communication, stakeholder management, and client-facing consulting skills.
• Ability to lead architecture discussions, mentor teams, and drive solution delivery.

Nice-to-Have Skills

• PostgreSQL
• Talend
• Azure or AWS
• Denodo
• Apache Iceberg Tables
• Experience migrating legacy databases such as Oracle and DB2 to Snowflake
• Snowpark (Python/Java)
• CI/CD, Terraform, GitHub Actions or Azure DevOps
• Knowledge of Data Mesh and Lakehouse architectures

Key Responsibilities

• Design and implement enterprise-scale Snowflake data platform architectures.
• Build AI-powered data solutions using Snowflake Cortex AI, RAG pipelines, Semantic Search, and Multi-Agent frameworks.
• Develop secure, scalable, and high-performance Snowflake solutions for Capital Markets use cases.
• Lead migration projects from Oracle, DB2, and other legacy platforms to Snowflake.
• Design and optimize ELT pipelines using Talend and cloud-native technologies.
• Implement Snowflake best practices for performance optimization, security, governance, and cost management.
• Integrate Snowflake with cloud services, AI/ML platforms, APIs, and enterprise applications.
• Collaborate with business stakeholders to translate requirements into scalable technical solutions.
• Conduct architecture reviews, technical workshops, and client presentations.
• Mentor development teams and establish engineering best practices.

Preferred Qualifications

• Bachelor''s or Master''s degree in Computer Science, Information Technology, Engineering, or a related field.
• SnowPro Advanced or SnowPro Architect certification preferred.
• Cloud certifications (AWS or Azure) are a plus.
• Experience delivering enterprise data modernization initiatives in Financial Services or Capital Markets environments.

This role is ideal for a senior architect who combines deep Snowflake architecture expertise, AI-enabled data solutions using Snowflake Cortex, and Capital Markets domain knowledge with strong client engagement and leadership capabilities.