Data Engineer (Middle)

Hello everyone! My name is Polina, HR manager at Twinby ❣️

TWINBY is a service for checking compatibility and finding new acquaintances. Our goal is to become the #1 dating app in Russia, replacing you-know-what. We are doing great at it: Twinby has already been downloaded by over 14 million users.

We are building a reliable platform: ingestion → DWH/views → BI/analytics → product solutions. Now we are looking for a Data Engineer to strengthen our pipelines, data quality, and storage performance.

Our stack: Python, ClickHouse, CockroachDB, DataLens, JupyterLab / DataSphere, GitLab, Airflow, AppMetrica / Metrika / GA.

Functions in the team:

• Develop and maintain ETL/ELT pipelines in Airflow;

• Design the data layer in ClickHouse: schemas, partitioning, sorting, engines (MergeTree family), deduplication, query optimization;

• Build views/layers for BI (DataLens) and analysts;

• Ensure data quality: checks, alerts, freshness/completeness control, incident analysis.

We expect from you:

• Data engineering experience from 2–4 years;

• Proficient Python for ETL: working with APIs, data processing, clean code architecture;

• Practical experience with orchestrators (we use Airflow): planning, monitoring, incidents, backfill;

• Experience with analytical data warehouses (we use ClickHouse) and understanding its features (partitions/order key, merges, TTL, FINAL, dictionaries/matviews);

• Experience building DWH/marts and layers (stg/core/mart), data catalog/lineage;

• Excellent SQL and experience in query/model optimization.

Will be a plus:

• In-depth understanding of relational DBMS and internals: indexes, execution plans, normalization/denormalization, query optimization;

• Experience in diagnosing and solving performance issues (we have CockroachDB).

We offer:

• Full-time work with a fully remote format;

• Official employment under a labor contract in the Russian Federation;

• Competitive salary;

• Corporate discounts for employees;

• Opportunities for professional development and career growth.