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

EY

Chennai

On-site

INR 1,800,000 - 3,000,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Coaching and feedback
Career development opportunities
Flexible work approach

Job summary

EY GDS Data & Analytics is seeking an experienced Data Engineer skilled in Snowflake, dbt and Airflow to build scalable data pipelines for the Insurance domain. You will translate business concepts into robust data models and orchestrated workflows.

Ideal candidates have 5–8 years of hands-on experience, cloud proficiency (AWS/Azure/GCP), strong SQL, Python, and collaboration across teams in Chennai or other EY locations.

Qualifications

  • 5–8 years of data engineering experience.
  • Hands-on Snowflake, dbt, and Airflow experience.
  • Insurance data domain understanding preferred.
  • Experience with cloud platforms (AWS/Azure/GCP).
  • Proficient in Python and SQL; knowledge of Git-based CI/CD.

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

Skills

SQL
Data modeling
Cloud basics (AWS/Azure/GCP)
Python scripting
Git / CI/CD practices

Education

Bachelor’s or Master’s degree in Computer Science / Information Systems / Data Engineering

Tools

Snowflake
dbt
Airflow
Astronomer

Job description

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

Other locations: Primary Location Only

At EY, you’ll have the chance to build a career as unique as you are, with the global scale, support, inclusive culture and technology to become the best version of you. And we’re counting on your unique voice and perspective to help EY become even better, too. Join us and build an exceptional experience for yourself, and a better working world for all.

EY GDS – Data and Analytics (D&A) – Data Engineer (Snowflake, dbt, Airflow, Insurance Domain)

As part of our EY‑GDS D&A (Data and Analytics) team, we help our clients solve complex business challenges with the help of data and technology. We dive deep into data to extract the greatest value and discover opportunities in key business and functions like Banking, Insurance, Manufacturing, Healthcare, Retail, Manufacturing and Auto, Supply Chain, and Finance.

The opportunity

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 2.0 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

What we look for

People with technical experience and enthusiasm to learn new 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 exists to build a better working world, helping to create long-term value for clients, people and society and build trust in the capital markets.

Enabled by data and technology, diverse EY teams in over 150 countries provide trust through assurance and help clients grow, transform and operate.

Working across assurance, consulting, law, strategy, tax and transactions, EY teams ask better questions to find new answers for the complex issues facing our world today.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Data Engineer - Snowflake & dbt (Insurance Domain)
Senior Data Engineer - Snowflake & dbt (Insurance Domain)

EY • Chennai

On-site
INR 1,200,000 - 1,800,000
EY - GDS Consulting - AI And DATA - Databricks Architect - Senior Manager
EY - GDS Consulting - AI And DATA - Databricks Architect - Senior Manager

EY • Hyderabad

On-site
INR 4,000,000 - 7,000,000
Support and coaching
Career development opportunities
Flexible work style
EY - GDS Consulting - AI And DATA -AWS Data Engineer - Manager
EY - GDS Consulting - AI And DATA -AWS Data Engineer - Manager

EY • Coimbatore District

On-site
INR 3,500,000 - 6,000,000
EY - GDS Consulting - AI and DATA - AWS Data Engineer - Senior
EY - GDS Consulting - AI and DATA - AWS Data Engineer - Senior

EY • Kolkata District

On-site
INR 1,800,000 - 3,000,000
EY-GDS Consulting-AI And DATA-AWS-Senior
EY-GDS Consulting-AI And DATA-AWS-Senior

EY • Gurugram District

On-site
INR 1,200,000 - 1,800,000
EY - GDS Consulting - AI And DATA - AI Cloud Arch - Senior Manager
EY - GDS Consulting - AI And DATA - AI Cloud Arch - Senior Manager

EY • Bengaluru

On-site
INR 4,500,000 - 9,000,000
EY - GDS Consulting - AI And DATA - Data Engineer - Senior
EY - GDS Consulting - AI And DATA - Data Engineer - Senior

EY • Bengaluru

On-site
INR 4,000,000 - 8,000,000
TechOps - CloudOps - DataOps - Senior
TechOps - CloudOps - DataOps - Senior

EY • Thiruvananthapuram

Hybrid
INR 1,400,000 - 2,000,000
Health and wellness benefits
Professional development opportunities
Inclusive culture and flexible work
EY - GDS Consulting - AI and DATA - Databricks - Senior
EY - GDS Consulting - AI and DATA - Databricks - Senior

EY • Hyderabad

On-site
INR 1,800,000 - 3,000,000
Risk Consulting - Actuarial - Healthcare Analytics and Model Validation - Manager
Risk Consulting - Actuarial - Healthcare Analytics and Model Validation - Manager

EY • Bengaluru

On-site
INR 400,000 - 750,000
Continuous learning
Flexible work options
Transformative leadership
+1