Стажер сопровождения DWH

About Bolt

Bolt is shaping a future where cities are built for people, not cars. What started as an ambitious project of a 19-year-old in 2013 has grown into a global mobility platform used by more than 200 million customers and 4.5 million driver and courier partners across 50 countries.

From ride-hailing and food delivery to scooters, e-bikes, and car-sharing, Bolt helps people move through cities every day. Small, autonomous teams drive this work, combining the speed and ownership of a startup with the scale of a global technology company backed by more than €1bn in funding.

And we're just getting started.

Why join Bolt?

• Build the future of mobility and help transform how people live and move in cities.

• Tackle challenges at scale that span technology, operations, regulation, and growth.

• Take real ownership early. Small, lean teams mean your decisions matter from day one, and you'll learn fast alongside some of the best people in the industry.

• Join one of Europe's leading technology companies, backed by world-class investors including Sequoia.
  

About the role

Our whole platform lives and breathes on data. Every step of our product development is powered by robust, scalable data infrastructure — and Analytics Engineers are the people who make that possible.

As an Analytics Engineer at Bolt, you work at the intersection of data engineering and product analytics. You own everything between data producers and data consumers: building the pipelines, models, and data products that empower analysts and decision-makers across the organisation. You're a sparring partner to our Product Analysts and a force multiplier for the teams you support.

We operate across four product verticals — Ride-Hailing, Delivery (Bolt Food and Bolt Market), Rentals (e-bikes, scooters, and carsharing), and Bolt Business — plus two horizontals: Platform and Incentives.

We have multiple open roles across these teams. Once you apply, you'll go through a universal process designed to help you learn more about Analytics Engineering at Bolt — and help us find the team that best matches your skills and ambitions.

If you believe great data infrastructure is what separates fast-moving organisations from slow ones, you'll fit right in. Scroll down to find out what it looks like day-to-day!

NB! This is a 12-month fixed-term contract covering a maternity leave.

Main tasks and responsibilities

• Work closely with product analysts and adjacent stakeholders to prioritize and align analytics engineering roadmaps, ensuring that solutions meet the long-term business needs.

• Build, expand and maintain reusable data models and metrics in dbt.

• Set up and manage the architecture, documentation, and key data transformations for in-house and third-party data.

• Improve the efficiency and impact of product analysts through data products, processes, collaboration and active knowledge-sharing.

• Develop strategic data products such as segmentation feature store or enable advanced solutions such as interactive metrics trees.

• Follow system design and architectural best practices and closely collaborate with cross-functional stakeholders to ensure data integrity and efficiency across all processes.

About you

• You hold a Bachelor and/or Master degree in Statistics, Economics, Data Science, Computer Science, Mathematics, Information Management, Business or similar studies.

• You have significant experience with data modeling, developing analytics architectures for large volumes of data and can demonstrate tangible impact in the area.

• You are proficient in SQL, Python, Spark, data modelling tools such as dbt and orchestration tools such as Apache Airflow.

• You possess excellent knowledge of system design and architectural best practices with a focus on reusability, maintainability, reliability, and scalability.

• You are a strong cross-functional collaborator with a good business sense and excellent communication skills in verbal and written English.

• Previous exposure to Business Intelligence tools such as Looker or Tableau would be an advantage.
  

Why you’ll love it here

• Accelerate your professional growth with unique career opportunities.

• Enjoy a rewarding salary and stock options, knowing that as Bolt succeeds, so do you.

• Take care of your physical and mental health with our wellness perks.

• Celebrate 5 years at Bolt with a 1-month paid sabbatical to recharge.

• Connect with colleagues at annual company events and smaller team gatherings.

• Balance flexibility and in-person collaboration with our hybrid model, including at least 12 monthly in-office days.

Some perks may differ depending on your location and role.

At Bolt, using AI daily is a baseline expectation for everyone. If there’s a faster, smarter way to do your work, we expect you to find it. You’re still responsible for the output, so the standard stays high when using AI tools.

