Description

You will design and build data solutions using Snowflake architecture.

Responsibilities

• Design and build data solutions leveraging Snowflake architecture.
• Develop ETL processes and implement dimensional data modeling.
• Write advanced SQL queries including joins, recursive functions, and window functions.
• Automate data workflows using Python scripting and Airflow.
• Manage data transformations using PyPandas and implement Slowly Changing Dimensions (SCD).

Required Skills

• 5+ years of experience in data engineering.
• Deep understanding of Snowflake architecture and solution design.
• Advanced SQL proficiency: Joins, Self Joins, Views, Materialized Views, Cursors, Recursive SQL, GROUP BY, and PARTITION BY.
• Hands-on experience with Python programming.
• Experience with PyPandas and Airflow.
• Strong knowledge of ETL processes and Dimensional Data Modeling (SCD).

Preferred Skills

• Experience with Snowflake performance optimization techniques.

Key Skills

Education

Any Graduate