data engineer for real-time analytics

Lineate is a US-based international software development company with over two decades of experience. It delivers AI-driven custom solutions, cloud and data infrastructure, and team augmentation services for FinTech, HealthTech, AdTech, and other industries.

• 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 data ecosystem components;
• 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;
• 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.

• Equal opportunity to learn and grow professionally;
• Clear career and professional path and strong performance management system;
• Social Benefits Package;
• Equipment;
• English lesson;
• Gym membership;
• Flexible vacation time;
• Fun and inclusive in-person and digital events.