C
Snowflake Cortex AI Engineer
Job Description
Cogniify is building production AI capabilities on the Snowflake AI Data Cloud and is hiring a Snowflake Cortex AI Engineer to help design, deploy, and operationalize end-to-end AI solutions. The work spans semantic modeling, RAG and agentic workflows, and the operational foundations needed to move from PoC to secure production on Snowflake.
Role and scope
You will design and build AI applications directly in Snowflake using Cortex components. You will also model and prepare data with SQL, Python, and Snowpark, then tune performance and cost so solutions can scale to multi-user usage while remaining governed and measurable.
Responsibilities
- Design and build AI applications on Snowflake using Cortex Agents, Cortex Analyst, Cortex Search, Cortex AI Functions (AISQL), Document AI, and Snowflake CoWork (formerly Snowflake Intelligence).
- Develop and refine semantic models and Semantic Views so users can ask questions about structured data in plain English and receive accurate, governed outputs.
- Build agentic workflows and RAG solutions combining structured and unstructured data, including reusable agent tools, skills, and orchestration patterns.
- Prepare and model data in Snowflake with SQL, Python, and Snowpark, tuning for speed and cost.
- Implement evaluation frameworks and observability to measure answer quality, detect errors, and improve releases.
- Tune cost, performance, latency, and concurrency for Cortex workloads to support growth from hundreds to thousands of users.
- Apply security, governance, and responsible AI controls including RBAC, masking, row access policies, guardrails, and audit trails.
- Take solutions from PoC to production with clear architecture, documentation, and clean handoff.
- Run workshops with business teams, translate requirements into technical designs, and present architectures and trade-offs to technical and executive audiences.
- Create reusable accelerators and patterns, support junior team members, and track the fast-moving Snowflake Cortex roadmap.
Requirements
- 3 to 6 years of experience in data engineering, analytics engineering, data architecture, or AI/ML delivery.
- Production experience with Snowflake Cortex, including at least two of: Cortex Agents, Cortex Analyst with Semantic Models or Views, Cortex Search, Cortex AI Functions (including AI_COMPLETE, AI_CLASSIFY, AI_EXTRACT, AI_AGG, AI_EMBED), or Snowflake CoWork (Snowflake Intelligence).
- Strong foundation in RAG, embeddings, text-to-SQL, prompt engineering, and evaluation and observability practices.
- Strong SQL and Python skills.
- Hands-on Snowflake experience with data modeling, performance tuning, Snowpark, and security and governance.
- Experience delivering data or AI projects with business stakeholders, from requirements through production.
- Clear communication with both business and technical teams.
- BS in Computer Science, Engineering, or a related field, or equivalent practical experience.
- Authorization to work in the United States.
- SnowPro Core or Advanced certification is a plus.
- Experience building or scaling production agentic AI systems, including evaluations, guardrails, cost and latency tuning, and multi-user concurrency, is a plus.
- Hands-on work with Streamlit in Snowflake, Snowflake Native Apps, or external agent frameworks is a plus.
- Experience in industries common in Los Angeles (media and entertainment, retail, healthcare, financial services, or manufacturing) is a plus.
- End-to-end ownership of Snowflake and AI projects, from design to production, is a plus.
Location and compensation
- Location: Los Angeles, CA (onsite)
- Salary: USD 130,500 - 139,200 per year
- Work location: In person
- Pay: $130,500.00 - $139,200.00 per year
Benefits
- Unlimited PTO
- Generous parental leave, well above industry standards
- Medical, dental, and vision coverage for employees
- Disability and life insurance
- Mental health and wellbeing support
- Annual bonus program
- Employee Stock Purchase Plan (ESPP)
- Yearly team-building experiences
- Mentorship and sponsorship opportunities
- Manager resources and support
- Small teams where your work makes a real difference
- Open communication with management and company leadership
- An entrepreneurial culture where taking initiative is part of everyday work
- Health insurance