Snowflake Architect - Cortex & Agentic AI Lead
Capgemini · Irving, TX · 3 mo ago
Art & CreativeFull-time
About the role
We are seeking a highly experienced Snowflake Architect with deep expertise in Snowflake Cortex and Agentic AI to lead and guide a team of approximately 25 engineers and AI practitioners in delivering enterprise-scale Agentic AI solutions.
Responsibilities
- Lead end-to-end architecture and solution design for Snowflake-based data, analytics, and AI platforms.
- Provide technical leadership and mentorship to a team of 25+ engineers, architects, and developers delivering Agentic AI solutions.
- Audit existing AI agents and Agentic AI implementations, identifying what is working well, what is not, and providing recommendations for optimization and scalability.
- Establish architectural standards, governance frameworks, and best practices for building, deploying, and managing AI agents.
- Architect and implement AI-powered solutions leveraging Snowflake Cortex capabilities, including Cortex Search, Cortex Analyst, LLM Functions, Document AI, vector embeddings, semantic search, and RAG patterns.
- Drive the adoption of Agentic AI frameworks and guide teams on designing autonomous, intelligent, and business-aligned AI workflows.
- Design and optimize Snowflake data warehouses, data lakes, and lakehouse architectures for analytics, reporting, AI, and machine learning workloads.
- Develop AI-ready data foundations, semantic layers, and reusable data products that support advanced analytics and Generative AI use cases.
- Collaborate with Data Engineers, Data Scientists, Product Owners, Business Stakeholders, and AI teams to align technical solutions with business objectives.
- Define performance metrics, evaluation criteria, and governance processes for AI agents and enterprise AI solutions.
- Implement secure and scalable architectures with strong focus on RBAC, data governance, data privacy, masking policies, encryption, and compliance requirements.
Requirements
- 10+ years of experience in Data Architecture, Data Engineering, Analytics, or Enterprise Data Platforms.
- Strong expertise in Snowflake architecture, including Warehouses, Snowpark, Streams, Tasks, Data Sharing, Time Travel, Zero-Copy Cloning, Resource Monitors, and Security Frameworks.
- Deep hands-on experience with Snowflake Cortex, including: Cortex Search, Cortex Analyst, Cortex LLM Functions, Vector Embeddings, Semantic Search, RAG (Retrieval-Augmented Generation) Architectures, Document AI.
- Proven experience designing, evaluating, and improving Agentic AI solutions and AI agent frameworks.
- Strong understanding of AI agent orchestration, autonomous workflows, prompt engineering, semantic retrieval, and enterprise GenAI architectures.
- Expertise in SQL, data modeling, ETL/ELT design, and cloud-based data platforms.
- Experience designing scalable solutions for analytics, reporting, AI, and machine learning workloads.
- Strong knowledge of data governance, data quality, lineage, security, and compliance frameworks.
Preferred Qualifications
- Experience building and optimizing enterprise AI agents and Agentic AI applications.
- Experience with LangChain, LangGraph, CrewAI, AutoGen, Semantic Kernel, or similar AI orchestration frameworks.
- SnowPro Core, Advanced, or Architect Certifications.
- Experience with dbt, Airflow, Kafka, Spark, Fivetran, Matillion, or similar modern data stack technologies.
- Knowledge of vector databases, enterprise search, semantic models, and knowledge retrieval frameworks.
- Experience working with AWS, Azure, or GCP ecosystems.
- Experience in large-scale enterprise environments and AI transformation initiatives.