Lead Cortex AI Engineer

Tata Consultancy Services
Owings Mills, Maryland, United StatesFull-time$130,000–$140,000Posted Aug 26, 2026

About the role

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

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.

TCS Employee Benefits Summary

Discretionary Annual Incentive.

Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.

Family Support: Maternal & Parental Leaves.

Insurance Options: Auto & Home Insurance, Identity Theft Protection.

Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement.

Time Off: Vacation, Time Off, Sick Leave & Holidays.

Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refina ncing.

Salary Range: $130,000 - $140,000 a year

Qualifications: BACHELOR OF COMPUTER SCIENCE

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 where custom models are needed
  • Enforce Snowflake Horizon governance patterns including RBAC, data encryption, auditability
  • Ensure trusted AI practices

Qualifications

  • Bachelor of Computer Science
  • 7+ years of hands-on experience on Snowflake AI Data Cloud
  • 3+ years of experience with building LLM-powered applications
  • Strong experience in SQL & Python programming
  • Knowledge of Snowflake hosted LLM model garden is a plus
  • Familiarity with LLM model evaluation methodologies
  • Strong experience working with GIT and CI/CD pipelines
  • Strong working experience in Agile based product development processes

Benefits

  • Discretionary Annual Incentive
  • Comprehensive Medical Coverage
  • Family Support: Maternal & Parental Leaves
  • Insurance Options: Auto & Home Insurance, Identity Theft Protection
  • Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement
  • Time Off: Vacation, Time Off, Sick Leave & Holidays
  • Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing

Skills mentioned

PythonSQLSnowflakeGenerative AILarge Language ModelsAI AgentsRetrieval-Augmented GenerationModel EvaluationGitCI/CD

About Tata Consultancy Services

Tata Consultancy Services (TCS) is the technology partner of choice for industry leading organizations worldwide. Since its inception in 1968, TCS has upheld the highest standards of innovation, engineering excellence, and customer service. It has set an aspiration to become the world's largest AI-led technology services company and is enabling its clients to transform themselves across the full AI stack, from infrastructure to intelligence. Rooted in the heritage of the Tata Group, TCS is focused on creating long term value for its clients, its investors, its employees, and the community at large. With a highly skilled workforce spread across 55 countries and 202 service delivery centers across the world, the company has been recognized as a top employer in six continents. With the ability to rapidly apply and scale new technologies, the company has built long term partnerships with its clients – helping them emerge as perpetually adaptive enterprises. Many of these relationships have endured into decades and navigated every technology cycle, from mainframes in the 1970s to artificial intelligence today. TCS sponsors 14 of the world’s most prestigious marathons and endurance events, including the TCS New York City Marathon, TCS London Marathon and TCS Sydney Marathon with a focus on promoting health, sustainability, and community empowerment. Caution against fraudulent job offers: TCS doesn’t charge any fee throughout the recruitment process. Refer here: https://www.tcs.com/careers/india/recruitment-fraud-alert

IT Services and IT Consulting10,001+ employeesMumbai, Maharashtra