Snowflake Data Engineer

Randomtrees; Bengaluru; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Randomtrees in Bengaluru, India, is seeking a data engineer to design and maintain end-to-end data pipelines into Snowflake. You will optimize ELT/ETL processes using Snowflake SQL, Snowpipe, Streams & Tasks, and cloud-native orchestration tools to meet analytics needs.

The role requires strong SQL and Python for data transformations, plus experience building scalable data models across multiple layers for analytics and reporting. Collaborative, results-driven candidates are encouraged to apply.

Qualifications

• Experience designing and maintaining end-to-end data pipelines in Snowflake.
• Strong SQL and Python development for data transformations and analytics.
• Proficiency with Snowpipe, Streams & Tasks, and cloud-native orchestration tools.

Responsibilities

• Design, build, and maintain end-to-end data pipelines ingesting data from files, streams, APIs, and databases into Snowflake.
• Develop ELT/ETL pipelines using Snowflake SQL, Snowpipe, Streams & Tasks; optimize performance and cost.
• Implement scalable data models with staging, curated, and consumption layers to support analytics.

Skills

Snowflake SQL

Snowpipe

Streams & Tasks

Cloud orchestration

Python

SQL

Tools

Snowflake

Snowpipe

Cloud storage

Job description

Role & responsibilities

Design, build, and maintain end-to-end data pipelines to ingest, process, and transform data from files, streams, APIs, and relational/non-relational databases into Snowflake. Develop and optimize ELT/ETL pipelines using Snowflake SQL, Snowpipe, Streams & Tasks, and cloud-native orchestration tools. Implement scalable data models and schemas (staging, curated, and consumption layers) to support analytics and reporting use cases. Develop transformations and business logic using SQL and Python, including Snowflake UDFs and stored procedures. Optimize Snowflake performance and cost through query tuning, warehouse sizing, clustering, and resource management. Integrate Snowflake with cloud storage and services across AWS and Azure (e.g., object storage, data integration, and mess)

Preferred candidate profile

Snowflake SQL, Snowpipe, Streams & Tasks, and cloud-native orchestration tools

Perks and benefits