Snowflake AI Engineer – Cortex | Contract

CloudHive is seeking a Snowflake AI Engineer to build AI-powered solutions on the Snowflake platform. The role focuses on developing Cortex applications, semantic models, RAG pipelines, AI agents, evaluation frameworks, and the data foundations needed to put AI into production.

Responsibilities:

• Build AI solutions using Snowflake Cortex, including Cortex Analyst, Cortex Search, Cortex Agents, and AI Functions. Turn business use cases into reliable, production-ready AI applications
• Design and maintain semantic models and Semantic Views that allow business users to query data in natural language. Make sure models are accurate, well-defined, and aligned with business logic
• Develop retrieval-augmented generation (RAG) pipelines using Cortex Search and vector embeddings. Optimize chunking, retrieval, and prompt design to improve answer accuracy
• Build AI agents and integrations that connect Snowflake to other systems and tools, including APIs and MCP-based tooling
• Set up testing and evaluation frameworks to measure AI output accuracy, cost, and performance. Put guardrails in place so outputs are trustworthy and traceable to source data
• Build and maintain the data pipelines and dbt models that power AI use cases, making sure data is clean, structured, and ready for AI applications
• Work closely with data engineers, analysts, and business stakeholders to understand requirements and deliver AI solutions that solve real problems