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

<p><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-size:11.0px">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. </span></span></p><p> </p><p> </p><p> </p><p> </p><p style="text-align:justify;margin:0.0cm 0.0cm 8.0pt;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serif"><strong><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Job Description – Data Engineer (Snowflake, dbt, Airflow, Insurance Domain)</span></strong></p><p style="text-align:justify;margin:0.0cm 0.0cm 8.0pt;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Position: Data Engineer</span></p><p style="text-align:justify;margin:0.0cm 0.0cm 8.0pt;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Rank- Senior</span></p><p style="text-align:justify;margin:0.0cm 0.0cm 8.0pt;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Experience: 5–8 years</span></p><p style="text-align:justify;margin:0.0cm 0.0cm 8.0pt;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Employment Type: Full-time</span></p><p style="text-align:justify;margin:0.0cm 0.0cm 8.0pt;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serif"> </p><p style="text-align:justify;margin:0.0cm 0.0cm 8.0pt;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serif"><strong><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Overview</span></strong></p><p style="text-align:justify;margin:0.0cm 0.0cm 8.0pt;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">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.</span></p><p style="text-align:justify;margin:0.0cm 0.0cm 8.0pt;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serif"> </p><p style="text-align:justify;margin:0.0cm 0.0cm 8.0pt;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serif"><strong><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Key Responsibilities</span></strong></p><ul><li style="text-align:justify;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Design, develop, and maintain ELT data pipelines using Snowflake, dbt, and Airflow.</span></li><li style="text-align:justify;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Build and optimize data models in Snowflake to support analytics and reporting requirements.</span></li><li style="text-align:justify;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Implement data transformation logic in dbt for business rules and semantic layer creation.</span></li><li style="text-align:justify;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Automate workflows and data ingestion processes with Airflow DAGs.</span></li><li style="text-align:justify;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Collaborate with domain experts to translate insurance data concepts (policies, claims, underwriting) into technical pipelines.</span></li><li style="text-align:justify;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Monitor system performance, troubleshoot data processing issues, and optimize queries.</span></li><li style="text-align:justify;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Prepare documentation and conduct knowledge-sharing sessions for team members.</span></li></ul><p style="text-align:justify;margin:0.0cm 0.0cm 8.0pt;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serif"> </p><p style="text-align:justify;margin:0.0cm 0.0cm 8.0pt;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serif"><strong><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Required Skills</span></strong></p><ul><li style="text-align:justify;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Hands-on expertise in Snowflake for data warehousing.</span></li><li style="text-align:justify;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Strong proficiency with dbt for modular, testable SQL transformations.</span></li><li style="text-align:justify;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Solid experience with Astronomer/Apache Airflow for orchestration and scheduling.</span></li><li style="text-align:justify;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Strong SQL and data modelling skills.</span></li><li style="text-align:justify;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Knowledge of ELT best practices and performance optimization.</span></li><li style="text-align:justify;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Understanding of insurance data domains including policies, claims, actuarial data, and compliance.</span></li><li style="text-align:justify;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Familiarity with version control (Git) and CI/CD practices for data projects.</span></li><li style="text-align:justify;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Knowledge of Python and Git-based CI/CD pipelines is a plus.</span></li><li style="text-align:justify;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Knowledge of Data Vault 2.0 and building model using Dbt is a plus.</span></li></ul><p style="text-align:justify;margin:0.0cm 0.0cm 8.0pt;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serif"> </p><p style="text-align:justify;margin:0.0cm 0.0cm 8.0pt;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serif"><strong><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Preferred Qualifications</span></strong></p><ul><li style="text-align:justify;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Experience with cloud environments such as AWS, Azure, or GCP.</span></li><li style="text-align:justify;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Knowledge of Python for scripting in Airflow workflows.</span></li></ul><p style="text-align:justify;margin:0.0cm 0.0cm 8.0pt;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serif"> </p><p style="text-align:justify;margin:0.0cm 0.0cm 8.0pt;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serif"><strong><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Education</span></strong></p><ul><li style="text-align:justify;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Bachelor’s or master’s degree in computer science, Information Systems, Data Engineering, or related field</span></li></ul><p> </p><p><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-size:11.0px"><b>EY | Building a better working world </b></span></span></p><p><br><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-size:11.0px"> <br>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.  </span></span></p><p><br><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-size:11.0px"> <br>Enabled by data and technology, diverse EY teams in over 150 countries provide trust through assurance and help clients grow, transform and operate.  </span></span></p><p><br><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-size:11.0px"> <br>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.  </span></span></p>