Walgreens India Data Consultant Interview: Rounds, Questions and Preparation

What the job involves

A Data Consultant in GCCs, consulting, and Big 4 firms helps clients solve business problems using data. Day to day work includes gathering requirements, cleaning and analysing data, building dashboards or models, and presenting actionable insights to stakeholders. At a company like Walgreens India, you might support retail, pharmacy, or healthcare analytics projects for global teams.

Role and Technical Knowledge

1. 1

   What is the difference between a primary key and a foreign key in SQL?

   Explain that a primary key uniquely identifies a record, while a foreign key links to a primary key in another table. Give a simple example like customer ID and order ID.

2. 2

   How would you handle missing data in a dataset?

   Discuss options like removal, imputation (mean, median, mode), or using algorithms that handle missing values. Mention considering the impact on analysis.

3. 3

   Explain the difference between supervised and unsupervised learning.

   Supervised uses labeled data for prediction, unsupervised finds patterns in unlabeled data. Provide examples like regression vs clustering.

4. 4

   What are some common data visualization best practices?

   Focus on clarity, appropriate chart types, avoiding clutter, and highlighting key insights. Mention tailoring to the audience.

Practical Scenarios

1. 5

   A retail client wants to reduce inventory costs. What data would you analyse and what approach would you take?

   Suggest analysing sales trends, seasonality, lead times, and stock levels. Propose demand forecasting and inventory optimization techniques.

2. 6

   You are given a dataset with sales figures for a pharmacy chain. How would you identify underperforming stores?

   Calculate metrics like sales per square foot, year-over-year growth, and compare against benchmarks. Segment by region or store type.

3. 7

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

   Use simple language, visualizations, and focus on the business impact. Avoid jargon and relate to their goals.

4. 8

   If you find a discrepancy in a report, how would you troubleshoot it?

   Check data sources, query logic, filters, and calculations step by step. Validate with another source if possible.

Behavioural and HR

1. 9

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

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

2. 10

   Why do you want to work as a Data Consultant in a GCC or consulting firm?

   Show awareness of the role, mention exposure to diverse projects, and alignment with your skills and career goals.

3. 11

   Describe a situation where you had to learn something quickly.

   Pick an example from academics or projects. Emphasize your learning process and the outcome.

4. 12

   How do you handle tight deadlines or pressure?

   Discuss prioritization, time management, and staying calm. Give a specific instance where you succeeded.

Consulting and Business Acumen

1. 13

   What do you understand about the consulting industry and the role of a Data Consultant?

   Mention client-facing work, problem-solving, and delivering data-driven solutions. Show awareness of GCCs and Big 4.

2. 14

   How would you approach a problem where the client has no clear requirements?

   Ask probing questions, understand business objectives, and propose a structured discovery phase. Suggest iterative feedback.

3. 15

   What are some ethical considerations when handling sensitive data, especially in healthcare or pharmacy?

   Discuss privacy laws (like HIPAA), data anonymization, consent, and secure storage. Emphasize confidentiality.

4. 16

   If you had to choose one metric to measure the success of a retail pharmacy, what would it be and why?

   Pick a relevant metric like prescription volume, customer retention, or revenue per store. Justify with business impact.