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:
o dbt o Informatica o Matillion o Talend o Airflow o 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 setting
- Strong attention to detail and data accuracy
📌 Senior Data Engineer (Snowflake + Cortex) (Bengaluru)
🏢 ZS
📍 Bengaluru