Snowflake Data Engineer

RandomTrees LLC; Hyderabad; On-site; INR 900,000 - 1,500,000; Full time

Job summary

RandomTrees LLC in Hyderabad is seeking a Snowflake Data Engineer to design, develop, and optimize scalable data pipelines using Snowflake, SQL, and Python. The role focuses on data warehousing, ETL/ELT workflows, and cloud-based data platforms.

You'll build and tune queries, implement Snowflake streams/tasks, and work with JSON/XML/Parquet data, ensuring data quality and reliable data solutions for cross-functional teams.

Qualifications

• Hands-on Snowflake experience with production-grade data pipelines.
• Strong SQL skills including complex queries, window functions, joins, CTEs.
• Proficient in Python for data processing and orchestration.
• Experience in designing ETL/ELT pipelines and data ingestion/transformations.
• Solid understanding of data warehousing concepts and cloud data platforms.

Responsibilities

• Design, develop, and maintain Snowflake-based data pipelines.
• 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 (Virtual Warehouses, Databases, Schemas, Stages).
• Implement Snowflake Streams and Tasks for incremental data processing.
• Perform query optimization and performance tuning.
• Work with structured and semi-structured data (JSON, XML, Parquet).
• Ensure data quality checks, validation, and reconciliation.
• Collaborate with cross-functional teams to deliver reliable data solutions.

Skills

Snowflake

Advanced SQL

Python

ETL/ELT

Data warehousing

Data ingestion

Cloud platforms

Education

Bachelor's degree in CS/IT or related

Tools

SnowSQL

dbt

Apache Airflow

Git CI/CD

Job description

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.