Lead Cortex AI Engineer

KPG99 INC
Owings Mills, Maryland, United StatesFull-timePosted Sep 16, 2026

About the role

Role: Lead Cortex AI Engineer

Onsite at Owings Mills, MD

Full Time Direct Hire 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.

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.

Desired Candidate Profile

Qualifications : BACHELOR OF COMPUTER SCIENCE

Thanks & Regards,

Vaishnav Gupta| Senior Technical Recruiter

KPG99, INC | www.kpgtech.com | MBE Certified Firm

3240 E State, St Ext | Hamilton, NJ 08619

Vaishnav.gupta@kpgtech.com

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

Benefits

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

Skills mentioned

PythonSQLSnowflakeGenerative AILarge Language ModelsRetrieval-Augmented GenerationAI AgentsEmbeddingsGitCI/CD

About KPG99 INC

Our business consulting services are led by significant domain depth built on a robust technology-driven services platform. We offerBusiness and Technology Consulting, Application andProduct Development, Support, Quality Assurance, Migration and Re-engineering, Business Process Outsourcing and Staff Augmentation & Recruiting Services. Our operational model is to partner with our clients to support, complement, augment and enhance existing capabilities within their organizations. We create a seamless and virtual extension which engages on demand, ramping up or down as needed. Using this model we are able to bring in new expertise and skills or augment resources in a fast and efficient manner. Being a local US company with robust offshore capability, we can bring to bear highly skilled domain experts as well as a high-quality, process-driven, offshore delivery model that is scalable, flexible and cost-effective which helps reduce the time-to-market. In KPG 99, all services are governed by our Quality Model. All processes, methodologies, tools and techniques are structured to follow ISO 9001 and SEI-CMM guidelines. As part of continuous process improvement, we are always refining and adding to our processes and not only do we share best practices with our clients but always look to learn from our clients.

IT Services and IT Consulting51-200 employeesHamilton, NJ

H-1B sponsorship history

Historical employer filing data was found for KPG99 INC. The employer record includes 14 historical certified applications. This is employer-level history, not a guarantee that this role currently offers sponsorship.