EY Project Consultant - Business Consulting PI 

India, Tamil Nadu, Chennai 

155761936

​

​:

Contract duration:4 months

​

It has multiple fields of play such as:

Supply Chain and Operations - we provide a unique combination of industry-specific, strategic, operational and financial insights, digital technology advances and strategic alliance partners to deliver better outcomes and also help clients effect fundamental change in their operations’ performance to support sales growth, become more cost competitive, minimize risk and ensure operational resilience.

Technical excellence –

1. SQL (CTE) Common table expressions
2. Snowflake / snow tasks, snow pipe , snow stream
3. Understanding Architecture
4. Query Optimizations/SQL Tuning
5. SCD 1/2/3 Slowly changing dimensions
6. Understanding of DBT Core / DBT Cloud (Hands on is preferred) – Good to have skill.

To qualify for the role you must have –

1. Qualification: BCA/ MCA/ BTech/ MTech/ BSC/ MSC (Any engineering graduate)
2. Strong SQL skills, including CTE.
3. Have Snowflake experience or very strong Database experience i.e. have tuned SQL before.
4. Understand DBT Core / DBT Cloud and preferably have used it before.
5. Show a good understanding of development best practices, peer reviews, and unit tests etc.
6. Understand fundamental data modelling concepts (3NF, Star, Snowflake, the grain of data et al)
7. Have experience of Data Analysis and Data Profiling tasks.

Years of experience –

3-8 years

Skills and attributes –​

​

1. Champion start up thinking and deliver innovative solutions​
2. Enhance business solutions by blending emerging technologies​
3. Embrace technology to transform new ways of working​
4. Deliver highest quality results​
5. Drive a culture of continuous improvement and learning for yourself and others​
6. Create value and build sustainable relationships that last a lifetime​
7. Be involved in a cause for the benefit of larger community​
8. Pursue passions beyond work and invest in your wellbeing

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.

​