ClickHouse Data Engineer

Role Overview:

This role focuses on developing and maintaining ClickHouse-based solutions for large-scale data analytics and reporting. Key responsibilities include designing efficient database schemas, optimizing complex SQL queries, and building robust data ingestion pipelines. The individual will also be responsible for monitoring ClickHouse performance, implementing OLAP data modeling best practices, and ensuring data quality and integrity across systems. Collaboration with data engineers, analysts, and business teams is essential to translate requirements into effective technical solutions, alongside supporting the deployment and maintenance of ClickHouse clusters.

Key Responsibilities:

• Develop and maintain ClickHouse-based solutions for large-scale data analytics and reporting
• Design efficient database schemas, tables, and partitioning strategies to support high-performance queries
• Write and optimize complex SQL queries for fast data retrieval and analytical workloads
• Build and manage data ingestion pipelines using tools such as Kafka, Spark, or ETL frameworks
• Monitor and troubleshoot ClickHouse performance issues, including slow queries and data inconsistencies
• Implement data modeling best practices for OLAP systems and columnar databases
• Collaborate with data engineers, analysts, and business teams to translate requirements into technical solutions
• Ensure data quality, integrity, and validation across systems
• Support deployment and maintenance of ClickHouse clusters, including scaling and upgrades

Required Skills:

• ClickHouse
• SQL query development and optimization
• Database schema design, partitioning, and performance tuning
• Data ingestion tools (Kafka, Spark, ETL frameworks)
• OLAP data modeling and columnar database design
• Performance monitoring and troubleshooting
• Data quality, validation, and integrity
• Collaboration with cross-functional data teams
• ClickHouse cluster deployment, scaling, and maintenance

Qualifications:

• 6-8 years of experience

Preferred Skills:

• Apache Spark
• Kafka