Как готовиться к собесу на senior

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

Зачем это знать

Middle → senior переход — big step. Зарплата +30-50%. Но требования — не просто more SQL. Качественно другое mindset.

На собесах на senior разница с middle четко видна. Prepared иначе.

Что ожидают

Middle

  • Strong SQL, Python, A/B basics
  • Execute assigned projects well
  • Communication ок
  • Some product thinking

Senior

  • Deep technical across 2+ areas
  • Own ambiguous projects
  • Drive decisions без много guidance
  • Mentor others
  • Business strategy connect

Lead

  • Team leadership
  • Roadmap ownership
  • Influence exec
  • Cross-functional alignment

Технические различия

SQL

Middle: can solve window function problems. Senior: knows when to use windows vs self-join, optimization trade-offs, advanced patterns (gaps & islands, recursive).

Statistics

Middle: t-test, p-value. Senior: power analysis, variance reduction (CUPED), network effects, causal methods.

Product

Middle: track KPIs. Senior: design metric hierarchy, challenge business assumptions, connect к growth strategy.

Experimentation

Middle: run A/B tests. Senior: design experimental frameworks, handle sequential / multiple testing / peeking.

На собесе: differences

Coding

Middle: correct solution. Senior: correct + optimized + explain trade-offs.

«Напиши SQL к этой задаче.» → senior: «2 подхода. Этот — readable. Этот — performant. Выберу based on expected data volume».

Case

Middle: answer question. Senior: frame problem, challenge premises.

«CR упал. Why?»

Middle: Walk through framework (scope, timeline, segments).

Senior: «CR определения matters. Для какого CR? Session → signup? Signup → paid? Разные questions. Давайте clarify, потом I'll walk through framework».

Behavioral

Middle: «I did X». Senior: «I led X, here's the strategy, here's trade-offs, here's what I learned».

Leadership evident.

Углублённые темы

Product strategy

Beyond metrics:

  • Market dynamics
  • Competitive positioning
  • Monetization models
  • Expansion / contraction strategies

Experimentation infrastructure

Not just run. Design platforms:

  • Statistical foundations
  • Stratification / CUPED
  • Holdouts
  • Cluster-randomized for network effects

Data infrastructure

Not just use DWH. Understand:

  • dbt modeling
  • Orchestration (Airflow)
  • Cost optimization
  • Data quality systems

Leadership

Without formal title:

  • Mentoring
  • Leading projects
  • Influencing decisions
  • Hiring (sometimes interviewing junior)

Подготовка

Review senior concepts

  • Advanced experimentation
  • Causal inference
  • Metric design
  • Product strategy frameworks

Case studies

Business strategy cases, не just «CR упал».

«How would you evaluate акquisition of competitor?» «Pricing change strategy» «New market entry»

Leadership stories

Prepared STAR stories:

  • Led без authority
  • Stakeholder disagreement resolved
  • Strategic project
  • Mentored others
  • Failed project lesson

Technical depth

One area — deep expertise. Show mastery.

«I'm expert в ML / A/B / data modeling». Have conviction.

Typical senior interview

4-5 rounds

  1. Recruiter
  2. Technical (SQL + Python)
  3. Product case
  4. Experimentation / stats deep
  5. Behavioral
  6. Maybe exec / cross-functional

Each round

Expect deeper probing:

  • Follow-up questions
  • «What if X?»
  • «Trade-offs?»
  • «How to scale?»

Portfolio / track record

Impact stories

At senior — track record matters.

Prepare 3-5 cases showing:

  • Strategic project
  • Ownership end-to-end
  • Business impact quantified
  • Cross-functional work

Resume

Senior resume:

  • Results over responsibilities
  • Leadership moments
  • Quantified impact

Зарплата

Russian market

  • Middle: 150-250k ₽
  • Senior: 250-400k ₽
  • Lead: 400-600k ₽
  • Head: 600k-1M+ ₽

Big tech — upper range.

Negotiation

Stronger than middle. Multiple offers leverage normal.

Red flags от senior candidate

  • No clear past ownership
  • Can't describe trade-offs
  • Superficial product thinking
  • No mentorship examples
  • Gets defensive критику

Green flags

  • Clear опыт leading projects
  • Communicates trade-offs
  • Product strategy thinking
  • Mentors others
  • Grows from feedback

Рекомендации

Read

  • «Inspired» (Marty Cagan)
  • «Trustworthy Online Controlled Experiments»
  • Reforge content
  • Lenny's newsletter
  • Stratechery

Practice

Strategic cases — different от technical SQL.

Network

Talk к senior аналитикам. Learn what they do day-to-day.

Own projects

Take on something ambiguous, impactful. Even если formally «middle».

На собесе

Demonstrate seniority

  • Clarify before solve
  • Verbalize trade-offs
  • Connect к business
  • Show structured thinking
  • Ask insightful questions

Не бойтесь

Say «I don't know, but here's how I'd approach finding out».

Senior не expected знать всё. Expected to figure out.

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

FAQ

Сколько опыта нужно?

3-5 years обычно. Качество > длина.

Middle → Senior в текущей компании?

Often easier. Build impact, ask promotion.

Без leadership опыта?

Hard. Find stretch opportunities даже unofficially.


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