Snowflake Data Engineer_6+ years

Zorba AI; Maharashtra; On-site; INR 1,500,000 - 2,300,000; Full time

Job summary

Zorba AI is seeking an experienced Snowflake Data Engineer based in Maharashtra to design scalable data pipelines, data models, and Snowflake optimizations. You will implement data quality controls, integrate with cloud services, and collaborate with analysts and data scientists to deliver robust data solutions.

The role requires hands-on Snowflake experience, advanced SQL, DBT expertise, and strong scripting skills. On-site collaboration with cross-functional teams is expected.

Qualifications

• Hands-on Snowflake implementation and maintenance.
• Expertise in advanced SQL for complex transformations.
• Experience with DBT for data transformations.
• Strong knowledge of data warehousing and dimensional modeling.
• Experience designing star/snowflake schemas.
• Proficient in Python or shell scripting for data automation.
• Experience integrating Snowflake with AWS/Azure cloud services.
• Ability to optimize Snowflake performance and costs.
• Understanding data quality, security, and governance.

Responsibilities

• Design and build scalable ETL/ELT pipelines for Snowflake.
• Create conceptual, logical, and physical data models.
• Develop fact and dimension tables and dimensional schemas.
• Build and maintain DBT workflows for transformations.
• Write optimized SQL for data transformation and analytics.
• Tune Snowflake performance via clustering, caching, and sizing.
• Integrate Snowflake with cloud services and BI tools.
• Automate workflows using Python or shell scripts.
• Implement data quality, monitoring, and reconciliation processes.
• Troubleshoot pipeline or query issues and optimize integration.
• Collaborate with stakeholders to deliver data solutions.
• Maintain documentation on models, pipelines, and best practices.
• Participate in CI/CD and DevOps for data workflows.

Skills

Snowflake

Advanced SQL

DBT / Data Build Tool

Python

Shell scripting

Data Modeling

Dimensional Modeling

Data Warehousing

AWS / Azure integration

Performance tuning

Data quality & governance

CI/CD & DevOps

Tools

Tableau

Power BI

Looker

AWS

Azure

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