Senior Consultant - Business Consulting PI - National - CNS - BC - Finance - Chennai

Requisition Id : 1552087

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 : Senior Consultant-National-Business Consulting PI-CNS - BC - Finance - Chennai

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.

Your key responsibilities

Technical Excellence

Strong SQL skills, including CTE.
Have Snowflake experience or very strong Database experience, i.e. have tuned SQL before.
Have an understanding of DBT Core / DBT Cloud and preferably have used it before.
Show a good understanding of development best practices, peer reviews, and unit tests etc.
Understand fundamental data modeling concepts (3NF, Star, Snowflake, the grain of data et al)
Have experience of Data Analysis and Data Profiling tasks.

Skills and attributes

To qualify for the role you must have
Qualification

Strong SQL skills, including CTE.
Have Snowflake experience or very strong Database experience, i.e. have tuned SQL before.
Have an understanding of DBT Core / DBT Cloud and preferably have used it before.
Show a good understanding of development best practices, peer reviews, and unit tests etc.
Understand fundamental data modeling concepts (3NF, Star, Snowflake, the grain of data et al)
Have experience of Data Analysis and Data Profiling tasks.

Experience

3 to 6 years of relevant post qualification experience, preferably from Consulting or industry with significant expertise in  at least three of the areas listed – Business transformation,  Business process Re-engineering, Market assessment,  Post-merger integration, Strategy and Business planning, Sales and Marketing improvement / transformation, Strategic Cost Reduction, Supply Chain Management / transformation
In-depth domain knowledge in one or more and expertise in at least one sector of the following sectors: listed – Consumer Products, Automotive, Diversified industrial products

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 postivie energy, while being adaptable and creative in their approach. 

What we offer

With more than 200,000 clients, 300,000 people globally and 33,000 people in India, EY has become the strongest brand and the most attractive employer in our field, with market-leading growth over compete. Our people work side-by-side with market-leading entrepreneurs, game- changers, disruptors and visionaries. As an organisation, 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 whilst allowing our people to build their career 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 building a better working world. Apply now.