Pickrr Data Analyst Interview: Rounds, Questions and Preparation

What the job involves

As a Data Analyst at an Indian unicorn or high-growth startup like Pickrr, you will work with large datasets to uncover insights that drive business decisions, often in logistics, supply chain, or e-commerce domains. Day to day, you might write SQL queries, build dashboards, analyse funnel performance, and collaborate with product, operations, and marketing teams to solve real-time problems. Expect a fast-paced environment where you balance ad-hoc requests with long-term analytics projects.

Role and Technical Knowledge

1. 1

   How would you write a SQL query to find the second highest shipment cost from a table of orders?

   Use a subquery with MAX or window function like DENSE_RANK. Explain the logic and mention handling ties.

2. 2

   What are the key metrics you would track for a logistics startup like Pickrr to measure operational efficiency?

   Cover metrics like on-time delivery rate, cost per shipment, first-attempt delivery rate, and return rate. Relate them to business impact.

3. 3

   Explain the difference between INNER JOIN and LEFT JOIN with an example relevant to customer orders and shipments.

   Show how LEFT JOIN keeps all customers even without shipments, while INNER JOIN only returns matched rows. Use a practical scenario.

4. 4

   How would you detect and handle missing data in a dataset of delivery timestamps?

   Discuss types of missingness, imputation methods (mean, median, forward fill), and when to drop rows. Mention impact on analysis.

Practical Scenarios and Case Studies

1. 5

   A client complains that their shipping costs increased by 20% last month. How would you investigate this using data?

   Break down cost components (fuel, weight, distance, zone), compare with previous months, and check for changes in order mix or carrier rates.

2. 6

   You need to design a dashboard for the operations team to monitor daily pickup and delivery performance. What metrics and filters would you include?

   Include real-time metrics like pending pickups, delivery success rate, average time per stage. Suggest filters by region, courier partner, and date.

3. 7

   How would you set up an A/B test to measure the impact of a new packaging material on damage rates?

   Define hypothesis, randomize shipments, choose sample size, run test, and analyse damage rate with statistical significance. Mention control for external factors.

4. 8

   Given a dataset of customer complaints, how would you prioritise which issues to fix first?

   Use frequency and severity analysis, maybe a Pareto chart. Link to business impact like customer churn or refund costs.

Behavioural and Situational Questions

1. 9

   Tell me about a time you had to explain a complex data insight to a non-technical audience. How did you ensure they understood?

   Use STAR method. Emphasise simplifying jargon, using visuals, and focusing on actionable takeaways.

2. 10

   Describe a situation where you had to work with incomplete or messy data. What steps did you take?

   Show initiative in data cleaning, documenting assumptions, and communicating limitations to stakeholders.

3. 11

   How would you handle a request from a senior manager for an urgent analysis that you think is based on a flawed assumption?

   Demonstrate respectful pushback, ask clarifying questions, and propose a better approach while meeting the deadline.

4. 12

   Give an example of a time you had to learn a new tool or skill quickly to complete a project.

   Highlight self-learning, resourcefulness, and applying the new skill effectively. Mention outcome.

HR and Company Fit

1. 13

   Why do you want to work as a Data Analyst at a high-growth startup like Pickrr instead of a large corporate?

   Show enthusiasm for fast-paced environments, ownership, and direct impact. Research the company's domain and recent developments.

2. 14

   Where do you see yourself in three years in terms of analytics skills and career growth?

   Align your goals with the company's needs, e.g., mastering advanced analytics, leading projects, or specialising in logistics analytics.

3. 15

   How do you prioritise multiple ad-hoc data requests from different teams?

   Discuss impact vs urgency, communicating timelines, and using tools like a task tracker. Show ability to say no politely.

4. 16

   What are your salary expectations for this role?

   Research industry standards for fresher data analysts in Indian startups. Give a range and express flexibility based on overall compensation.