Lead Cortex AI Engineer

SFE; Mills (AR); On-site; USD 90,000 - 130,000; Full time

Job summary

SFE in Mills, Arkansas is seeking an experienced Cortex AI/Cortex Analyst developer to design and deploy LLM-powered apps on Snowflake AI Data Cloud. You will build agentic workflows, implement RAG pipelines, and optimize AI pipelines for latency and cost.

The role requires hands-on SQL and Python, experience with Snowpark and CI/CD, and capability to lead a small onsite/offshore team while collaborating with Data Engineering, Security, and Compliance stakeholders.

Qualifications

• 7+ Hands on experience on Snowflake AI Data Cloud.
• 3+ years of proven experience with building LLM-powered applications including agentic workflows with measurable impacts.
• Strong hands-on experience with Cortex AI services: Analyst, Search, AI SQL, Vector Embedding etc.
• Experience in developing scalable data centric applications using Snowpark containers in Python.
• Hands-on experience in creating conversational agentic apps using natural language prompts in Snowflake Intelligence.
• 5+ years of experience in SQL & Python programming.
• Knowledge of Snowlflake hosted LLM model garden (Claude, Llama, OpenAI, Mistral, Arctic etc) will be a plus.
• Familiarity with LLM model evaluation methodologies.
• Working experience in Snowflake managed / custom MCP servers.
• Strong experience working with GIT and CI/CD pipelines.
• Strong working experience in Agile based product development processes.
• Good written and verbal communication skills. Analytical and problem-solving skills.

Responsibilities

• Design and implement LLM powered apps in Snowflake using its Cortex AI capabilities.
• Build Cortex Analyst solutions on SQL based semantic models / views through natural language prompts.
• Implement RAG workflows using Cortex search over unstructured documents and texts.
• Design AISQ: pipelines to analyze multimodal data natively in SQL.
• Create Agentic AI orchestration frameworks In Snowflake Intelligence.
• Integrate Snowflake ML assets (Model Registry, Feature Store, Notebooks, Snowpark etc) where custom models are needed.
• Enforce Snowflake Horizon governance patterns including RBAC, data encryption, auditability across internal and external data sources.
• Ensure trusted AI practices (e.g. model safety & filtering).
• Optimize AI pipelines through right sizing of serverless compute, efficient application design, meeting desired latency.
• Establish observability for Cortex AI services for application monitoring and cost management.
• Manage the new requirements, create design artifacts, develop codebase, CI / CD pipelines.
• Lead a team of small to medium capacity in an onsite-offshore model.
• Collaborate with cross-functional stakeholders such as Data Engineering, Architecture, Operations, Security/ Risk & Compliance etc.)

Skills

Snowflake AI Data Cloud

Cortex AI services

Snowpark containers in Python

LLM-powered applications

Git and CI/CD

Agile product development

Tools

Snowpark

Python

SQL

Vector Embedding

Git

CI/CD

Job description

Snowflake AI Data Cloud, Cortex AI, Cortex Analyst, Cortex Search, Cortex AI SQL, Snowpark, LLM, Agentic Apps

• 7+ Hands on experience on Snowflake AI Data Cloud.
• 3+ years of proven experience with building LLM-powered applications including agentic workflows with measurable impacts.
• Strong hands-on experience with Cortex AI services: Analyst, Search, AI SQL, Vector Embedding etc.
• Experience in developing scalable data centric applications using Snowpark containers in Python.

Must Have Technical/Functional Skills:

• 7+ Hands on experience on Snowflake AI Data Cloud.
• 3+ years of proven experience with building LLM-powered applications including agentic workflows with measurable impacts.
• Strong hands-on experience with Cortex AI services: Analyst, Search, AI SQL, Vector Embedding etc.
• Experience in developing scalable data centric applications using Snowpark containers in Python.
• Hands-on experience in creating conversational agentic apps using natural language prompts in Snowflake Intelligence.
• 5+ years of experience in SQL & Python programming.
• Knowledge of Snowlflake hosted LLM model garden (Claude, Llama, OpenAI, Mistral, Arctic etc) will be a plus.
• Familiarity with LLM model evaluation methodologies.
• Working experience in Snowflake managed / custom MCP servers.
• Strong experience working with GIT and CI/CD pipelines.
• Strong working experience in Agile based product development processes.
• Good written and verbal communication skills. Analytical and problem-solving skills.

Roles & Responsibilities:

• Design and implement LLM powered apps in Snowflake using its Cortex AI capabilities.
• Build Cortex Analyst solutions on SQL based semantic models / views through natural language prompts.
• Implement RAG workflows using Cortex search over unstructured documents and texts.
• Design AISQ: pipelines to analyze multimodal data natively in SQL.
• Create Agentic AI orchestration frameworks In Snowflake Intelligence.
• Integrate Snowflake ML assets (Model Registry, Feature Store, Notebooks, Snowpark etc) where custom models are needed.
• Enforce Snowflake Horizon governance patterns including RBAC, data encryption, auditability across internal and external data sources.
• Ensure trusted AI practices (e.g. model safety & filtering).
• Optimize AI pipelines through right sizing of serverless compute, efficient application design, meeting desired latency.
• Establish observability for Cortex AI services for application monitoring and cost management.
• Manage the new requirements, create design artifacts, develop codebase, CI / CD pipelines.
• Lead a team of small to medium capacity in an onsite-offshore model.
• Collaborate with cross-functional stakeholders such as Data Engineering, Architecture, Operations, Security/ Risk & Compliance etc.)

Generic Managerial Skills, If any:

• Strong experience leading an AI development team of small to medium capacity in onsite offshore model.
• Strong experience in customer-facing engagement, communication, stakeholder management.