Snowflake Architect - Cortex & Agentic AI Lead

Capgemini • Irving, TX

5d • $90,786 - $120,673 • Hybrid

About The Position

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. This role requires a hands-on architect who can quickly assess existing AI agents, identify strengths and gaps, recommend improvements, and establish best practices to accelerate successful AI adoption across the organization. The ideal candidate will combine strong Snowflake architecture experience with practical expertise in Cortex AI capabilities, RAG architectures, AI agents, semantic search, and enterprise AI solution delivery.

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.

Nice To Haves

• 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.

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.
• Assess 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.
• Design ingestion frameworks including batch, streaming, Snowpipe, and real-time processing solutions.
• 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.

Benefits

• Paid time off based on employee grade (A-F), defined by policy: Vacation: 12-25 days, depending on grade, Company paid holidays, Personal Days, Sick Leave
• Medical, dental, and vision coverage (or provincial healthcare coordination in Canada)
• Retirement savings plans (e.g., 401(k) in the U.S., RRSP in Canada)
• Life and disability insurance
• Employee assistance programs
• Other benefits as provided by local policy and eligibility

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed