Собеседование аналитика в Whoosh

О компании

Whoosh — крупнейший kick-sharing оператор в России. Electric scooters в городах. Seasonal business (активно март-октябрь).

Public company (IPO 2022). Growing продукт.

Процесс

3-4 rounds:

1. HR screening
2. Technical SQL
3. Product / case
4. Final

Стек

• PostgreSQL / ClickHouse
• Python pandas
• Tableau / Metabase
• Geo tools (PostGIS, mapping libs)

SQL раунд

Middle уровень с geo-specific:

Examples

• Rides per location
• Battery drain analysis
• Dynamic pricing effectiveness
• Utilization rates

-- Utilization per scooter
SELECT
    scooter_id,
    AVG(EXTRACT(EPOCH FROM (end_time - start_time)) / 60) AS avg_ride_minutes,
    COUNT(*) AS rides
FROM rides
WHERE start_time >= CURRENT_DATE - 30
GROUP BY scooter_id
ORDER BY rides DESC;

Product case

Unique к kick-sharing

Weather dependence

Дождь, wind → low demand. Models должны account.

Geographic density

Downtown vs outskirts — разные patterns.

Battery management

Scooter availability ~= battery status. Operations.

Vandalism / theft

Unique problem.

Case examples

«Rides падают в городе Х»:

• Weather? Seasonal?
• Competitor moved in?
• Operational issues (fewer scooters)?
• Infrastructure changes?

«Pricing change impact»:

• Rides per scooter
• Revenue
• User retention

Supply / demand

• Where place scooters? Demand hotspots
• Rebalancing logistics
• Morning / evening commute patterns
• Event impacts (concerts, weather)

Стандартные metrics

• Rides per scooter per day (utilization)
• Revenue per ride
• Active users
• Retention (weekly, monthly)
• CR app open → ride
• Complaints / issues

Seasonality

Kick-sharing heavily seasonal:

• March-October: peak
• November-February: minimal

Analytics должны handle, avoid confusion.

Зарплаты

• Junior: 100-150k ₽
• Middle: 150-250k ₽
• Senior: 250-350k ₽

Public company — sometimes equity.

Подготовка

SQL

Middle с geo-awareness.

Geographic

Understand geo-data, heat maps, routing.

Product

Shared-mobility specifics, marketplace dynamics.

Operations

Fleet management, rebalancing.

Related sectors

Other micromobility / mobility:

• Delimobil (car-sharing)
• URent (scooter competitor)
• BelkaCar
• Yandex Drive

Transferable skills.

Связанные темы

• Собеседование в Делимобиль
• Yandex Такси
• Two-sided marketplace

FAQ

Seasonal — работа только peak?

Year-round. Off-season — planning, analysis, development.

Geo analytics background?

Plus. Можно learn.

Python geo libraries?

geopandas, folium (maps), shapely.

---

Готовьтесь — откройте тренажёр с 1500+ вопросами для собесов.