Ola Electric Data Analyst Interview: Rounds, Questions and Preparation

What the job involves

Data Analysts at Indian unicorns and high-growth startups like Ola Electric work on extracting insights from large datasets to drive business decisions, often focusing on operational efficiency, customer behaviour, and product performance. They collaborate with cross-functional teams to build dashboards, run experiments, and automate reporting. The role demands strong SQL, Excel, and visualisation skills, plus the ability to communicate findings to non-technical stakeholders.

Role and Technical Knowledge

1. 1

   How would you write a SQL query to find the top 5 cities with the highest number of Ola Electric scooter registrations in the last quarter?

   Strong answer includes JOINs, WHERE clause for date filtering, GROUP BY city, ORDER BY count DESC, and LIMIT 5. Mention handling date formats and ensuring data completeness.

2. 2

   Explain the difference between a LEFT JOIN and an INNER JOIN. Give an example where you would use each in the context of analysing customer ride data.

   Clearly define both, then give a scenario: LEFT JOIN to keep all customers even if they have no rides, INNER JOIN to analyse only customers with rides.

3. 3

   What steps would you take to clean a dataset containing missing values and outliers before analysis?

   Cover identifying missing values, imputation or removal based on context, detecting outliers via IQR or z-score, and documenting decisions. Emphasise business impact.

4. 4

   How would you measure the success of a new feature like 'Ola Electric charging station locator' in the app?

   Define metrics such as daily active users, feature adoption rate, session time, and retention. Suggest A/B testing and tracking pre- and post-launch behaviour.

Practical Scenarios

1. 5

   You notice a sudden drop in daily active users for Ola Electric's app. How would you investigate the cause?

   Outline a structured approach: check data pipeline for errors, segment by geography, device, or user cohort, correlate with external events (e.g., app update, outage), and validate with stakeholders.

2. 6

   You are asked to create a dashboard for the operations team to monitor scooter battery health across cities. What metrics would you include and how would you visualise them?

   Include metrics like average battery degradation, charging cycle count, temperature anomalies, and failure rates. Suggest line charts for trends, heatmaps for geographic distribution, and filters for city/time.

3. 7

   A product manager wants to know if a new pricing plan increased revenue. How would you analyse this?

   Propose an A/B test or before-after analysis, control for confounders like seasonality, calculate statistical significance, and consider segment-wise impact. Mention revenue per user and conversion rate.

4. 8

   You have to estimate the number of charging stations needed in a new city. What data would you collect and how would you approach it?

   Gather data on expected scooter density, average daily distance, charging frequency, existing infrastructure, and peak times. Use simple modelling or benchmarking from similar cities.

Behavioural and HR

1. 9

   Tell me about a time you used data to solve a problem. What was your approach and what did you learn?

   Use STAR format: describe the situation, your data-driven action, the outcome, and a key learning. Highlight collaboration and impact.

2. 10

   Why do you want to work as a Data Analyst at a fast-growing startup like Ola Electric?

   Show passion for data-driven decision-making in a dynamic environment. Connect personal skills to the company's mission and mention eagerness to learn.

3. 11

   Describe a situation where you had to explain a complex data insight to a non-technical person. How did you ensure understanding?

   Emphasise simplifying jargon, using visuals, focusing on the 'so what', and checking for comprehension. Give a concrete example from a project or internship.

4. 12

   How do you prioritise multiple data requests from different teams?

   Discuss assessing urgency, impact, and effort. Mention communicating with stakeholders to align on deadlines and using tools like Jira or Trello for tracking.

Advanced and Sector-Specific

1. 13

   How would you use cohort analysis to improve customer retention for Ola Electric's subscription services?

   Define cohorts by sign-up month or usage level, track retention over time, identify drop-off points, and suggest targeted interventions like personalised offers or reminders.

2. 14

   What are some key performance indicators (KPIs) for an electric vehicle startup like Ola Electric, and how would you track them?

   Mention KPIs like vehicle production efficiency, battery cost per kWh, charging station utilisation, customer acquisition cost, and lifetime value. Explain data sources and dashboard tracking.

3. 15

   Explain how you would design an A/B test to evaluate a new in-app payment option. What metrics would you track?

   Define hypothesis, random assignment, sample size, and duration. Track conversion rate, transaction time, error rate, and user satisfaction. Mention avoiding peeking and ensuring statistical power.

4. 16

   What are the challenges of analysing real-time data from IoT devices in electric scooters, and how would you address them?

   Discuss data volume, velocity, variety, latency, and quality issues. Suggest stream processing, edge computing, data validation rules, and scalable storage like time-series databases.