**Data Engineer **
PaynetEasy (Fintech)
Salary: 3000-4000** $ net **(higher is also negotiable)
Conditions: full-time employment, remote (various countries), or office/hybrid (Moscow).
About the position
We are looking for an experienced Data Engineer who will design, develop, and optimize analytical and transactional solutions based on ClickHouse and YDB. You will become part of a team responsible for data handling at scales where speed and reliability are not a wish, but a requirement.
Tasks:
- Design data schemas and write high-load SQL queries for analytical and OLTP tasks.
- Develop and maintain ETL/ELT pipelines, ensuring data quality and consistency.
- Optimize query performance: profiling, analyzing execution plans, selecting partitioning and sharding strategies in ClickHouse.
- Participate in the design of data storage architecture, choosing the appropriate engine (MergeTree, ReplacingMergeTree, etc.) for a specific task.
- Interact with the backend team to integrate the data layer with application services. Document solutions, schemas, and approaches for the team.
Requirements:
- Solid SQL skills – complex analytical queries, window functions, CTEs, subqueries.
- At least 3 years of experience with ClickHouse: understanding of columnar storage architecture, table engines, materialized views, replication and sharding configuration.
- Understanding of data schema design principles for OLAP systems. Experience with large data volumes (tens and hundreds of billions of rows).
- Query profiling and optimization skills.
- Proficient Linux user level.
Will be a plus:
- Experience with YDB – understanding of the data model, working with YQL, knowledge of distributed transactional schema design approaches.
- Experience with other DBMS: MySQL, MariaDB.
- Familiarity with data migration tools (debezium).
- Understanding of distributed systems principles and the CAP theorem.
We offer:
- Full-time employment.
- Remote, office/hybrid (Moscow).
- Flexible working hours possibility.
Contacts TG: @Dmitry_IT_Recruiter
