What are the responsibilities and job description for the Snowflake Architect position at DATAECONOMY?
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.