Senior Data Engineer (Snowflake + Cortex)

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 environment
• Strong attention to detail and data accuracy