Senior | Architect Data Engineer (ClickHouse)

Lineate is a US-based international software development company with over two decades of experience.

From Intelligent Document Processing(IDP) and Agentic RAG systems to scalable cloud architectures, we turn complex ideas into real, measurable results.

We deliver AI-driven custom solutions for FinTech, HealthTech, AdTech, and beyond, empowering businesses to grow smarter, faster, and more efficiently.

Our expertise falls into three main categories:

• Building Custom AI Solutions: Deploying high-impact, AI-enabled technology utilizing IDP, Agentic RAG.
• Cloud and Data Infrastructure: Optimizing business operations with our data management and cloud computing solutions.
• Team Augmentation: Providing specialized experts in FinTech, AdTech, and HealthTech to integrate seamlessly and accelerate project timelines.
• Our goal is not just to build technology, but to build the future operating model for our clients.

We are looking for a senior Data Engineer / ClickHouse Engineer with deep hands-on expertise in ClickHouse and AWS. The role focuses on building and optimizing high-performance data infrastructure for large-scale time-series and real-time workloads in a lakehouse environment.

• →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 clearly communicate solutions and trade-offs to stakeholders.

• 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 or near-real-time analytics.
• Strong performance-tuning and troubleshooting skills.
• Ability to work independently and take technical ownership.
• Strong communication and stakeholder-management skills.

• ClickHouse certification
• Experience with BYOC on AWS.
• Experience with Snowflake and/or Databricks integrations.
• Background working with high-volume financial, transactional, telemetry, or similar datasets.
• Experience delivering complex data solutions in enterprise environments.