Snowflake Solution Architect

Job Title: Snowflake Architect (AI / Capital Markets)

Location: Open / Hybrid / Onsite
Experience: 10+ Years

Job Summary

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.