Senior | Architect Data Engineer (ClickHouse)

Posted 5 Hours Ago
Be an Early Applicant
2 Locations
In-Office or Remote
Senior level
Software
The Role
Designs, builds, and optimizes ClickHouse-based data infrastructure for large-scale time-series and real-time workloads. Responsibilities include developing ingestion and transformation pipelines, optimizing schemas and queries, supporting lakehouse architecture with Amazon S3, integrating Snowflake and Databricks, managing AWS BYOC deployments, troubleshooting performance and scalability issues, and owning technical decisions.
Summary Generated by Built In

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 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.

We offer

  • Freedom to Develop - equal opportunity to learn and grow professionally
  • Clear career and professional path, strong performance management system
  • Social Benefits Package
  • Equipment
  • English lesson
  • Gym membership
  • All the advantages of working in an international IT company
  • Flexible vacation time
  • Fun 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 need. Learn more about Lineate at our website: www.lineate.com

Skills Required

  • 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 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
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: New York, NY
122 Employees
Year Founded: 2005

What We Do

Lineate is a leading implementer of cloud solutions, helping AdTech and MarTech organizations scale their technology to manage vast data volumes. Our expertise in AdTech and MarTech along with our unique culture focused on knowledge breadth and creativity sets us apart in a competitive industry. With a global presence spanning seven countries, our client base is primarily in the United States and Western Europe. Why do our customers enjoy working with us? • Lineate is the market leader in developing custom software solutions for every kind of problem in the AdTech world • We are data obsessed problem solvers • We develop software that blows away the users of today... and delights the users of tomorrow • We believe in providing our engineers the freedom to develop performance and scalable software • We flourish in the complex, impossible and the “there is no way you can build that” software projects, it's our happy place Our AdTech Services: • Identity - Consent Management, Identity Graphs, Contextual Targeting • Optimization - Managing Publisher Yield and Optimizing Advertiser Performance • Insights - Real Time Reporting and Data Visualization • Data, Privacy & Security - Unification of Data Sources, Data Governance and Privacy, Risk Assessment and Fraud Detection • Cloud - Hybrid Cloud Solutions and Cloud Scalability

Similar Jobs

Remote
5 Locations
1189 Employees

Salmon Group Logo Salmon Group

Project Manager

Fintech • Financial Services
Remote
7 Locations
1189 Employees

Salmon Group Logo Salmon Group

Business Analyst

Fintech • Financial Services
Remote or Hybrid
5 Locations
1189 Employees

Welltech Logo Welltech

Senior Analytics Engineer

Healthtech • Information Technology • Software
Remote
7 Locations
726 Employees

Similar Companies Hiring

Hanover Park Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
42 Employees
Kepler  Thumbnail
Fintech • Software
New York, New York
6 Employees
Onshore Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
60 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account