CloudHive

Compensation

Full Description

Snowflake AI Engineer – Cortex Location: New York City - Hybrid 2 days per week Contract Length: 6 Months Initial Rate: $100-$120 hr About the Role: We’re seeking a skilled Snowflake AI Engineer to help build AI-powered solutions on the Snowflake platform. In this role, you’ll develop applications using Snowflake Cortex, design semantic models, and build the data and AI foundations that let users get answers from their data. Your work will directly shape how the organization puts AI into production on Snowflake. Key Responsibilities: Snowflake Cortex Development • 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. Semantic Modeling • 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. RAG & Retrieval Solutions • Develop retrieval-augmented generation (RAG) pipelines using Cortex Search and vector embeddings. Optimize chunking, retrieval, and prompt design to improve answer accuracy. AI Agents & Integrations • Build AI agents and integrations that connect Snowflake to other systems and tools, including APIs and MCP-based tooling. Evaluation & Quality • 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. Data Foundations • 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. Collaboration & Support • Work closely with data engineers, analysts, and business stakeholders to understand requirements and deliver AI solutions that solve real problems. Required Skills & Experience: • Strong hands-on experience with Snowflake, including SQL and cloud data architecture • Experience building with Snowflake Cortex or other LLM/AI tools • Understanding of RAG, embeddings, and prompt engineering • Python development experience for AI and data workflows • Hands-on experience with dbt • Proficiency with Git/GitHub for version control • Self-starter who can work independently while collaborating effectively with cross-functional teams Nice to Have: • Experience with Cortex Agents, Semantic Views, or Streamlit in Snowflake • Experience building AI agents or MCP tooling • Snowflake certifications, such as SnowPro Core or Advanced