Designs and leads enterprise Snowflake data architectures, cloud data platforms, ELT/ETL pipelines, and AI-powered applications. Builds RAG, semantic search, Cortex Agents, vector embedding, and Cortex AI Function solutions using Snowpark, Python, SQL, and dbt. Establishes secure, governed, and cost-optimized data environments, mentors engineering teams, leads architecture reviews, and partners with stakeholders on scalable data and generative AI solutions.
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: Snowflake Lead Data Engineer/ Architect
Location: NYC, NY
Full time role
Job Description:
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
- 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.
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
- RAG Architecture
- 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
- 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.
- 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.
- 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
Similar Jobs
Artificial Intelligence • Cloud • Fintech • Information Technology • Insurance • Financial Services • Big Data Analytics
Lead planning, coordination, and delivery of multiple strategic programs and projects using Waterfall and Agile. Develop project plans, governance, status reporting, and dashboards; manage risks, dependencies, testing coordination, and stakeholder communications to ensure timely solution delivery.
Top Skills:
JIRAMS OfficeMicrosoft PowerpointMicrosoft Project
Artificial Intelligence • Cloud • Fintech • Information Technology • Insurance • Financial Services • Big Data Analytics
Leads an 11-person brokerage operations team supporting transfers of assets and account maintenance. Oversees service performance, operational controls, principal reviews, complex cases, audits, coaching, and employee development. Partners with cross-functional teams to resolve operational challenges and improve processes through root-cause analysis, automation, AI-enabled tools, and continuous improvement. Requires FINRA Series 7, 24, and 53 licenses plus brokerage operations expertise.
Top Skills:
Ai-Enabled ToolsAutomationFbsiFidelity WealthscapeMicrosoft 365OnbaseSales Central
Artificial Intelligence • Cloud • Fintech • Information Technology • Insurance • Financial Services • Big Data Analytics
Supports private fixed-income investment teams by improving origination, underwriting, portfolio management, reporting, and technology workflows. Partners with investment, Operations, and IT teams to gather requirements, maintain investment platforms, build dashboards and reports, automate data integration, support AI-enabled tools, and implement platform enhancements. Develops analyses and materials for credit monitoring, portfolio surveillance, and investment committees.
Top Skills:
Ai-Enabled ToolsAPIsDashboardsPythonReporting AutomationSQL
What you need to know about the NYC Tech Scene
As the undisputed financial capital of the world, New York City is an epicenter of startup funding activity. The city has a thriving fintech scene and is a major player in verticals ranging from AI to biotech, cybersecurity and digital media. It also has universities like NYU, Columbia and Cornell Tech attracting students and researchers from across the globe, providing the ecosystem with a constant influx of world-class talent. And its East Coast location and three international airports make it a perfect spot for European companies establishing a foothold in the United States.
Key Facts About NYC Tech
- Number of Tech Workers: 549,200; 6% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Capgemini, Bloomberg, IBM, Spotify
- Key Industries: Artificial intelligence, Fintech
- Funding Landscape: $25.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Greycroft, Thrive Capital, Union Square Ventures, FirstMark Capital, Tiger Global Management, Tribeca Venture Partners, Insight Partners, Two Sigma Ventures
- Research Centers and Universities: Columbia University, New York University, Fordham University, CUNY, AI Now Institute, Flatiron Institute, C.N. Yang Institute for Theoretical Physics, NASA Space Radiation Laboratory
