Role Overview
We are seeking a highly skilled and motivated Snowflake Data & AI Engineer to join our data and analytics team. The ideal candidate will be responsible for designing, developing, optimizing, and maintaining scalable data pipelines, cloud-based data warehouse solutions, and AI-enabled data products using Snowflake. You will work closely with architects, analysts, business stakeholders, and cross-functional engineering teams to enable data-driven decision-making across the organization, including solutions powered by Snowflake Cortex AI, semantic views, and agentic analytics patterns.
Key Responsibilities
Design, build, and maintain scalable ETL/ELT pipelines using Snowflake and cloud-native technologies.
Develop and optimize Snowflake data warehouse structures, including schemas, tables, views, tasks, streams, stored procedures, and semantic views.
Build AI-assisted analytics and data products using Snowflake Cortex capabilities, including LLM functions, Cortex Analyst, Cortex Search, and semantic models.
Design and operationalize semantic layers / semantic views that enable governed natural-language querying and business-friendly analytics.
Support development of CoCo / CoWork-style agentic workflows, where AI agents assist users with data discovery, analysis, insight generation, and workflow automation.
Integrate structured and unstructured data into Snowflake to support RAG, enterprise search, knowledge retrieval, and AI-driven analytics use cases.
Collaborate with architects and business stakeholders to convert business questions into Cortex-powered analytical experiences.
Integrate data from multiple structured and unstructured sources into Snowflake.
Implement data transformation logic using SQL, Python, dbt, or other ETL tools.
Monitor and optimize query performance, storage usage, and compute costs within Snowflake.
Collaborate with business analysts, data scientists, and stakeholders to understand data requirements and deliver high-quality datasets, semantic layers, and AI-ready data assets.
Ensure that data quality, governance, security, and compliance standards are maintained.
- Automate deployment and data workflows using CI/CD and orchestration tools.
- Troubleshoot and resolve data pipeline, semantic model, and AI solution performance issues.
- Document data models, semantic views, workflows, and technical specifications.
Required Skills
Hands-on experience with Snowflake Cloud Data Platform.
Strong proficiency in SQL and performance tuning.
Hands-on experience with Snowflake Cortex AI, including Cortex LLM functions, Cortex Analyst, Cortex Search, and AI/ML capabilities within Snowflake.
Experience designing semantic models, semantic views, or governed data layers for natural-language analytics.
Practical understanding of CoCo / CoWork-style agentic AI workflows, including agent orchestration, tool usage, retrieval patterns, and human-in-the-loop business processes.
Experience building RAG-based solutions using Snowflake or similar cloud data platforms.
Ability to translate business use cases into AI-enabled analytics solutions using Snowflake-native capabilities.
Experience building ETL/ELT pipelines using tools such as: dbt
Informatica
Matillion
Talend
Airflow
Azure Data Factory (ADF)
Experience with cloud platforms such as AWS, Azure, or GCP.
Strong understanding of data warehousing concepts, dimensional modeling, data architecture, and AI-ready semantic modeling.
Experience scripting/programming in Python.
Strong analytical and problem-solving skills.
Ownership & Problem-Solving Expectations
Excellent communication and stakeholder management skills
Strong collaboration and teamwork mindset
Ability to work independently in a fast-paced environment
Strong attention to detail and data accuracy
Pay: ₹90,000.00 - ₹120,000.00 per month
Benefits:
Work Location: In person
