Engineer 5+ Hands on experience on Snowflake AI Data Cloud. 2+ 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. 3+ 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.)