Bombay Hemp Company Data Analyst Interview: Rounds, Questions and Preparation

What the job involves

A Data Analyst at an Indian unicorn or high-growth startup like Bombay Hemp Company typically works with product, marketing, and operations teams to track key metrics, build dashboards, and run experiments. Day to day involves SQL querying, spreadsheet modeling, and presenting insights that inform quick business decisions in a fast-changing environment. Freshers often support senior analysts on ad-hoc analyses and data cleaning.

Role and Technical Knowledge

1. 1

   Write a SQL query to find the top 5 cities by number of orders in the last 30 days.

   Strong answer uses GROUP BY, ORDER BY, LIMIT, and a date filter. Mention handling NULLs or duplicates if relevant.

2. 2

   What is the difference between a LEFT JOIN and an INNER JOIN? Give an example from a startup context.

   Explain that LEFT JOIN keeps all rows from the left table. Example: all users and their orders, including users with zero orders.

3. 3

   How would you calculate customer retention rate for a subscription product?

   Define retention as (customers at end of period - new customers) / customers at start. Discuss cohort analysis and time windows.

4. 4

   Explain what an A/B test is and how you would decide the sample size.

   Cover control vs treatment, randomization, and using power analysis to determine sample size based on baseline conversion and minimum detectable effect.

Practical Scenarios

1. 5

   You are given a dataset of user signups and purchases. How would you identify the most valuable customer segment?

   Strong answer segments by recency, frequency, monetary value (RFM) or by acquisition channel, then compares average order value and lifetime value.

2. 6

   A dashboard shows a sudden 20% drop in daily active users. How would you investigate?

   Check data pipeline issues first, then segment by platform, geography, and user cohort. Look for external events or recent product changes.

3. 7

   You need to present a weekly report to the marketing team. What metrics would you include and why?

   Include CAC, conversion rate, channel-wise performance, and ROI. Explain that metrics should tie to the team's goals and be actionable.

4. 8

   How would you clean a dataset with missing values and outliers before analysis?

   Discuss imputation vs removal, using median for skewed data, and documenting decisions. Mention that outliers may be valid and should be investigated.

Behavioural and HR

1. 9

   Why do you want to work as a data analyst at a high-growth startup like Bombay Hemp Company rather than a large corporation?

   Show interest in wearing multiple hats, learning quickly, and seeing direct impact. Avoid generic answers about 'growth' without specifics.

2. 10

   Tell me about a time you had to explain a technical concept to a non-technical person.

   Use STAR method. Highlight simplifying without losing accuracy and checking for understanding.

3. 11

   Describe a situation where you had to meet a tight deadline with incomplete data. What did you do?

   Emphasize prioritization, making assumptions explicit, and communicating limitations to stakeholders.

4. 12

   Where do you see yourself in three years, and how does this role fit into that plan?

   Align your growth with deeper analytics skills, possibly leading projects, and contributing to data-driven culture. Show realistic ambition.

Sector-Specific and Company Fit

1. 13

   What are some unique data challenges in a fast-growing startup in the hemp or wellness space?

   Mention regulatory constraints, changing product lines, small but growing user base, and need for quick experimentation.

2. 14

   How would you measure the success of a new product launch for a company like Bombay Hemp Company?

   Define metrics like adoption rate, repeat purchase rate, customer acquisition cost, and net promoter score. Tie to business goals.

3. 15

   If you had to build a simple dashboard for the founders to track daily operations, what would you include?

   Include revenue, orders, active users, inventory levels, and marketing spend. Keep it simple and focused on key decisions.

4. 16

   How do you stay updated with new analytics tools and trends?

   Mention following blogs, taking online courses, or working on personal projects. Show curiosity and self-learning.