ZecData Technology

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:

• Provident Fund

Work Location: In person