Stantec India Data Consultant Interview: Rounds, Questions and Preparation

What the job involves

A Data Consultant in GCCs, consulting, or Big 4 firms helps clients make sense of their data by cleaning, analysing, and visualising it to solve business problems. Day to day, you might work with SQL and Python to extract data, build dashboards in Power BI or Tableau, and present findings to senior consultants or client stakeholders. The role blends technical data skills with consulting communication, so you need to explain insights clearly to non-technical audiences.

Role and Technical Knowledge

1. 1

   How would you explain the difference between a data analyst and a data consultant?

   Highlight that a data consultant not only analyses data but also advises clients on business strategy, often working on multiple projects and communicating insights to stakeholders.

2. 2

   What are the key steps you follow to clean a messy dataset?

   Cover identifying missing values, outliers, duplicates, standardising formats, and validating data with domain knowledge. Mention tools like Python or Excel.

3. 3

   Write a SQL query to find the second highest salary from an Employee table.

   Use a subquery with MAX or the LIMIT/OFFSET clause. Explain your approach and consider edge cases like ties.

4. 4

   How do you decide which chart type to use for a given dataset?

   Match chart to data type and message: bar for comparison, line for trends, pie for proportions (sparingly), scatter for correlation. Emphasise clarity for the audience.

Practical Scenarios

1. 5

   A client claims their sales dropped by 20% last quarter. How would you investigate this?

   Structure your approach: validate the data, segment by product/region/time, check for seasonality or one-off events, and compare with industry benchmarks.

2. 6

   You have a dataset with 30% missing values in a key column. What do you do?

   Discuss options like imputation, dropping rows, or using proxies, and explain the trade-offs and impact on analysis.

3. 7

   Your manager asks you to create a dashboard for a retail client to track store performance. What metrics would you include?

   Suggest metrics like sales, footfall, conversion rate, average transaction value, and inventory turnover. Mention filters for time and region.

4. 8

   How would you handle a situation where the client's data contradicts their stated business problem?

   Show diplomacy: present findings with evidence, ask clarifying questions, and suggest revisiting the problem statement together.

Behavioural and HR

1. 9

   Tell me about a time you worked in a team to solve a complex problem.

   Use STAR format: describe the situation, your role, the actions taken, and the outcome. Highlight collaboration and your contribution.

2. 10

   Why do you want to work in consulting, especially at a firm like Stantec India?

   Connect your interest in data-driven problem-solving with consulting's variety and impact. Mention the firm's sectors (e.g., infrastructure, energy) and culture.

3. 11

   Describe a situation where you had to explain a technical concept to a non-technical person.

   Show your ability to simplify without losing accuracy. Emphasise listening to the audience and using analogies or visuals.

4. 12

   Where do you see yourself in five years?

   Align your growth with the consulting path: gaining domain expertise, leading projects, and developing client relationships. Avoid saying you want to leave consulting.

Consulting and Business Acumen

1. 13

   How would you estimate the market size for electric vehicles in India?

   Use a top-down or bottom-up approach: segment by population, income, adoption rates, and replacement cycles. State assumptions clearly.

2. 14

   A client wants to reduce customer churn. What data would you analyse and what recommendations might you make?

   Analyse churn drivers: usage patterns, complaints, demographics. Suggest retention strategies like personalised offers or improved service.

3. 15

   What is the difference between correlation and causation? Give an example relevant to consulting.

   Explain that correlation does not imply causation. Use an example like ice cream sales and drowning incidents, then relate to business metrics.

4. 16

   How would you prioritise multiple tasks from different clients?

   Discuss urgency, impact, and dependencies. Mention communicating with stakeholders to manage expectations.