Собеседование аналитика в Дром
Карьерник — квиз-тренажёр в Telegram с 1500+ вопросами для собесов аналитика. SQL, Python, A/B, метрики. Бесплатно.
О компании
Drom.ru — крупнейшая auto classifieds platform в России. Two-sided: private sellers + dealers, buyers.
Процесс
- HR screening
- Technical SQL
- Product case
- Final
Стек
- PostgreSQL / ClickHouse
- Python pandas
- Tableau / Metabase
SQL раунд
Middle level. Auto industry-specific queries:
Examples
- Top brands by listings
- Average listing duration before sold
- Price distribution by segment
SELECT
brand,
COUNT(*) AS listings,
AVG(price) AS avg_price,
AVG(days_until_sold) AS avg_time_to_sell
FROM listings
WHERE listed_at >= CURRENT_DATE - 90
GROUP BY brand
ORDER BY listings DESC;Product questions
Classifieds specifics
- Listing to view funnel
- View to inquiry
- Inquiry to transaction
- Seller success (did it sell?)
Case examples
«Listing views падают в категории SUV»:
- Seasonality?
- Competitor?
- Site SEO?
- UX change?
«Как increase seller retention?»
- Offer promoted listings
- Success rate improvement
- Repeat-seller programs
Specifics
- Geographic: regional markets
- Inventory turnover: fast vs slow categories
- Dealer vs private: different behaviors
- Price dynamics: used car market
Зарплаты
- Junior: 80-130k ₽
- Middle: 140-220k ₽
- Senior: 220-320k ₽
Как подготовиться
SQL
Middle — basic classifieds queries.
Domain
Auto market basics, sales cycle.
Product
Marketplace dynamics, trust / safety.
Связанные темы
FAQ
Auto background нужен?
Plus. Не required.
Remote?
Часто hybrid.
Готовьтесь — откройте тренажёр с 1500+ вопросами для собесов.