Job Specifications
Must Have Technical/Functional Skills
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.)
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 Refinancing.
Salary Range: $130,000 - $140,000 a year
About the Company
NuStar Technolgies is a full service IT consulting company founded in 2013, specializing in IT Training, Staffing and Consulting. NuStar helps companies achieve business objectives by combining top-tier talent with proven processes and leading technology. Our commitment to our customers is reflected throughout our approach. We are intensely selective in our hiring practices and our customer focus is reflected in all areas of our organization. We support our customers and partners with highly experienced and Certified Profess...
Know more