CHENNAI · FULLTIME
Senior - Snowflake and DBT

Ernst Young
Chennai · onsite · Posted 4d ago
Sourced from
Undisclosed1–4 yrsfulltimeChennai
Your match
?
Sign in to see your match score, skill gaps & tailored resume.
Section · 01
About this role
Job Summary
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.
Role overview 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.
- Hands-on expertise in Snowflake for data warehousing.
- Strong proficiency with dbt for modular, testable SQL transformations.
- Should be having Experience: 58 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.
- Experience with cloud environments such as AWS, Azure, or GCP.
- Knowledge of Python for scripting in Airflow workflows.
- Bachelors or masters degree in computer science, Information Systems, Data Engineering, or related field
- Client management skills
People with technical experience and enthusiasm to learn new things in this fast-moving environment
Sourced from naukri
Let the agent run this one for you.
Tailored resume, auto-apply, and referral lookup — in under 2 minutes.
Section · 02
Skills
data qualityData EngineerData ingestionCI/CD PipelinesApacheamazon web servicesapache airflowActuarialAnalyticsdata modelsBankingCapital MarketsData EngineeringcloudcomplianceData ProcessingMicrosoft AzureData PipelineArtificial Intelligence
Section · Company
About Ernst & Young

Ernst Young
Management Consulting
44k+
employees
2002
24 years old
Gurgaon / Gurugram, Haryana
India
₹15.3L PA avg
Avg at Ernst & Young
About
At EY, our purpose is Building a better working world. The insights and quality services we provide help build trust and confidence in the capital markets and in economies the world over.
Industries
Management Consulting
Employee ratings
10 reviews
3.4/ 5
Culture
1.9
Career growth
2.3
Work-life
2.5
Employees rate it well for
Job Security36Skill Development35
Find them on