The prospect

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.

Your key responsibilities

- 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.
- Monitor system performance, troubleshoot data processing issues, and optimize queries.
- Prepare documentation and conduct knowledge-sharing sessions for team members.

Skills and attributes for success

•

- Hands-on expertise in Snowflake for data warehousing.
- Strong proficiency with dbt for modular, testable SQL transformations.
- Should be having Experience: 5–8 years
- Solid experience with Astronomer/Apache Airflow for orchestration and scheduling.
- Strong SQL and data modelling skills.
- Knowledge of ELT best practices and performance optimization.
- Understanding of insurance data domains including policies, claims, actuarial data, and compliance.
- Familiarity with version control (Git) and CI/CD practices for data projects.




- Knowledge of Python and Git-based CI/CD pipelines is a plus.
- Knowledge of Data Vault and building model using Dbt is a plus.

To qualify for the role, you must have

- Experience with cloud environments such as AWS, Azure, or GCP.
- Knowledge of Python for scripting in Airflow workflows.

Education

- Bachelor’s or master’s degree in computer science, Information Systems, Data Engineering, or related field

Ideally, you’ll also have

- Client management skills

What we look for

People with technical experience and enthusiasm to learn recent things in this fast-moving environment

What working at EY offers

At EY, we’re dedicated to helping our clients, from start–ups to Fortune 500 companies — and the work we do with them is as varied as they are.

You get to work with inspiring and meaningful projects. Our focus is education and coaching alongside practical experience to ensure your personal development. We value our employees and you will be able to control your own development with an individual progression plan. You will quickly grow into a responsible role with challenging and stimulating assignments. Moreover, you will be part of an interdisciplinary environment that emphasizes high quality and knowledge exchange. Plus, we offer:

- Support, coaching and feedback from some of the most engaging colleagues around
- Opportunities to develop new skills and progress your career
- The freedom and flexibility to handle your role in a way that’s right for you

EY | Building a better working world

📌 EY - GDS Consulting - AI and DATA - Snowflake - DBT - Senior (India)
🏢 EY
📍 India