Собеседование на аналитика marketplace
Карьерник — квиз-тренажёр в Telegram с 1500+ вопросами для собесов аналитика. SQL, Python, A/B, метрики. Бесплатно.
Зачем это знать
Marketplaces — топ работодатели для analytics в России. Wildberries, Ozon, Avito, СберМаркет, Лента, X5. Specific analytics — two-sided, seller и buyer сторонки параллельно. Specific challenges: supply/demand balance, ranking, take-rate optimization.
Кто нанимает
Wildberries
Ведущая в E-commerce. Big on speed, scale.
Ozon
Tech-savvy. Many analytics roles.
Avito
Classifieds + ads. Two-sided dominant.
СберМаркет / Купер
Food delivery marketplace.
Яндекс.Маркет
Yandex-owned. Different culture.
Все нанимают 100+ analysts каждый.
Two-sided specifics
Buyer side
- Conversion
- AOV
- Repeat rate
- Browse-to-buy
Seller side
- Seller acquisition
- Take rate (commission)
- Seller retention
- Fulfillment quality
Marketplace overall
- Liquidity (matches)
- GMV
- Take rate × GMV = revenue
- Fill rate
Интервью questions
SQL (middle-hard)
Ozon / WB — сильные SQL. Yandex.Market — especially.
Examples:
- Top products by conversion rate per category
- Seller retention cohort analysis
- Return rate anomaly detection
Case questions
1. Seller churn
«30% sellers leave within 3 months. Что делать?»
- Segment by size
- Reasons analysis
- Interventions
2. Category launch
«Want to enter new vertical. How measure success?»
- Buyer attraction
- Seller onboarding
- Revenue ramp
- Comparison existing categories
3. Search quality
«Click through rate на search results упал. Почему?»
- Algorithm change?
- New sellers mix?
- Query intent changes?
Product thinking
«Build metric для search quality». Answer:
- CTR
- Add-to-cart
- Conversion after search
- Zero-result queries
- Session-level satisfaction
Типичные метрики marketplace
- GMV (gross merchandise value)
- Take rate (commission %)
- CR (conversion rate)
- AOV (average order value)
- Retention (both sides)
- Fill rate (inventory)
- NPS (both sides)
- CAC (both sides)
- LTV / CAC ratio
Industry challenges
Supply-demand balance
Too many sellers → commoditization. Too few → poor selection. Analytics guides balancing.
Fraud
Counterfeit products, review manipulation.
Logistics
Delivery times, return rates.
Category differentiation
Some verticals (electronics) vs (fashion) have very different dynamics.
Стек tools
SQL
- ClickHouse (WB, Ozon, Avito)
- PostgreSQL
- Vertica (Ozon частично)
Python
- pandas, numpy
- PySpark для big analyses
BI
- Tableau / DataLens / Metabase
- Часто internal tools
A/B
- Собственные platforms
- Amplitude / Mixpanel rare
Зарплаты
Top markets:
- Junior: 100-170k ₽
- Middle: 180-320k ₽
- Senior: 320-500k ₽
- Lead: 500-800k ₽
Yandex.Market / Ozon (tech culture) — upper range.
Как подготовиться
SQL
Strong middle → senior level. Window functions, optimization.
Product
Marketplace dynamics: two-sided, supply / demand.
Statistics + A/B
Experimentation scale — important.
Domain
Read blogs:
- Ozon Tech blog
- VK Tech (Avito)
- Product posts от Wildberries
Связанные темы
- Собеседование в WB
- Собеседование в Ozon
- Собеседование в Avito
- Собеседование в СберМаркет
- Собеседование в Yandex.Market
FAQ
Ecommerce опыт обязателен?
Нет. Analytical skills переносимы.
Remote?
Зависит от company. Many allow.
Best для начала?
WB, Ozon — scale, много roles. Yandex.Market — top culture но harder entry.
Готовьтесь — откройте тренажёр с 1500+ вопросами для собесов.