EY - GDS Consulting - AI and DATA - Snowflake - DBT - Senior

About the role

We are seeking an experienced Data Engineer with strong expertise in Snowflake, dbt, and Astronomer- Airflow, along with a solid understanding of insurance business processes. This role will focus on building and optimizing scalable data pipelines, ensuring data quality, and enabling analytics capabilities for insurance data sets.

What you'll do

• Design, develop, and maintain ELT data pipelines using Snowflake, dbt, and Airflow
• Build and optimize data models in Snowflake to support analytics and reporting requirements
• Implement data transformation logic in dbt for business rules and semantic layer creation
• Automate workflows and data ingestion processes with Airflow DAGs
• Collaborate with domain experts to translate insurance data concepts (policies, claims, underwriting) into technical pipelines

What you need

• 5–8 yrs of experience
• Snowflake
• dbt
• Travel booking
• Capital markets
• SQL
• Python
• B.Tech or B.E. or B.Sc or BCA or M.Tech or MCA or M.Sc

Good to have

• ETL
• Airflow
• Data warehousing
• Data modelling
• AWS
• CI/CD