EY - GDS Consulting - AI and DATA - Snowflake - DBT - Senior
Ernst and Young6 days ago
Chennai, IndiaSenior
Responsibilities
- Design, develop, and maintain ELT data pipelines using Snowflake, dbt, and Airflow.
- Build and optimize Snowflake data models for analytics and reporting.
- Implement dbt transformation logic for business rules and semantic-layer creation.
- Automate workflows and data ingestion with Airflow DAGs.
- Translate insurance concepts such as policies, claims, and underwriting into technical data pipelines.
- Monitor system performance, troubleshoot data-processing issues, and optimize queries.
- Prepare documentation and conduct knowledge-sharing sessions.
Requirements
- 5–8 years of experience in data engineering or a related area.
- Hands-on Snowflake data-warehousing expertise and strong dbt proficiency.
- Experience with Astronomer/Apache Airflow for orchestration and scheduling.
- Strong SQL and data-modeling skills, including ELT best practices and performance optimization.
- Understanding of insurance data domains, including policies, claims, actuarial data, and compliance.
- Experience with cloud environments such as AWS, Azure, or GCP.
- Knowledge of Python for scripting in Airflow workflows.
- Bachelor’s or master’s degree in computer science, information systems, data engineering, or a related field.
- Git and CI/CD familiarity, Data Vault 2.0 knowledge, and client-management skills are pluses.
Benefits
- Support, coaching, and feedback from colleagues.
- Opportunities to develop new skills and progress a career.
- Education, coaching, practical experience, and an individual progression plan.
- Freedom and flexibility to handle the role in a way that is right for the employee.
- Meaningful client projects and an interdisciplinary environment focused on knowledge exchange.
Categories
Data Engineering
About Ernst and Young
Ernst & Young (EY) provides audit/assurance, tax, consulting, strategy and transactions services to enterprises, financial institutions, and public‑sector clients. Structured as a global network of partner‑owned member firms, it sells professional services on a fee basis, including a dedicated Financial Services Organization for banking, insurance, and capital markets. Headquartered in London, EY was formed in 1989 from the merger of Ernst & Whinney and Arthur Young, and operates in 150+ countries.