➡️ Apply here: Data Engineer (ClickHouse)
👩💼 Want to stand out? Improve your resume to appeal to recruiters, hiring managers, and Applicant Tracking Systems. ➡️ Improve your resume
**Job Title:** Data Engineer (ClickHouse) with relocation to Cyprus
**Company:** CoreStar
**Location:** Tbilisi, Georgia
**Job Description:**
CoreStar is seeking a Data Engineer with expertise in ClickHouse to join their dynamic technology company. The role involves working on a high-load in-house platform that handles multiple third-party integrations, data collection, and comprehensive reporting systems. The platform processes large volumes of real-time data and requires high availability with performance optimization.
**Key Responsibilities:**
* Design and maintain scalable ETL/ELT pipelines.
* Handle Change Data Capture (CDC) ingestion from Amazon RDS (MySQL) via Debezium + Kafka.
* Load and optimize high-throughput data flows into ClickHouse.
* Tune ingestion in ClickHouse, including partitioning, TTLs, and ORDER BY keys.
* Utilize Parquet/ORC and partitioning for efficient storage in S3.
* Integrate datasets for BI purposes.
* Implement monitoring and alerting for data pipelines.
* Use Git + CI/CD and manage infrastructure with Terraform or AWS CDK.
**Requirements:**
* Proven experience building high-throughput data ingestion pipelines.
* Proficiency with Kafka/MSK and Debezium or ClickPipes.
* Experience with ClickHouse and Data Warehouse concepts and architecture.
* Proficiency in SQL, Git, and CI/CD.
* Experience with Infrastructure-as-Code, specifically Terraform.
**Nice to Have:**
* Experience with AWS Glue and Airflow.
* Experience with dbt.
* Familiarity with MySQL binlog-based CDC.
* BI reporting knowledge.
* Experience monitoring and tuning ClickHouse queries.
* Experience with NodeJS.
**Benefits:**
* 24 working days of paid annual leave.
* 6 days of paid sick leave.
* Official employment.
* Medical insurance.
* Coffee zone with fruit & snacks in the office.
* Corporate Lunch provided by the company.
* Gym and sports classes.
* Healthy and friendly work atmosphere.