Pilgrim Product Analyst Interview: Rounds, Questions and Preparation

What the job involves

Product Analysts at Indian unicorns and high-growth startups like Pilgrim work at the intersection of data, product, and business. They write SQL queries, build dashboards, run experiments (A/B tests), analyse funnel and cohort metrics, and translate findings into product recommendations. Day to day involves partnering with product managers, engineers, and marketers to track KPIs, identify growth levers, and support data-informed decisions in a fast-paced direct-to-consumer (D2C) environment.

Role and technical knowledge

1. 1

   What are the key metrics you would track for a D2C brand like Pilgrim to measure product health?

   Cover acquisition (CAC, traffic), activation (first purchase rate), retention (repeat purchase rate, cohort retention), revenue (AOV, LTV), and referral. Explain how each ties to business goals.

2. 2

   Write a SQL query to find the top 10 products by total revenue in the last 30 days.

   Use JOIN between orders and order_items, filter by date, GROUP BY product, SUM revenue, ORDER BY DESC, LIMIT 10. Mention handling NULLs and date functions.

3. 3

   Explain the difference between a funnel analysis and a cohort analysis. When would you use each?

   Funnel shows step-by-step drop-off in a single user journey (e.g., cart to checkout). Cohort groups users by time or behaviour to track retention over time. Use funnel for conversion optimisation, cohort for retention and LTV.

4. 4

   How would you design an A/B test to measure the impact of a new checkout page on conversion rate?

   Define hypothesis, control and variant, random assignment, sample size calculation, primary metric (conversion rate), guardrail metrics (page load time, revenue per user), and statistical significance (p-value < 0.05).

Practical scenarios

1. 5

   You notice that daily active users (DAU) dropped by 15% week-over-week. How would you investigate?

   Break down by platform, geography, acquisition channel, and user cohort. Check for tracking bugs, seasonality, competitor actions, or recent app updates. Validate with qualitative user feedback.

2. 6

   A product manager wants to add a loyalty program. How would you estimate its potential impact using data?

   Analyse current repeat purchase rate and AOV. Segment high-value customers. Model incremental lift from similar programs or run a pilot. Consider cannibalisation and cost per point.

3. 7

   You have to present a weekly business review to leadership. What metrics would you include and how would you structure the narrative?

   Start with north-star metric (e.g., revenue or orders), then break into acquisition, conversion, retention, and engagement. Highlight trends, anomalies, and actionable insights, not just numbers.

4. 8

   How would you measure the success of a new feature that lets users filter products by skin concern?

   Define success metrics: filter usage rate, conversion rate for users who use filter vs. not, average order value, and repeat purchase. Use A/B test or pre-post analysis with control for seasonality.

Behavioural and situational

1. 9

   Tell me about a time you used data to solve a problem in a college project or internship.

   Use STAR format. Focus on the data you collected, the analysis method, and the outcome. Quantify impact if possible (e.g., improved efficiency by 20%).

2. 10

   Describe a situation where you had to explain a complex data insight to a non-technical person.

   Show empathy and clarity. Mention simplifying jargon, using visualisations, and checking for understanding. Emphasise the business implication over technical details.

3. 11

   How do you prioritise tasks when you have multiple deadlines from different stakeholders?

   Discuss impact vs. effort, aligning with business goals, communicating trade-offs, and using tools like Eisenhower matrix or simple to-do lists. Give a concrete example.

4. 12

   Why do you want to work as a Product Analyst at a fast-growing D2C startup like Pilgrim?

   Show passion for data-driven decision making, interest in D2C and consumer behaviour, and comfort with ambiguity. Mention specific aspects of the company or sector, not generic praise.

HR and culture fit

1. 13

   Where do you see yourself in 3 years?

   Align with growth in analytics and product. Show interest in deepening SQL/Python skills, owning larger analyses, and eventually leading projects. Avoid saying you want to leave for an MBA immediately.

2. 14

   What are your salary expectations?

   Research typical fresher Product Analyst salaries in Indian startups (e.g., 6-12 LPA). Give a range and say you are open to negotiation based on overall compensation and learning opportunities.

3. 15

   How do you handle feedback or criticism?

   Show a growth mindset. Give an example where you received feedback, acted on it, and improved. Emphasise that you view feedback as a tool for learning.

4. 16

   Are you comfortable working in a fast-paced, ambiguous environment with changing priorities?

   Answer yes and provide an example from college, internship, or freelance work where you adapted to change. Highlight your ability to stay organised and communicate proactively.