Data Engineer (ClickHouse)

About Lineate 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. Role Overview 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. Key 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 clearly communicate solutions and trade-offs to stakeholders. Requirements Must-have 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.Nice-to-have ClickHouse certificationExperience 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. We offer Freedom to Develop - equal opportunity to learn and grow professionallyClear career and professional path, strong performance management systemSocial Benefits PackageEquipmentEnglish lessonGym membershipAll the advantages of working in an international IT companyFlexible vacation timeFun and inclusive in-person and digital events Lineate is proud to be an Equal Opportunity Employer - We do not hire on the basis of race, colour, religion, creed, gender, national origin, citizenship, age, disability, veteran status, marital status, pregnancy, parental status, sex, gender expression or identity, sexual orientation, or any other basis protected by Georgian legislation. All employment is decided based on qualifications, merit, and business ne ed.Learn more about Lineate at our website: www.lineate. com