Lead Cortex AI Engineer

Siri InfoSolutions Inc; Mills (AR); On-site; USD 100,000 - 150,000; Full time

Job summary

Siri InfoSolutions Inc. is seeking an experienced AI Platform Engineer to design and implement LLM-powered apps within Snowflake, leveraging Cortex AI services and SQL-based models. You will build agentic workflows, RAG pipelines, and scalable data-centric solutions using Snowpark containers in Python.

You will lead architecture discussions, collaborate across Data Engineering and Security, and ensure governance, safety, and observability across AI pipelines in a dynamic onsite/offshore setup.

Qualifications

• 7+ Hands on experience on Snowflake AI Data Cloud.
• 3+ years of proven experience with building LLM-powered applications including agentic workflows.
• Strong hands-on experience with Cortex AI services: Analyst, Search, AI SQL, Vector Embedding.
• 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 will be a plus.
• Familiarity with LLM model evaluation methodologies.
• Strong experience with Git and CI/CD pipelines.
• Strong Agile-based product development practices.

Responsibilities

• Design and implement LLM powered apps in Snowflake using Cortex AI capabilities.
• Build Cortex Analyst solutions on SQL-based semantic models via natural language prompts.
• Implement RAG workflows using Cortex search over unstructured documents.
• Design AISQ pipelines to analyze multimodal data natively in SQL.
• Create Agentic AI orchestration frameworks In Snowflake Intelligence.
• Integrate Snowflake ML assets where custom models are needed.
• Enforce Snowflake Horizon governance patterns including RBAC and data encryption.
• Ensure trusted AI practices and model safety.
• Optimize AI pipelines for latency and cost management.
• Establish observability for Cortex AI services and maintain documentation.

Skills

Snowflake AI Data Cloud

LLM-powered apps

Cortex AI services

Python programming

SQL

Git & CI/CD

Agile development

Communication skills

Tools

Snowpark

Notebooks

Model Registry

Feature Store

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.