EY India Data Consultant Interview: Rounds, Questions and Preparation

What the job involves

As a Data Consultant in a GCC or Big 4 firm like EY India, you help clients solve business problems by turning raw data into actionable insights. Day to day, you work with SQL, Python, and visualization tools to clean, analyze, and present data, often collaborating with client teams to improve reporting or build dashboards. You also document requirements, validate data quality, and support senior consultants in delivering data-driven recommendations.

Role and Technical Knowledge

1. 1

   What is the difference between WHERE and HAVING in SQL, and when would you use each?

   Explain that WHERE filters rows before grouping, while HAVING filters after GROUP BY. Give an example using aggregate functions like SUM or COUNT.

2. 2

   How would you handle missing values in a dataset before analysis?

   Discuss options like deletion, imputation (mean, median, mode), or using algorithms that handle missing data. Mention the importance of understanding why data is missing.

3. 3

   Explain a p-value and how you would use it in a business context.

   Define p-value as the probability of observing results if the null hypothesis is true. Give a business example like A/B testing to decide if a change is significant.

4. 4

   What are some common data quality issues you might encounter, and how would you address them?

   List issues like duplicates, inconsistent formats, outliers, and missing values. Describe steps like profiling, validation rules, and cleansing using tools like Python or Excel.

Practical Scenarios

1. 5

   A client's sales report shows a sudden drop in revenue for one region. How would you investigate?

   Outline a structured approach: validate data, check for seasonality, compare with other regions, drill down by product or customer, and communicate findings with hypotheses.

2. 6

   You are asked to create a dashboard for a retail client to track store performance. What metrics would you include and why?

   Suggest metrics like sales, footfall, conversion rate, average transaction value, and inventory turnover. Explain how each helps monitor store health and make decisions.

3. 7

   How would you explain a complex data insight to a non-technical client stakeholder?

   Focus on using simple language, visuals, and storytelling. Relate the insight to business impact and avoid jargon. Suggest using analogies or real-world examples.

4. 8

   You have a dataset with 1 million rows and need to analyze it in Excel, but it is too slow. What would you do?

   Mention using SQL or Python for handling large data, then summarizing before importing to Excel. Alternatively, use Power Query or a database tool to aggregate first.

Behavioural and HR

1. 9

   Tell me about a time you worked in a team to solve a problem. What was your role?

   Use STAR method: describe the situation, task, action, and result. Highlight collaboration, your specific contribution, and the outcome.

2. 10

   Why do you want to work as a Data Consultant in a consulting firm like EY India?

   Show passion for data-driven problem solving and client impact. Mention exposure to diverse industries, learning opportunities, and alignment with your skills.

3. 11

   Describe a situation where you had to learn a new tool or technology quickly. How did you manage?

   Emphasize self-learning, resourcefulness (online courses, documentation), and applying the new skill to a project. Show adaptability and eagerness to learn.

4. 12

   How do you prioritize tasks when you have multiple deadlines?

   Discuss using urgency and importance matrix, communicating with stakeholders, and breaking tasks into smaller steps. Give an example from academics or internships.

Consulting and Business Acumen

1. 13

   What are some key performance indicators (KPIs) a telecom client might track, and how can data consulting help improve them?

   Mention KPIs like ARPU, churn rate, call drop rate, and customer acquisition cost. Explain how data analysis can identify trends and suggest interventions to improve these metrics.

2. 14

   How would you approach a project where the client has data in multiple systems and wants a unified view?

   Discuss data integration steps: identify sources, define common keys, use ETL processes, and create a data warehouse or data lake. Emphasize data governance and quality checks.

3. 15

   What is the role of a data consultant in digital transformation initiatives?

   Explain that consultants help clients adopt data-driven decision making, automate reporting, and leverage advanced analytics. They bridge business and technical teams to ensure solutions meet goals.

4. 16

   How would you measure the success of a data consulting engagement?

   Suggest metrics like client satisfaction, adoption of recommendations, ROI, time saved, and improved decision-making. Highlight the importance of aligning with client objectives from the start.