Data Engineer (Fintech)
PaynetEasy (Fintech)
Salary: 3000-4000 $ net (higher is also negotiable)
Conditions: full-time, remote (various countries), or office/hybrid (Moscow).
About the position
We are looking for an experienced SQL developer to design, develop, and optimize analytical and transactional solutions based on ClickHouse and YDB. You will be part of a team responsible for data handling at scales where speed and reliability are not a preference, 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, execution plan analysis, selecting partitioning and sharding strategies in ClickHouse.
- Participate in the design of data storage architecture, choosing the appropriate engine (MergeTree, ReplacingMergeTree, etc.) for the specific task.
- Interact with the backend team to integrate the data layer with application services. Document solutions, schemas, and approaches for the team.
Requirements:
- Confident SQL proficiency – complex analytical queries, window functions, CTE, 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.
- Familiarity with Linux at a confident user level.
Will be a plus:
- Experience with YDB – understanding of 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 CAP theorem.
We offer:
- Full-time employment.
- Remote, office/hybrid (Moscow).
- Flexible working hours option.
CONTACT
t.me/Dmitry_IT_Recruiter