Experience is great, but what we really look for is drive, intelligence, and integrity. So even if you don’t tick every box, please consider applying!

Everyone is welcome

Bolt is an equal opportunity employer. We are committed to building a diverse and inclusive workplace where all qualified applicants are considered for employment without regard to race, colour, nationality, religion, gender or gender identity, sexual orientation, age, or disability.

We welcome applications from all backgrounds and are happy to make reasonable accommodations throughout our hiring process. If you require any adjustments, please let us know.

Работа в Правительстве Москвы — это возможность делать наш город современнее и удобнее. Если ты тоже неравнодушен к Москве, хочешь развивать ее и развиваться сам, присоединяйся к нашей команде!

Обязанности:

• Развивать архитектуру аналитической подсистемы (слои загрузки, DWH/DDS, витрины), выбирать и обосновывать архитектурные паттерны (ETL/ELT, секционирование, шардирование), обеспечивать интеграцию с источниками и внешними системами города
• Собирать и декомпозировать требования подразделений финансового органа, переводить их в технические спецификации, проектировать модели данных и правила трансформаций, вести документацию (спецификации, карты процессов, словари данных)
• Разрабатывать и поддерживать пайплайны в Apache Airflow (DAGs на Python, кастомные операторы, сенсоры), оптимизировать SQL и PL/pgSQL в PostgreSQL, работать с платформой Полиматика (аналитические модели, витрины, отчётность), проводить кодревью, настраивать CI/CD
• Руководить группой 3–5 специалистов (аналитики, разработчики данных, инженеры DWH), распределять задачи, оценивать сроки и риски, проводить онбординг и менторство, координировать взаимодействие со смежными командами и заказчиком
• Контролировать работоспособность подсистемы, настраивать мониторинг и алертинг, управлять релизами, обеспечивать отказоустойчивость и восстанавливаемость процессов

• Опыт в IT от 7 лет в разработке данных / DWH — от 5 лет
• Опыт управления командой от 2 лет (3+ подчинённых)
• Уверенное владение PostgreSQL: SQL, PL/pgSQL, оптимизация запросов (EXPLAIN/ANALYZE), партиционирование, индексы, репликация, бэкапы
• Опыт промышленной эксплуатации Apache Airflow: DAGs на Python, переменные, пулы, ретраи, SLA, сенсоры; понимание архитектуры (Scheduler, Worker, Webserver, Metadata DB)
• Уверенный Python 3 для задач Airflow: ООП, библиотеки (psycopg2, SQLAlchemy, pandas, openpyxl), обработка исключений, логирование, тестирование (pytest), работа с API
• Опыт работы с платформой Полиматика (или с другими BI-системами, при готовности быстро погрузиться в специфику Полиматики)
• Понимание инфраструктуры: Linux, Docker, основы Kubernetes, CI/CD (GitLab CI, Teamcity)
• Навыки моделирования: BPMN, EPC, ERмоделирование, описание ASIS / TOBE
• Готовность работать с повышенными требованиями ИБ, соответствовать 152ФЗ, соблюдать регламенты госзаказчика
• Умение переключаться между стратегическим видением (архитектура), детальной проработкой (аналитика) и реализацией (код)
• Умение мотивировать команду, брать ответственность за результат, управлять конфликтами
• Будет плюсом опыт по ГОСТ 34 (автоматизированные системы), ПП РФ от 06.07.15 №676 и опыт с государственными заказчиками и крупными финансовыми системами

• Пятидневная рабочая неделя, гибридный формат работы, гибкое начало дня

• Чистый, современный, просторный офис со всей необходимой для работы орг. техникой. Находится в пешей доступности (ст. метро Авиамоторная)

• Значимая роль в команде экспертов, в которой коллеги всегда
  поддерживают друг друга

• Развивающие задачи и карьерные вызовы, реальные возможности для роста

• Развитая корпоративная культура: постоянные корпроративные обучения, мероприятия, онбординг