Data Engineer

Skill Name: Snowflake Developer with Python & Data warehousing and Mandate Certification (Snowpro Advanced Architecture or Snowpro Advanced Administrator)

Experience: 5 to 10 Years

Mandate Skills: Snowflake + Python + Data warehousing + Certification (Snowpro Advance Architecture or Snowpro Advanced Administrator)

Location: Preferably Hyderabad or Pune/Bangalore)

NP: Immediate/Early Joiners only (Max 15 to 20 Days)

JD:

Looking for a skilled Data Engineer with hands-on experience in Snowflake, Python, and Snowpark to join data platform team.

The ideal candidate will work on developing scalable data pipelines, optimizing data flows, managing semi-structured data, and building internal tools using Streamlit within Snowflake. A strong understanding of data modeling and SQL is essential.

Key Responsibilities:

Design and develop Python-based stored procedures using Snowpark for data ingestion, transformation, and automation tasks.

Work with metadata-driven frameworks to dynamically create or recreate data tables and manage ETL flows.

Build internal apps and tools using Streamlit in Snowflake to enable self-service and improve data accessibility.

Work extensively with semi-structured data (e.g., JSON in VARIANT columns), including flattening, transformation, and enrichment.

Write complex SQL queries involving CTEs, joins, window functions like ROW_NUMBER(), and performance tuning.

Contribute to data modeling activities including star/snowflake schema designs, fact/dimension tables, and data lineage documentation.

Collaborate closely with data analysts, business users, and product teams to understand data requirements and deliver data-driven solutions.

Required Skills:

Strong hands-on experience with Snowflake and its features (warehouse management, tasks, streams, etc.).

Proficiency in Python, especially in using it within Snowflake’s Snowpark framework.

Experience handling and transforming semi-structured data (JSON/VARIANT columns).

Strong SQL skills including writing and optimizing queries with CTEs, JOINs, and window functions.

Experience with data modeling concepts and best practices.

Familiarity with metadata-driven ETL design patterns is a plus.