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

Delhi - India

Monthly Salary: Not Disclosed

Posted on: 3 days ago

Vacancies: 1 Vacancy

Job Summary

Requisition Id:

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 dont just focus on who you are now but who you can become. We believe that its your career and Its yours to build which means potential here is limitless and well 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 leverages and enables

Your key responsibilities

Technical Excellence

Data Analyst (Snowflake DBT)

Experience: 38 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 peopleenabling 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

Required Experience:

Requisition Id: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 do...