Snowflake Data Engineer

Anblicks; Hyderabad; On-site; INR 1,800,000 - 3,000,000; Full time

Job summary

Anblicks in Hyderabad seeks an experienced Snowflake Data Engineer with 7+ years in data engineering, data warehousing, and ETL/ELT development. The role focuses on designing, developing, and optimizing scalable data pipelines and Snowflake-based data warehouses using Python/PySpark, SQL, and DBT.

You will build robust ETL/ELT processes, implement data quality checks, and collaborate with stakeholders to translate data requirements into efficient solutions.

Qualifications

• 7+ years of experience in Data Engineering or similar role.
• Hands-on Snowflake expertise.
• Strong SQL with complex queries and performance tuning.
• Proficiency in Python and PySpark.
• Experience with DBT and data warehousing concepts.
• Knowledge of ETL/ELT principles and data modeling.

Responsibilities

• Design, develop, and maintain scalable data pipelines using Snowflake, Python/PySpark, SQL, and DBT.
• Develop and optimize complex SQL queries, stored procedures, views, and data transformation logic.
• Build robust ETL/ELT pipelines for ingesting and transforming data from multiple sources into Snowflake.
• Develop data transformation models using DBT, including staging, intermediate, and analytical models.
• Implement data quality checks, validation, reconciliation, and monitoring processes.
• Optimize Snowflake queries, warehouse utilization, storage, and overall data-processing performance.
• Develop PySpark/Python scripts for large-scale data processing and transformation.
• Work with structured and semi-structured data such as JSON, XML, and CSV within Snowflake.
• Implement incremental data loads and efficiently handle large data volumes.
• Follow best practices for data modeling, including fact/dimension tables, star schema, and dimensional modeling.
• Collaborate with data architects, analysts, developers, and business stakeholders to understand data requirements.
• Troubleshoot data pipeline failures, performance issues, and data inconsistencies.
• Participate in code reviews and ensure development follows engineering and data governance standards.
• Maintain technical documentation related to data pipelines, transformations, and data models.

Skills

Data engineering

ETL/ELT

SQL proficiency

Problem solving

Analytical skills

Data modeling

Tools

Snowflake

Python

PySpark

DBT

SQL

Job description

We are looking for an experienced Snowflake Data Engineer with 7+ years of experience in data engineering, data warehousing, and ETL/ELT development. The ideal candidate should have strong hands‑on expertise in Snowflake, Python/PySpark, SQL, and DBT and be capable of designing, developing, and optimizing scalable data pipelines and data warehouse solutions.

Key Responsibilities

• Design, develop, and maintain scalable data pipelines using Snowflake, Python/PySpark, SQL, and DBT.
• Develop and optimize complex SQL queries, stored procedures, views, and data transformation logic.
• Build robust ETL/ELT pipelines for ingesting and transforming data from multiple sources into Snowflake.
• Develop data transformation models using DBT (Data Build Tool), including staging, intermediate, and analytical models.
• Implement data quality checks, validation, reconciliation, and monitoring processes.
• Optimize Snowflake queries, warehouse utilization, storage, and overall data-processing performance.
• Develop PySpark/Python scripts for large-scale data processing and transformation.
• Work with structured and semi-structured data such as JSON, XML, and CSV within Snowflake.
• Implement incremental data loads and efficiently handle large data volumes.
• Follow best practices for data modeling, including fact/dimension tables, star schema, and dimensional modeling.
• Collaborate with data architects, analysts, developers, and business stakeholders to understand data requirements.
• Troubleshoot data pipeline failures, performance issues, and data inconsistencies.
• Participate in code reviews and ensure development follows engineering and data governance standards.
• Maintain technical documentation related to data pipelines, transformations, and data models.

Required Skills

• 7+ years of experience in Data Engineering or a similar role.
• Strong hands‑on experience with Snowflake.
• Strong proficiency in SQL, including complex queries, CTEs, window functions, joins, and query optimization.
• Strong programming experience in Python and/or PySpark.
• Hands‑on experience with DBT (Data Build Tool) and DBT-based data transformation.
• Strong understanding of ETL/ELT concepts and data pipeline architecture.
• Experience with data warehouse concepts and dimensional data modeling.
• Experience working with large datasets and optimizing data processing workloads.
• Good understanding of data quality, validation, and reconciliation techniques.
• Strong problem‑solving and analytical skills.