Consultant-National-Tech Consulting-CNS - TC - Data Analyst with Python - Bangalore

EY Consulting is made up of three sub-service lines: Business Consulting (including Performance Improvement and Risk Consulting), Technology Consulting and People Advisory Services.In Tech Consulting, we are transforming businesses through the power of people, technology and innovation. It places humans@center, leverages technology@speed and enables innovation@scale.Your Key ResponsibilitiesTechnical ExcellenceData Analyst – (Snowflake +DBT)Experience:3–8 YearsRole SummaryLocation – Bangalore; Exp-5-9 YearsRelevant experience à 3yrs minimum.Main Tech Stack – Snowflake, SQL, DBT.Good to have – Azure cloud knowledge, Python, Spark.Immediate joiners preferred.Key ResponsibilitiesShould be able to write Advanced SQL, complex joins.Subqueries - correlated /non correlated, CTEs.Window functions.Aggregations - Group by, rollup, cube, pivot.Snowflake Skilled needed:Should be able to understand and write UDFs and stored procedures in snowflake.Have good understanding of Snowflake architecture, clustering , micro partitions, caching, virtual warehouse, stages, storage , security(row and column level security).Knowledge of snowflake features (Streams, time -travel, zero copy cloning, Snowpark and tasks).Provide expert recommendations on frameworks, tools, and methodologies to optimize development efficiency an...