Snowflake Cortex analyst

Tata Consultancy Services; Pune District, Chennai District, Bengaluru; Remote; INR 1,200,000 - 1,800,000; Full time

Job summary

Tata Consultancy Services is seeking a Snowflake Cortex analyst to design and optimize data models and pipelines using Snowflake, DBT, and Cortex. The role requires 5-8 years of data engineering experience and strong SQL skills. You will work with agile analytics teams in a Pan India setup to deliver scalable analytics solutions.

Join a fast-paced environment focusing on data modeling, AI features, and efficient ETL workflows, with opportunities to influence architecture and best practices.

Qualifications

• 5-8 years of experience in data engineering.
• Hands-on Snowflake and DBT expertise.
• Familiar with Snowflake Cortex AI features is a plus.

Responsibilities

• Design, build, and optimize data models and pipelines in Snowflake.
• Develop DBT-based data transformation workflows.
• Integrate AI/ML features using Snowflake Cortex AI.
• Apply dimensional modeling and star schema best practices.
• Collaborate to design scalable, maintainable transformation logic.
• Optimize query and storage performance in Snowflake.
• Write DBT tests and document transformation code.
• Work in an agile analytics team with strong communication.

Skills

SQL

Data warehousing concepts

Agile development

Communication

Problem-solving

Tools

Snowflake

DBT

Snowflake Cortex AI

Git

CI/CD

Job description

Virtual drive is on 19th sep 2026

Role: Snowflake Cortex analyst

Experience: 5-8 yrs

Location: Pan India

Responsibility:

• Design, build, and optimize data models and pipelines within Snowflake.
• Develop and maintain data transformation workflows using DBT (data build tool).
• Build and integrate AI/ML features using Snowflake Cortex AI capabilities.
• Implement best practices for data modeling (e.g., star schema, dimensional modeling) within Snowflake.
• Collaborate with the development team to design scalable, maintainable data transformation logic.
• Optimize query and pipeline performance, and manage Snowflake compute/storage efficiently.
• Write and maintain DBT tests, documentation, and version-controlled transformation code.
• 5-8 years of experience in data engineering, with strong hands-on expertise in Snowflake and DBT.
• Experience with or strong interest in Snowflake Cortex AI features for applied AI use cases.
• Strong SQL skills and understanding of data warehousing/dimensional modeling concepts.
• Familiarity with version control (Git) and CI/CD for analytics engineering.
• Strong problem-solving skills and ability to work in an agile development team.
• Good communication and collaboration skills.