Title: AI Solution Architect

Location:  100% Remote – MST/PST Hours (8 AM – 5 PM PST)

Job Type: Contract – 12 Months

Key Skills: Snowflake Cortex, MCP Server, LLM''s

Nice to Have: Python, Vector, RAG, Knowledge Graphs.

About the Role:
AI Solution Architect with at least 12+ years of experience to design, build, and deploy scalable AI solutions that drive business impact. This role partners closely with data engineering, analytics, and product teams to operationalize advanced models and deliver intelligent, production-grade systems

Key Responsibilities:

• Build and maintain semantic models and views optimized for AI and analytics.
• Design, develop, and deploy Cortex Agents with robust reasoning, tooling, and guardrails.
• Configure and operate the Snowflake MCP server; build custom MCP tools for business workflows.
• Enable Snowflake Agents/MCP integration with Copilot and Teams for seamless user experience.
• Develop Streamlit apps in Snowflake that integrate with agents for interactive, AI‑powered experiences.
• Define architecture, governance, and best practices for scalable agentic AI solutions.
• Ensure secure, governed access aligned with enterprise RBAC and data policies.
• Work independently without handholding, self-driven, and focus on achieving results.
• Juggle multiple priorities and manage time effectively.  
• Proactive in handling tasks, providing updates, and managing dependent tasks.
• Translate vague and ambiguous business needs into working prototypes
• Own next steps to turn prototypes into production-grade solutions.
• Agile mindset, iterative build and demo, and incremental progress.
• Collaborate with team members across time zones. 

Required Skills & Qualifications:

• Deep hands‑on expertise with Snowflake (SQL, Snowpark, performance tuning).
• Proven experience building Cortex Agents end‑to‑end.
• Experience with MCP server configuration and custom tool development.
• Solid understanding of LLMs, prompt engineering, and agent design patterns. 

Preferred Skills:

• Strong Python skills, ability to design and build Streamlit apps inside Snowflake.
• Background in data modeling, analytics engineering, or enterprise data architecture.
• Experience with vector search, RAG, and knowledge graph concepts.