Собеседование аналитика в Auto.ru
Карьерник — квиз-тренажёр в Telegram с 1500+ вопросами для собесов аналитика. SQL, Python, A/B, метрики. Бесплатно.
О компании
Auto.ru — крупнейший в России auto classified, часть Yandex (перешёл в 2014). Buyer + seller marketplace.
Culture — Yandex. Стек — Yandex.
Процесс
Typical Yandex-style 4-5 rounds:
- HR screening
- SQL technical
- Product case
- Behavioral / team fit
- Final
Стек
- ClickHouse heavily
- Yandex Table (YT)
- Python, pandas
- DataLens
- Airflow / Nirvana (internal)
SQL
Yandex — strong SQL. Middle-senior expected:
- Window functions fluently
- ClickHouse peculiarities (arrays, sampling)
- Optimization
Example
«Средняя длительность listing (от publish to sold) по brand в последнем месяце».
SELECT
brand,
AVG(dateDiff('day', published_at, sold_at)) AS avg_days,
COUNT(*) AS listings
FROM listings
WHERE sold_at IS NOT NULL
AND published_at >= now() - INTERVAL 30 DAY
GROUP BY brand
ORDER BY listings DESC;Product case
Classifieds dynamics
Two-sided: private sellers + dealers + buyers.
Metrics:
- Listing quality (photos, price accuracy)
- Engagement (views, calls, messages)
- Transaction: sold rate
- Seller satisfaction
Case example
«Dealer activity упала»:
- New competitor?
- Price increases?
- Algorithm change ranking?
- Economic factors (sales cycle)?
Auto-specific
- Seasonality (buying spring, selling fall)
- Regional differences
- New car vs used
- Price dynamics (inflation, exchange rates)
Behavioral
Yandex principles:
- Initiative
- Ownership
- Ship fast
- Data-driven
Stories showing these.
Зарплаты
Yandex standard:
- Junior: 130-180k ₽
- Middle: 200-300k ₽
- Senior: 300-450k ₽
Plus Yandex benefits.
Подготовка
SQL
Strong Yandex SQL — ClickHouse, optimization.
Product
Classifieds dynamics, marketplaces.
Behavioral
Yandex-style: initiative-driven stories.
Связанные темы
FAQ
Yandex other — same процесс?
Similar, но culture / team-specific variations.
ClickHouse обязательно?
Да, heavy use.
Auto опыт?
Plus, но не обязателен.
Готовьтесь — откройте тренажёр с 1500+ вопросами для собесов.