Senior ClickHouse Data Architect, AWS Lakehouse

Careers at Lineate; Georgia; On-site; USD 140,000 - 180,000; Full time

Benefits offered by this job

Freedom to Develop

Career path and performance management

Social benefits package

Equipment

English lessons

Gym membership

International IT environment

Flexible vacation time

In-person and digital events

Job summary

Lineate is seeking a senior Data Engineer / ClickHouse Engineer to design, build, and optimize high-performance data infrastructure for large-scale time-series and real-time workloads in a lakehouse environment. The role emphasizes hands-on ClickHouse work and strong AWS experience.

You will own data ingestion pipelines, schema optimization, and real-time query serving, collaborating with Snowflake/Databricks integrations and BYOC on AWS. Excellent communication is essential.

Qualifications

• 6+ years of Data Engineering experience.
• Strong production-level ClickHouse experience.
• Deep knowledge of ClickHouse data modeling, table engines, partitioning, ordering, materialized views, aggregations, and query optimization.
• Strong hands-on AWS experience, particularly with Amazon S3.
• Experience with lakehouse-style architectures and object storage as the primary data layer.
• Experience with large-scale time-series data and real-time analytics.
• Strong performance-tuning and troubleshooting skills.
• Ability to work independently and take technical ownership.
• Strong communication and stakeholder-management skills.

Responsibilities

• Design, implement, and optimize ClickHouse for large-scale analytical and time-series workloads.
• Build and maintain data ingestion and transformation pipelines.
• Optimize ClickHouse schemas, partitioning, materialized views, aggregations, and queries.
• Support real-time and near-real-time query serving, ensuring performance and reliability.
• Work with a lakehouse architecture, using Amazon S3 as the source of truth.
• Integrate ClickHouse with Snowflake, Databricks, and other components of the data ecosystem.
• Support ClickHouse infrastructure and BYOC deployments on AWS.
• Troubleshoot data ingestion, storage, scalability, and performance issues.
• Own technical decisions and communicate solutions and trade-offs to stakeholders.

Skills

ClickHouse

AWS

Time-series

Data modeling

Lakehouse

Performance tuning

Independent worker

Stakeholder comms

Tools

Snowflake

Databricks

BYOC on AWS

Job description

Lineate is seeking a senior Data Engineer / ClickHouse Engineer to design, build, and optimize high-performance data infrastructure for large-scale time-series and real-time workloads in a lakehouse environment. The role emphasizes hands-on ClickHouse work and strong AWS experience.

You will own data ingestion pipelines, schema optimization, and real-time query serving, collaborating with Snowflake/Databricks integrations and BYOC on AWS. Excellent communication is essential.