NestAway Product Analyst Interview: Rounds, Questions and Preparation

What the job involves

A Product Analyst at Indian unicorns and high-growth startups works closely with product managers, engineers, and designers to turn user data into product decisions. Day to day, you will write SQL queries, build dashboards, run experiments, and present insights that shape features for millions of users. In a sector like rental housing or fintech, you also track funnel metrics, cohort retention, and marketplace health.

Role and Technical Knowledge

1. 1

   What is the difference between a metric and a KPI? Give an example from a rental housing platform.

   A metric is any measurable value; a KPI is a metric tied to a strategic goal. For a rental platform, 'number of listings' is a metric, but 'verified listing conversion rate' could be a KPI for trust.

2. 2

   How would you write a SQL query to find the top 5 cities by number of successful move-ins last month?

   Strong answers use JOIN between bookings and properties, filter by status and date, GROUP BY city, ORDER BY count DESC, LIMIT 5. Mention handling nulls or cancelled bookings.

3. 3

   Explain the difference between correlation and causation in product analytics. How would you test if a new feature caused higher retention?

   Correlation shows association; causation requires controlled experiments. For retention, run an A/B test with a control group and check statistical significance over a fixed period.

4. 4

   What is cohort analysis and why is it important for a startup like a rental marketplace?

   Cohort analysis groups users by sign-up month or first booking. It helps track retention, repeat bookings, and the impact of product changes over time, separating growth from churn.

Practical Scenarios

1. 5

   You notice that the number of users who search for a flat but never contact the owner has increased by 20 percent in one week. How would you investigate?

   Break the funnel: search, view listing, click contact, send message. Check for bugs, UI changes, pricing changes, or seasonality. Segment by city, device, and user type. Suggest a fix and a follow-up metric.

2. 6

   Design an A/B test to measure the impact of a new 'verified owner' badge on booking conversion. What metrics would you track?

   Define hypothesis, randomize users, set a control and treatment group. Primary metric: booking conversion. Secondary: time to first contact, cancellation rate. Run for at least one week and check sample size.

3. 7

   A product manager asks you to estimate the monthly revenue from a new premium listing feature in a city like Bangalore. How would you approach this guesstimate?

   Structure: total rental listings in Bangalore, percentage that are premium-eligible, expected adoption rate, average premium fee per month. State assumptions clearly and sanity-check the final number.

4. 8

   You have data showing that users who upload a profile photo are 3x more likely to book a flat. How would you use this insight to improve the product?

   Do not assume causation. Suggest an experiment: prompt users to upload a photo and measure booking lift. Also consider nudges, incentives, or simplifying the upload flow, and track downstream retention.

Behavioural and HR

1. 9

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

   Use STAR format: situation, task, action, result. Highlight the data source, the analysis method, and the measurable outcome. Keep it concise and relevant to product decisions.

2. 10

   Why do you want to work as a Product Analyst at a high-growth startup instead of a large IT services company?

   Show you value ownership, speed, and direct impact on product. Mention comfort with ambiguity and eagerness to learn across functions. Avoid generic answers about 'good culture'.

3. 11

   Describe a time you had to convince a teammate or professor using data. How did you handle disagreement?

   Focus on how you presented evidence, listened to counterpoints, and adjusted your approach. Show empathy and willingness to change your mind if data supported the other side.

4. 12

   How do you prioritise multiple analysis requests from different product managers when everything seems urgent?

   Talk about impact vs effort, aligning with company goals, and communicating trade-offs. Mention using a simple framework like RICE or asking for the decision the analysis will inform.

Company and Sector Awareness

1. 13

   What are the key metrics you would track for a rental housing marketplace to measure its health?

   Cover supply (active listings, owner response rate), demand (searches, visits), match (booking conversion, time to close), and retention (repeat bookings, churn). Mention trust metrics like verified listings.

2. 14

   How does the Indian rental market differ from other markets, and how would that affect product analytics?

   Mention broker dependence, trust issues, no standard deposits, and city-level fragmentation. Analytics must handle messy data, local seasonality, and offline-to-online conversion tracking.

3. 15

   If you had to improve the search experience on a rental platform, what data would you look at first?

   Start with search-to-view rate, zero-result searches, filter usage, and click-through to contact. Also look at location queries and price sensitivity. Suggest A/B testing ranking changes.

4. 16

   What is one product metric you think a startup like NestAway should improve, and how would you measure success?

   Pick a realistic metric like owner response time or booking conversion. Explain why it matters, how you would baseline it, and what a successful improvement would look like in numbers.