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.
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
Similar Jobs
Fitness • Healthtech
Design and optimize onboarding, value propositions, and personalized coaching experiences for a consumer health app. The role focuses on UX/UI design, conversion rate optimization, monetization, user psychology, growth funnels, and turning free users into paying customers through data-informed product decisions.
Top Skills:
Data AnalyticsMobile App Product DesignUx ResearchWeb-Based Conversion Rate Optimization
Fitness • Healthtech
Operate and improve AWS infrastructure, Kubernetes platforms, infrastructure-as-code, CI/CD, observability, and internal tooling. Participate in on-call rotations, investigate and resolve complex production incidents, automate recurring operational work using Go, and collaborate across engineering, product, and security teams. The role requires hands-on ownership of production systems, structured debugging, rapid learning, and strong technical communication.
Top Skills:
Amazon EksArgocdAtlantisAWSCi/CdCiliumGitopsGoGrafanaInfrastructure As CodeIstioKarpenterKubernetesLokiPrometheusTempoTerraformTerramate
Healthtech • Professional Services • Software
Design marketing and sales assets (social creatives, ads, banners, lead magnets, one-pagers, event/webinar visuals), update sales enablement (decks, proposals, case studies), support website/landing visuals and simple UI blocks, build and maintain a lightweight brand system, and collaborate with copywriters and marketers to create clear, conversion-focused visual hierarchies.
Top Skills:
Adobe IllustratorAdobe IndesignAdobe PhotoshopFigma
What you need to know about the Austin Tech Scene
Austin has a diverse and thriving tech ecosystem thanks to home-grown companies like Dell and major campuses for IBM, AMD and Apple. The state’s flagship university, the University of Texas at Austin, is known for its engineering school, and the city is known for its annual South by Southwest tech and media conference. Austin’s tech scene spans many verticals, but it’s particularly known for hardware, including semiconductors, as well as AI, biotechnology and cloud computing. And its food and music scene, low taxes and favorable climate has made the city a destination for tech workers from across the country.
Key Facts About Austin Tech
- Number of Tech Workers: 180,500; 13.7% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Dell, IBM, AMD, Apple, Alphabet
- Key Industries: Artificial intelligence, hardware, cloud computing, software, healthtech
- Funding Landscape: $4.5 billion in VC funding in 2024 (Pitchbook)
- Notable Investors: Live Oak Ventures, Austin Ventures, Hinge Capital, Gigafund, KdT Ventures, Next Coast Ventures, Silverton Partners
- Research Centers and Universities: University of Texas, Southwestern University, Texas State University, Center for Complex Quantum Systems, Oden Institute for Computational Engineering and Sciences, Texas Advanced Computing Center
