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

div style=font-family:Arial;font-size:1.0empAt EY, we’re all in to shape your future with confidence. /ppWe’ll help you succeed in a globally connected powerhouse of diverse teams and take your career wherever you want it to go. /ppJoin EY and help to build a better working world. /p/divdiv style=font-family:Arial;font-size:1.0em /divp style=text-align:justify;margin:0.0cm 0.0cm 8.0pt;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serifstrongspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptJob Description – Data Engineer (Snowflake, dbt, Airflow, Insurance Domain)/span/strong/pp style=text-align:justify;margin:0.0cm 0.0cm 8.0pt;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serifspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptPosition: Data Engineer/span/pp style=text-align:justify;margin:0.0cm 0.0cm 8.0pt;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serifspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptRank- Senior/span/pp style=text-align:justify;margin:0.0cm 0.0cm 8.0pt;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serifspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptExperience: 5–8 years/span/pp style=text-align:justify;margin:0.0cm 0.0cm 8.0pt;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serifspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptEmployment Type: Full-time/span/pp style=text-align:justify;margin:0.0cm 0.0cm 8.0pt;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serif /pp style=text-align:justify;margin:0.0cm 0.0cm 8.0pt;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serifstrongspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptOverview/span/strong/pp style=text-align:justify;margin:0.0cm 0.0cm 8.0pt;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serifspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptWe 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/pp style=text-align:justify;margin:0.0cm 0.0cm 8.0pt;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serif /pp style=text-align:justify;margin:0.0cm 0.0cm 8.0pt;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serifstrongspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptKey Responsibilities/span/strong/pulli style=text-align:justify;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serifspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptDesign, develop, and maintain ELT data pipelines using Snowflake, dbt, and Airflow./span/lili style=text-align:justify;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serifspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptBuild and optimize data models in Snowflake to support analytics and reporting requirements./span/lili style=text-align:justify;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serifspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptImplement data transformation logic in dbt for business rules and semantic layer creation./span/lili style=text-align:justify;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serifspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptAutomate workflows and data ingestion processes with Airflow DAGs./span/lili style=text-align:justify;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serifspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptCollaborate with domain experts to translate insurance data concepts (policies, claims, underwriting) into technical pipelines./span/lili style=text-align:justify;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serifspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptMonitor system performance, troubleshoot data processing issues, and optimize queries./span/lili style=text-align:justify;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serifspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptPrepare documentation and conduct knowledge-sharing sessions for team members./span/li/ulp style=text-align:justify;margin:0.0cm 0.0cm 8.0pt;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serif /pp style=text-align:justify;margin:0.0cm 0.0cm 8.0pt;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serifstrongspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptRequired Skills/span/strong/pulli style=text-align:justify;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serifspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptHands-on expertise in Snowflake for data warehousing./span/lili style=text-align:justify;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serifspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptStrong proficiency with dbt for modular, testable SQL transformations./span/lili style=text-align:justify;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serifspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptSolid experience with Astronomer/Apache Airflow for orchestration and scheduling./span/lili style=text-align:justify;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serifspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptStrong SQL and data modelling skills./span/lili style=text-align:justify;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serifspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptKnowledge of ELT best practices and performance optimization./span/lili style=text-align:justify;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serifspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptUnderstanding of insurance data domains including policies, claims, actuarial data, and compliance./span/lili style=text-align:justify;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serifspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptFamiliarity with version control (Git) and CI/CD practices for data projects./span/lili style=text-align:justify;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serifspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptKnowledge of Python and Git-based CI/CD pipelines is a plus./span/lili style=text-align:justify;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serifspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptKnowledge of Data Vault 2.0 and building model using Dbt is a plus./span/li/ulp style=text-align:justify;margin:0.0cm 0.0cm 8.0pt;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serif /pp style=text-align:justify;margin:0.0cm 0.0cm 8.0pt;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serifstrongspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptPreferred Qualifications/span/strong/pulli style=text-align:justify;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serifspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptExperience with cloud environments such as AWS, Azure, or GCP./span/lili style=text-align:justify;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serifspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptKnowledge of Python for scripting in Airflow workflows./span/li/ulp style=text-align:justify;margin:0.0cm 0.0cm 8.0pt;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serif /pp style=text-align:justify;margin:0.0cm 0.0cm 8.0pt;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serifstrongspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptEducation/span/strong/pulli style=text-align:justify;line-height:115%;font-size:12.0pt;font-family:Aptos, sans-serifspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptBachelor’s or master’s degree in computer science, Information Systems, Data Engineering, or related field/span/li/uldiv style=font-family:Arial;font-size:1.0empbEY | Building a better working world /b/ppEY is building a better working world by creating new value for clients, people, society and the planet, while building trust in capital markets./ppEnabled by data, AI and advanced technology, EY teams help clients shape the future with confidence and develop answers for the most pressing issues of today and tomorrow./ppEY teams work across a full spectrum of services in assurance, consulting, tax, strategy and transactions. Fueled by sector insights, a globally connected, multi-disciplinary network and diverse ecosystem partners, EY teams can provide services in more than 150 countries and territories./p/div