In short
Senior Snowflake data engineer in Bengaluru building and optimizing ETL/ELT pipelines and data models using Snowflake, SQL, Python, DBT, and AWS services (Glue, Lambda, Step Functions), with Airflow orchestration, CI/CD automation, and a focus on data quality and cost/performance tuning.
About the role
Job Description & Summary:
We are seeking experienced and passionate Snowflake Data Engineers to join our data engineering team. The ideal candidate will have strong expertise in Snowflake, SQL, Data Modelling, AWS Glue, Lambda, Step Functions and Python, along with exposure to modern data orchestration and cloud platforms.
Job Position Title:
Senior Associate_ Snowflake Senior Data Engineer_Data and Analytics_Advisory_Bangalore
Responsibilities:
You will work on:
Develop ETL/ELT pipelines using AWS services such as Glue, Step Functions, Lambda, and DMS.
Design, develop, and optimize data pipelines and data models in Snowflake.
Implement and maintain DBT workflows for data transformation and modeling.
Write efficient and scalable SQL queries for data extraction and reporting.
Collaborate with data analysts, scientists, and business stakeholders to understand data requirements.
Integrate data from various sources using Python.
Orchestrate workflows using Apache Airflow or similar tools
Ensure data quality, integrity, and governance across the pipeline.
Work with CI/CD tools to automate deployment and testing of data workflows.
Optimize performance and cost of Snowflake workloads.
Leverage cloud services from AWS for scalable data solutions.
Primary Skills:
Snowflake
SQL
Data Modelling
Python (Scripting, Data Manipulation)
AWS – Glue, Lambda, Step Functions
Secondary Skills:
Airflow (Workflow Orchestration)
CI/CD (Git, Jenkins, Azure DevOps, etc.)
PL/SQL, Teradata (for legacy support)
DBT (Data Build Tool)Role & responsibilities
Requirements
- 5-8 years of experience
- Snowflake
- SQL
- Data Modelling