Snowflake Data Engineer_6+ years

Zorba AI; Hyderabad; On-site; INR 1,800,000 - 2,400,000; Full time

Job summary

Zorba AI in Hyderabad is seeking an experienced Snowflake Data Engineer to design scalable data pipelines, develop data models, and optimize Snowflake workloads.

You will integrate with cloud services, write advanced SQL, and implement data quality, governance, and security while collaborating with data scientists and analysts.

Qualifications

• 6-8+ years of hands-on Snowflake, DBT, and SQL experience.
• Experience with AWS/Azure integration and data warehousing concepts.
• Knowledge of data quality, security, and governance.

Responsibilities

• Design scalable ETL/ELT pipelines into Snowflake.
• Develop and optimize data models including star schema.
• Build and maintain DBT transformations.
• Write complex SQL for data transformation and analytics.
• Tune Snowflake performance and manage warehouses.
• Integrate Snowflake with AWS/Azure cloud services.
• Implement data quality, validation, and monitoring.
• Collaborate with data scientists and analysts.
• Document models, pipelines, and best practices.

Skills

Snowflake

Advanced SQL

DBT

Dimensional Modeling

Data Warehousing

Star Schema

Python

Shell scripting

AWS/Azure

Performance tuning

Data governance

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