Moj Product Analyst Interview: Rounds, Questions and Preparation

What the job involves

Product Analysts at Indian unicorns and high-growth startups like Moj work at the intersection of data, product, and business. They write SQL queries to extract user behaviour insights, build dashboards, run A/B tests, and partner with product managers to define metrics and drive feature decisions. Expect a fast-paced environment where you analyse funnels, retention, and engagement for a large consumer app.

Role and Technical Knowledge

1. 1

   What are the key metrics you would track for a short-video app like Moj to measure user engagement?

   Name specific metrics such as DAU, MAU, DAU/MAU ratio, average session duration, videos watched per user, and retention rate. Explain why each matters for a content platform.

2. 2

   How would you write a SQL query to find the top 10 most watched videos in the last 7 days?

   Mention using SUM or COUNT on views, filtering with a date condition, grouping by video_id, ordering descending, and limiting to 10. Show awareness of joins if video details are in another table.

3. 3

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

   Funnel analysis tracks step-by-step drop-off in a user journey (e.g., sign-up to first video upload). Cohort analysis groups users by time or behaviour to track retention over time. Give a product example for each.

4. 4

   What is an A/B test, and what are the common pitfalls to avoid when running one at a consumer startup?

   Cover random assignment, control vs. treatment, and statistical significance. Pitfalls include peeking early, not running long enough, sample ratio mismatch, and confounding variables like festivals or app updates.

Practical Scenarios and Case Studies

1. 5

   Daily active users of a short-video app dropped by 10% week-over-week. How would you investigate the cause?

   Structure your answer: check data quality first, then segment by platform (Android/iOS), geography, new vs. existing users, and feature usage. Look for recent releases, marketing changes, or external events. Suggest a hypothesis and next steps.

2. 6

   You are asked to design a dashboard for the product team to monitor a new 'creator monetisation' feature. What metrics and dimensions would you include?

   Include adoption rate, number of creators earning, average earnings, repeat usage, and retention of monetising creators. Add dimensions like time, creator tier, and content category. Mention refresh frequency and audience.

3. 7

   How would you estimate the number of daily active users for a new short-video app in India?

   Use a guesstimate approach: start with smartphone users, then segment by age and interest, apply adoption rates, and account for competing apps. Show your assumptions clearly and sanity-check the final number.

4. 8

   A product manager wants to launch a new 'duet' feature. How would you define success metrics and set up an experiment?

   Define primary metric (e.g., duet creation rate) and guardrail metrics (e.g., app crash rate, overall engagement). Suggest a holdout group, duration, and how to measure statistical significance. Mention potential network effects.

Behavioural and Situational Questions

1. 9

   Tell me about a time you used data to solve a problem or make a decision. What was the outcome?

   Use the STAR method. Highlight the data you collected, the analysis you did (even if in Excel), and the impact. Show curiosity and attention to detail.

2. 10

   Describe a situation where you had to explain a technical concept to a non-technical person. How did you ensure they understood?

   Focus on simplifying without jargon, using analogies, and checking for understanding. Emphasise empathy and clarity, which are key for product analysts working with designers and managers.

3. 11

   You are working on a tight deadline and realise a key data source is missing. What do you do?

   Show prioritisation: assess impact, communicate early to stakeholders, look for alternative data or quick approximations, and document limitations. Highlight teamwork and problem-solving.

4. 12

   Why do you want to work as a Product Analyst at a high-growth startup like Moj, and how do you handle ambiguity?

   Connect your interest to the fast-paced, data-driven culture of Indian unicorns. Give an example of how you have thrived with incomplete information, such as a college project or internship.

HR and Culture Fit

1. 13

   What do you know about our company and the short-video industry in India?

   Research the company's products, recent news, and competitors. Mention trends like regional language content, creator economy, and monetisation. Show genuine interest.

2. 14

   Where do you see yourself in three years, and how does this role fit into your career goals?

   Align your growth with the company's needs: moving from analyst to senior analyst or product manager. Emphasise learning, impact, and staying in the analytics or product track.

3. 15

   How do you prioritise multiple tasks when everything seems urgent?

   Mention frameworks like impact vs. effort, communicating with stakeholders, and using tools like Trello or Jira. Give a concrete example from college or an internship.

4. 16

   What are your salary expectations for this role?

   Research typical fresher Product Analyst salaries in Indian startups (e.g., 6-12 LPA). Give a range and express flexibility based on overall compensation and learning opportunities.