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

Requisition Id: 1672036

As a global leader in assurance, tax, transaction and advisory services, we hire and develop the most passionate people in their field to help build a better working world. This starts with a culture that believes in giving you the training, opportunities and creative freedom. At EY, we don't just focus on who you are now, but who you can become. We believe that it’s your career and ‘It’s yours to build’ which means potential here is limitless and we'll provide you with motivating and fulfilling experiences throughout your career to help you on the path to becoming your best professional self.

The opportunity : Consultant-National-Tech Consulting-CNS - TC - Snowflake +DBT - Bangalore

National :

National comprises of sector agnostic teams working across industries for a well rounded experience.

CNS - TC - AI AND DATA :

EY Consulting is building a better working world by transforming businesses through the power of people, technology and innovation. Our client-centric approach focuses on driving long-term value for our clients by solving their most strategic problems. 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 responsibilities

Technical Excellence

Data Analyst – (Snowflake +DBT)

Experience: 3–8 Years

Role Summary

Location – Bangalore; Exp-5-9 Years

• Relevant experience à 3yrs minimum.
• Main Tech Stack – Snowflake, SQL, DBT.
• Good to have – Azure cloud knowledge, Python, Spark.
• Immediate joiners preferred.

Key Responsibilities

• • Should 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 and system robustness.
  • Performance tuning within Snowflake (Performance bottlenecks, materialized views, search optimization)
  • Solution design- Ability to architect scalable, cost-effective snowflake solutions.
  • Cost management - Monitor and optimize Snowflake credit usage and storage costs.

Preferred Background

• Data Analyst
• Data Engineer
• Python Developer with data/analytics experience

What we look for

People with the ability to work in a collaborative manner to provide services across multiple client departments while following the commercial and legal requirements. You will need a practical approach to solving issues and complex problems with the ability to deliver insightful and practical solutions. We look for people who are agile, curious, mindful, and able to sustain positive energy, while being adaptable and creative in their approach.

What we offer

Fuelled by the brilliance of our people, EY has emerged as the strongest brand and the most attractive employer in our field, with market-leading growth over competitors. Our people work side-by-side with market-leading entrepreneurs, game-changers, disruptors, and visionaries. As an organization, we are investing more time, technology, and money than ever before in skills and learning for our people. At EY, you will have a personalized Career Journey and also the chance to tap into the resources of our career frameworks to better know about your roles, skills, and opportunities.

EY is equally committed to being an inclusive employer, and we strive to achieve the right balance for our people—enabling us to deliver excellent client service while allowing our people to build their careers as well as focus on their wellbeing.

If you can confidently demonstrate that you meet the criteria above, please contact us as soon as possible.

Join us in shaping the future with confidence. Apply Now