Snowflake Data Engineer

About this job

Snowflake Data Engineer SQL & Python

Experience: 3–9 Years Role: Snowflake Data Engineer

Job Description

We are looking for experienced Snowflake Data Engineers with strong hands-on expertise in Snowflake, Advanced SQL, and Python to design, develop, and optimize scalable data engineering solutions.

The ideal candidate should have experience in data warehousing, ETL/ELT pipelines, data transformation, data ingestion, and cloud-based data platforms.

Key Responsibilities

• Design, develop, and maintain data pipelines using Snowflake.
• Write complex SQL queries, stored procedures, views, and functions.
• Develop Python scripts for data processing, automation, and integration.
• Build and optimize ETL/ELT workflows for large-scale data processing.
• Work with Snowflake architecture, including Virtual Warehouses, Databases, Schemas, and Stages.
• Implement Snowflake Streams and Tasks for incremental data processing.
• Perform query optimization and performance tuning.
• Work with structured and semi-structured data such as JSON, XML, and Parquet.
• Implement data quality checks, validation, and reconciliation.
• Collaborate with cross-functional teams to deliver reliable data solutions.

Mandatory Skills

• Strong hands-on experience in Snowflake.
• Advanced SQL – complex queries, joins, CTEs, window functions, and query optimization.
• Python programming and scripting.
• Experience in ETL/ELT development and data pipeline creation.
• Good understanding of Data Warehousing concepts.
• Experience in data ingestion, transformation, and integration.
• Knowledge of Snowflake architecture and performance tuning.

Good-to-Have Skills

• Snowflake Streams and Tasks.
• Snowflake Stored Procedures and SnowSQL.
• AWS / Azure / GCP.
• PySpark.
• dbt.
• Apache Airflow.
• Git and CI/CD.
• Snowflake SnowPro Certification.