Собеседование аналитика в 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:
- HR screening
- SQL technical
- Product case
- 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+ вопросами для собесов.