Data Engineer, Cortex & Agentic AI
Summary
A 6-month contract (hybrid in Pune) to architect and build Agentic AI and GenAI use-cases on Snowflake Cortex, embedding LLM capabilities into core data workflows. Day to day involves building Snowpark/Python-SQL data pipelines, data modeling, and optimizing LLM, compute cost, and query performance.
Data Engineer, Cortex & Agentic AI
Contract Role – Product Company Location Engagement Pune (Hybrid)
Availability Contract – 6 months, with potential conversion to full-time based on performance and location fit Immediate joiners / short notice preferred Role Overview We are looking for an experienced Data Engineer to architect and build advanced Agentic AI use-cases on Snowflake, embedding GenAI capabilities directly into core data workflows. This is a hands-on role for someone who combines deep Snowflake platform expertise with strong Python/SQL engineering skills and a solid grasp of LLM cost and performance optimization. Requirements
• 4+ years of Data Engineering experience, with a proven track record of building complex, high-performance Analytics and AI-driven systems in production environments
• Deep Snowflake expertise: extensive, hands-on professional experience with Snowflake, including advanced data modeling, schema design, and native Snowflake features
• Snowflake Cortex & GenAI: demonstrable experience leveraging Snowflake Cortex AI to build scalable GenAI and Agentic use-cases directly within the data platform
• Expert-level proficiency in Python and SQL, with strong foundational knowledge in data structures, algorithms, and software engineering best practices
• LLM cost & performance optimization: deep understanding of performance tuning and cost optimization tailored for LLMs, vector searches, and Agentic systems running within cloud data platforms
• Familiarity with modern cloud platforms (AWS/GCP/Azure) and their integration with Snowflake data infrastructure
• Solid understanding of production system operations, including observability, data quality monitoring, reliability, and Snowflake security/RBAC
• Bachelor’s degree in Computer Science, Engineering, or a related field (or equivalent practical experience)
• Strong verbal and written communication skills, with the ability to translate complex AI/data concepts to business stakeholders efficiently Responsibilities
• Architect and implement advanced Agentic use-cases leveraging Snowflake Cortex, embedding LLM capabilities (summarization, anomaly detection, automated insights) directly into core data workflows
• Design, build, and deploy highly scalable data pipelines natively within Snowflake using Snowpark and Python/SQL stored procedures
• Rigorously monitor, troubleshoot, and optimize Snowflake compute costs and query performance, with a focus on execution efficiency of LLMs and Agentic functions
• Apply expert-level data modeling practices to design clean, scalable, and secure data schemas supporting both traditional analytics and complex AI/ML workloads
• Operate effectively in a fast-paced contract environment, owning end-to-end technical delivery from architecture to deployment and hitting the ground running on immediate business challenges
• Maintain high engineering standards by writing clear technical design documents, conducting thorough code reviews, and implementing CI/CD best practices for Snowflake artifacts