Description
You will build and maintain ClickHouse-based solutions for large-scale data analytics and reporting.
This role is on-site.
Responsibilities
- Design efficient database schemas, tables, and partitioning strategies for high-performance queries.
- Write and optimize complex SQL queries for fast data retrieval and analytical workloads.
- Build and manage data ingestion pipelines using Kafka, Spark, or ETL frameworks.
- Monitor and troubleshoot ClickHouse performance issues, including slow queries and data inconsistencies.
- Support deployment, scaling, and maintenance of ClickHouse clusters.
Required Skills
- 8+ years of experience in data engineering.
- Expertise in ClickHouse SQL query development and optimization.
- Strong background in OLAP data modeling and columnar database design.
- Proficiency in database schema design, partitioning, and performance tuning.
- Hands-on experience with data ingestion tools like Kafka, Spark, and ETL frameworks.
- Ability to perform performance monitoring and troubleshooting.
- Focus on data quality, validation, and integrity.
Preferred Skills
- Bachelor's degree in a relevant technical field.