Haystack
← Back to Jobs
Technology
TC

Lead Cortex AI Engineer

TATA Consultancy Services LimitedOwings Mills, MD🇺🇸United StatesPosted Sep 16, 2026

Quick Overview

Seniority
Mid Senior
Work mode
On Site
Location
Owings Mills, MD, United States
Posted
Yesterday
SQLEncryptionSnowflakeAgileGitLLMPython

Job Description

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.) 

Similar jobs