23 апреля 2026 г.

Собеседование аналитика в Яндекс Плюс

Карьерник — квиз-тренажёр в Telegram с 1500+ вопросами для собесов аналитика. SQL, Python, A/B, метрики. Бесплатно.

О продукте

Яндекс Плюс — умber subscription. Access к Music, Kinopoisk, Еде discount, drive-sharing, Еlite delivery, и более.

Positioning: бonus для пользователей всех Yandex сервисов.

Аналитика здесь — subscription + multi-product integration.

Процесс

Typical Yandex 4-round:

HR screening
Technical SQL
Product case
Final interview

Стек

ClickHouse
Python, pandas
DataLens
Experimentation platform

SQL

Yandex standard: strong middle-senior.

Типичные questions

Cohort retention subscription
Churn analysis
Cross-product engagement
Funnel from free → paid

Example

«Cohort retention для Yandex Plus subscribers».

WITH cohorts AS (
    SELECT user_id, DATE_TRUNC('month', subscription_started_at) AS cohort_month
    FROM subscriptions
    WHERE plan = 'plus'
),
activity AS (
    SELECT DISTINCT user_id, DATE_TRUNC('month', billing_date) AS active_month
    FROM payments
    WHERE plan = 'plus'
)
SELECT
    c.cohort_month,
    a.active_month,
    COUNT(DISTINCT a.user_id) AS active,
    (SELECT COUNT(*) FROM cohorts WHERE cohort_month = c.cohort_month) AS cohort_size
FROM cohorts c
JOIN activity a USING (user_id)
GROUP BY c.cohort_month, a.active_month
ORDER BY c.cohort_month, a.active_month;

Product questions

Subscription mechanics

Monthly vs annual
Free trial
Gifting
Family plans
Renewal mechanisms

Все имеют аналитические implications.

Multi-product integration

Plus value — access к многим продуктам.

Question: how measure cross-product engagement?

Metrics:

Products used per user
Breadth engagement
Which products drive retention

Churn

Pre-subscription signals
Cancellation reasons
Win-back campaigns

Case questions

«Plus users churning при annual renewal. Why?»

Framework:

Time-based patterns
Product engagement декline
Pricing perception
Competitor offers

«Launched new feature (free access Kinopoisk premium). Impact на Plus adoption?»

Metrics:

Adoption rate
Cross-sell impact
Churn reduction

Behavioral

Yandex культура принципы:

Ownership
Ship fast
Data-driven
Initiative

STAR stories соответствующие.

Зарплаты

Junior: 130-180k ₽
Middle: 200-300k ₽
Senior: 300-450k ₽

Plus standard Yandex benefits.

Подготовка

SQL

Window functions
Subscription SQL (guide)
Cohorts (guide)

Product

Subscription economics
Multi-product bundling
Freemium dynamics

Statistics

A/B для subscription products: long-term metrics, churn rate testing.

Related Yandex Family

Yandex Music analytics
Kinopoisk analytics
Yandex Cloud

Crossover career paths.

FAQ

Music / Video / Food — separate?

Different teams, но под Plus umbrella.

Russian only?

Partial international (Belarus, Kazakhstan etc.).

Домен знание?

Consumer subscription familiarity helps.

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

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

Тренироваться в Telegram