Project Consultant - Business Consulting PI - Contractual role - SQL Snowflake developer- Chennai

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​: Project Consultant - Business Consulting PI - Contractual role - SQL Snowflake developer- Chennai(1519111) / Bengaluru

Location: Chennai/ Bengaluru

Contract duration: 4 months

​

Business Consulting PI - CNS - BC - Finance:

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.

Business Consulting works with clients to reimagine or transform their business purpose and model; create growth; manage cost and efficiency; respond to market pressures and regulation; and resolve operational challenges. The scope of this team encompasses innovation, strategy and purpose, through deep functional experience in business transformation, finance, supply chain and operations, providing support for the complex and large-scale program and portfolio management.

It has multiple fields of play such as:

Finance Consulting - helps assess and transform our clients' finance function to improve performance and effectiveness. We help organizations implement service and cost improvement initiatives, and embed a performance management process and culture that unites the business around its core objectives.

Business Transformation - a m?ultidisciplinary competency, gathering capabilities in transformation architecture, experience design, business design and transformation execution to problem-solve, design and deliver large scale, multi-year, multi-stakeholder transformation programs.

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 –​

In addition to technical competence, what will set you up for success at EY is your ability to: ​

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. 

What working at EY offers

EY is committed to being an inclusive employer and we are happy to consider flexible working arrangements. We strive to achieve the right balance for our people, enabling us to deliver excellent client service whilst allowing you to build your career without sacrificing your personal priorities. While our client-facing professionals can be required to travel regularly, and at times be based at client sites, our flexible working arrangements can help you to achieve a lifestyle balance.

​