Собеседование аналитика в Аэрофлот
Карьерник — квиз-тренажёр в Telegram с 1500+ вопросами для собесов аналитика. SQL, Python, A/B, метрики. Бесплатно.
О компании
Аэрофлот — крупнейшая airline в России. Сложная industry: dynamic pricing, loyalty (Аэрофлот Бонус), route planning, revenue management.
Аналитики работают на разных направлениях: marketing (conversions на сайте), revenue management (pricing), loyalty, operations (delays).
Типы ролей
1. Marketing / digital analyst
Website / mobile app conversions, retargeting, booking funnel.
2. Revenue management analyst
Pricing, capacity, load factors.
3. Loyalty analyst
Бонус programs, partner airlines.
4. Operations analyst
Delays, on-time performance.
Процесс собеса
Typical 3-4 rounds:
- HR — opening, motivation
- Technical — SQL + maybe Python
- Case / product
- Final с руководителем
Больше структурности чем в startup, но меньше чем в ЦБ.
Стек
- SQL: Oracle, PostgreSQL, часто legacy
- Python: pandas, sklearn для pricing models
- BI: Tableau часто
- ETL: собственные tools, Airflow
SQL вопросы
Middle level. Типичные:
Задача 1
«Load factor на маршруте Москва-Сочи за Q1».
SELECT
flight_id,
DATE,
SUM(passengers) * 1.0 / SUM(capacity) AS load_factor
FROM flights
JOIN aircraft USING (aircraft_id)
WHERE origin = 'MOW' AND dest = 'AER'
AND DATE BETWEEN '2026-01-01' AND '2026-03-31'
GROUP BY flight_id, DATE;Задача 2
«Топ-5 routes по revenue в последний месяц».
SELECT origin, dest, SUM(revenue) AS total
FROM bookings
WHERE created_at >= CURRENT_DATE - 30
GROUP BY 1, 2
ORDER BY total DESC LIMIT 5;Задача 3
«Repeat buyers в loyalty program».
Window functions + date comparisons.
Case questions
1. Booking conversion падает
«Booking CR на сайте упал с 3% до 2%. Расследуй».
Framework:
- Verify (data issue?)
- Timeline (gradual / sudden?)
- Segment (desktop / mobile, routes, countries)
- Correlate с релизами, seasonality
- Recommendation
2. Pricing optimization
«Можем ли мы повысить revenue Moscow-SPb на 5%?»
Consider:
- Demand elasticity
- Load factor impact
- Competitor pricing
- Loyalty customers
3. Loyalty analysis
«Какой segment самый valuable в loyalty program?»
- RFM analysis
- LTV per segment
- Churn indicators
- Engagement metrics
Industry specifics
Unique terms
- Load factor — % мест filled
- RASK — revenue per available seat kilometer
- Yield — revenue per passenger km
- PRASM — passenger revenue per ASK
- OTP — on-time performance
- Churn of elites — уход elite status users
Seasonality
Heavy seasonal patterns. Summer peak, winter lull. YoY comparisons more reliable than MoM.
Reg policies
Международные flights affected by geopolitics.
Product thinking
Для product analyst:
- Booking funnel: search → select → payment → confirmation
- Loyalty funnel: enrol → first transaction → status achievement → retention
- Re-booking: repeat customer behavior
Soft skills
Corporate culture. Appreciate:
- Structured thinking
- Business knowledge
- Good communication
- Ownership
Не startup hustle culture.
Зарплаты
Aeroflot средне-рыночный:
- Junior: 80-130k ₽
- Middle: 150-220k ₽
- Senior: 220-320k ₽
Plus flight benefits (staff travel), corporate medical.
Как подготовиться
Industry
Read про aviation: Bloomberg airline coverage, Routes.Online, IATA publications.
SQL
Standard middle level. Задачи SQL.
Metrics
Aviation-specific: load factor, yield, RASM.
Case
Marketing funnels, loyalty analysis. Как найти причину падения.
Связанные темы
FAQ
Нужно ли aviation background?
No. Analytical skills + willingness to learn domain.
Remote?
Hybrid часто. Core team в Moscow / aerodromes.
Стабильно?
Industry cyclical. Pandemic 2020 heavy impact. Постpandemic recovery.
Готовьтесь — откройте тренажёр с 1500+ вопросами для собесов.