5 дней назад
Strong Middle Data Engineer (Python/dbt)
Мэтч & Сопровод
Для мэтча с этой вакансией нужен Plus
Описание вакансии
Текст:
TL;DR
Strong Middle Data Engineer (Python/dbt): Building scalable data pipelines, domain models, and warehouse architecture for a global software product ecosystem with an accent on Airflow orchestration, dbt dimensional modeling, and data quality. Focus on optimizing warehouse performance, migrating SQL transformations, and designing initial ingestion flows for a Data Lakehouse prototype.
Location: Ukraine or Europe; hybrid work is available, with the option to work remotely or from the Kyiv coworking hub.
Company
is a Ukrainian software product company creating consumer software, cybersecurity tools, and subscription products used by millions of people worldwide.
What you will do
- Build and support Airflow pipelines integrating APIs, payment providers, ad networks, and other third-party sources with retries, backfills, and quality checks.
- Translate ambiguous business requirements into reliable data models in collaboration with Analytics Engineers and product teams.
- Design fact and dimension tables in dbt using dimensional modeling, including Kimball methodology, star schemas, snowflake schemas, and SCDs.
- Migrate SQL transformations into documented and tested dbt models while improving project structure, naming conventions, and CI checks.
- Optimize warehouse queries and materializations to reduce latency and cost.
- Evaluate table formats and build initial ingestion flows for a Data Lakehouse prototype.
Requirements
- Strong Python and advanced SQL skills, including complex transformations, window functions, and query optimization.
- Proven experience building and orchestrating ELT/ETL pipelines with Airflow.
- Solid experience with dbt for data modeling, testing, documentation, and project management.
- Practical experience with cloud data warehouses such as BigQuery, Redshift, or Snowflake, plus Cloud Storage.
- Hands-on experience with Docker, Git workflows, and basic cloud or containerized environments.
- Intermediate English and fluent Ukrainian are required. Strong stakeholder communication and the ability to handle ambiguous requirements are expected.
Nice to have
- Experience with CDC tools and patterns such as Debezium.
- Experience building large-scale data processing jobs with PySpark.
- Experience with Kafka, RabbitMQ, Flink, or Kafka Streams for real-time and stream processing.
- Experience using AI/LLM tools such as Claude to speed up delivery.
Culture & Benefits
- Remote or hybrid work with access to a Kyiv coworking hub operating around the clock and supported by UPS and Starlink.
- Flexible working hours based on trust and cooperation.
- Medical insurance from the first month, or an annual medical insurance allowance for employees abroad.
- Education opportunities, development reviews, internal communities, and feedback training.
- Personal time off, parental leave, and sabbaticals after five years.
- Support for veterans, active military personnel, mobilized employees, and humanitarian initiatives through Cares.
Будьте осторожны: если работодатель просит войти в их систему, используя iCloud/Google, прислать код/пароль, запустить код/ПО, не делайте этого - это мошенники. Обязательно жмите "Пожаловаться" или пишите в поддержку. Подробнее в гайде →