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

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

О компании

YCLIENTS — leading SaaS для beauty, wellness, fitness бizness (salons, parikhmakerskie, spa). 60 000+ customers.

Analytics команды work над: customer retention (SaaS churn), product usage, sales optimization.

Процесс

3-4 rounds:

  1. HR screening
  2. SQL technical
  3. Product case
  4. Final

Стек

  • PostgreSQL
  • Python pandas
  • Tableau / Metabase
  • Airflow

SQL

Middle. B2B SaaS metrics:

  • Customer cohorts
  • Feature adoption
  • Payment analysis
  • Retention/churn

Example

«Customers who churned в January — their last month activity patterns»:

WITH churned AS (
    SELECT customer_id, cancelled_at
    FROM subscriptions
    WHERE cancelled_at BETWEEN '2026-01-01' AND '2026-01-31'
)
SELECT
    c.customer_id,
    COUNT(DISTINCT DATE(event_date)) AS active_days_last_month,
    COUNT(*) AS actions_last_month
FROM churned c
JOIN events e ON e.customer_id = c.customer_id
    AND e.event_date BETWEEN c.cancelled_at - INTERVAL '30 days' AND c.cancelled_at
GROUP BY c.customer_id
ORDER BY active_days_last_month;

Product questions

B2B SaaS specifics

  • Onboarding: crucial для B2B
  • Feature adoption: which correlate retention
  • CS touchpoints: Customer Success relations
  • Expansion: up-sell, add seats

Industry specifics

Beauty industry:

  • Small businesses (1-10 employees)
  • Price-sensitive
  • Professional user (salon owner, administrator)
  • Seasonal (weddings, holidays)

Case

«Churn вырос у salon category»:

  • New competitor?
  • Pricing change?
  • Feature issues?
  • Economic pressures?

Metrics

  • MRR
  • Logo retention (% customers retained)
  • Net revenue retention (including expansion)
  • ARPU per customer
  • Activation (first booking made)
  • Feature adoption rates

Зарплаты

Mid-market SaaS:

  • Junior: 90-140k ₽
  • Middle: 150-220k ₽
  • Senior: 220-320k ₽

Как подготовиться

SQL

Middle. B2B SaaS patterns.

Domain

Understand small business / wellness industry.

Product

SaaS onboarding, CS, expansion. Subscription SQL.

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

FAQ

B2B опыт?

Plus. Можно learn.

Remote?

Partial remote.

ML?

Not heavy ML focus.


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