Snowflake Data Engineer_6+ years

Zorba AI; Chennai District; On-site; INR 2,500,000 - 4,200,000; Full time

Job summary

Zorba AI is seeking an experienced Snowflake Data Engineer in Chennai to design scalable data pipelines and data models. You will optimize Snowflake workloads, ensure data quality, and integrate with cloud platforms and analytics tools.

Responsibilities include building ETL/ELT pipelines, developing star and snowflake schemas, implementing DBT transformations, and collaborating with data scientists, analysts, and stakeholders. Strong scripting (Python/Shell) and cloud experience are required.

Qualifications

• Strong hands-on experience with Snowflake.
• Advanced SQL skills.
• DBT / Data Build Tool experience.
• Understanding of Data Warehousing and dimensional modeling.
• Experience designing Fact and Dimension tables.
• Proficiency in Python or Shell scripting.
• Experience with AWS or Azure Snowflake integration.
• Knowledge of Snowflake performance tuning and data governance.

Responsibilities

• Design and develop scalable ETL/ELT pipelines for Snowflake.
• Develop conceptual, logical, and physical data models.
• Build fact and dimension tables and star/snowflake schemas.
• Create and maintain DBT transformations.
• Write optimized SQL for transformation, reporting, and analytics.
• Tune Snowflake performance and manage warehouses.
• Integrate Snowflake with AWS/Azure and BI tools.
• Develop automation using Python or shell scripts.
• Ensure data quality through validation and monitoring.
• Troubleshoot pipeline and performance issues.
• Collaborate with stakeholders and maintain technical docs.

Skills

Snowflake

Advanced SQL

DBT

Data Modeling

Python/Shell scripting

AWS

Azure

Data Warehousing

Tools

Tableau

Looker

Job description

We are looking for an experienced Snowflake Data Engineer with strong expertise in Snowflake, Advanced SQL, DBT, Data Modeling, and Python/Shell scripting. The candidate will be responsible for designing scalable data pipelines, developing data models, optimizing Snowflake workloads, ensuring data quality, and integrating Snowflake with cloud platforms and analytics tools.

Key Responsibilities

• Design and develop scalable ETL/ELT data pipelines for ingesting, transforming, and loading data into Snowflake.
• Design conceptual, logical, and physical data models based on business requirements.
• Develop fact and dimension tables, Star Schema, Snowflake Schema, and other dimensional models.
• Develop and maintain transformation workflows using DBT (Data Build Tool).
• Write complex and optimized SQL queries for data transformation, reporting, and analytics.
• Perform Snowflake performance tuning using clustering, query optimization, caching, warehouse sizing, and resource monitoring.
• Integrate Snowflake with AWS/Azure cloud services, storage platforms, APIs, and external data sources.
• Develop automation using Python, Shell scripting, or similar scripting languages.
• Implement data validation, cleansing, monitoring, and reconciliation processes to ensure data quality.
• Troubleshoot data pipeline failures, query performance issues, and integration problems.
• Integrate Snowflake with BI tools such as Tableau, Power BI, and Looker.
• Implement Snowflake security and governance practices including RBAC, data masking, encryption, and access controls.
• Collaborate with data scientists, analysts, developers, and business stakeholders to deliver data solutions.
• Maintain technical documentation covering data models, pipelines, processes, and best practices.
• Participate in CI/CD and DevOps practices for data engineering workflows.
• Stay updated with new Snowflake features and modern data engineering technologies.

Mandatory Skills

• Strong hands-on experience with Snowflake
• Strong Advanced SQL skills
• Hands-on experience with DBT / Data Build Tool
• Strong understanding of Data Warehousing and Dimensional Modeling
• Experience with Star Schema / Snowflake Schema
• Experience designing Fact and Dimension tables
• Proficiency in Python, Shell scripting, or similar
• Experience with AWS or Azure and Snowflake integration
• Strong knowledge of Snowflake performance tuning and optimization
• Good understanding of data quality, security, and governance

Good to Have

• SnowPro Core / SnowPro Advanced certification
• Kafka or Spark Streaming experience
• Snowflake integration with ML/AI platforms
• Snowflake cost optimization and workload management
• CI/CD and DevOps experience
• Advanced security features such as data masking and row-level security
• Experience with Tableau, Power BI, or Looker
• Experience mentoring junior engineers

Required Competencies

• Strong analytical and problem-solving skills
• Good communication skills
• Ability to troubleshoot complex data and pipeline issues
• Ability to work effectively with technical and business stakeholders
• Strong ownership and collaboration skills
• Ability to document and explain technical solutions clearly

Ideal Candidate Profile

6-8 years of relevant experience with strong hands-on expertise in:

• Snowflake + DBT + Advanced SQL + Dimensional Data Modeling + Python/Shell + AWS/Azure

Candidates should have demonstrated experience designing production-grade data pipelines and data models in Snowflake, along with hands-on performance optimization and data engineering best practices.

Skills: shell scripting,data models,dbt,snowflake,python