Software Engineer - Data Integrations

Position Overview

ClickHouse is seeking a Software Engineer specializing in data connectors and transformation frameworks to join the Integrations team. This role is responsible for the technical ownership of ClickHouse's critical data pipeline integrations, bridging high-performance database engineering with modern data orchestration. You will build and maintain connectors and adapters that enable data teams to seamlessly incorporate ClickHouse into their existing workflows.

About the Team

The Integrations team is dedicated to connecting ClickHouse with the broader data ecosystem. We develop and maintain connections, ranging from low-level database drivers to high-level data visualization plugins, ensuring ClickHouse integrates with popular tools. Our responsibilities include official language clients (Python, JavaScript, Java, Go, Rust, C++), major data connectors (Kafka, dbt, Spark, Fivetran), and integrations with visualization platforms (Grafana, Tableau, PowerBI, Metabase).

Responsibilities

• Technical Ownership: Serve as the technical owner for ClickHouse's most critical data pipeline integrations.
• dbt Adapter Development: Own the development and maintenance of the dbt-clickhouse adapter, enabling data analysts and engineers to leverage dbt's transformation capabilities with ClickHouse.
• Data Ingestion Connectors: Maintain and enhance data ingestion connectors in JVM and golang ecosystems, ensuring reliable and performant automated data replication from diverse sources into ClickHouse.
• Architecture: Architect data infrastructure that supports companies in building real-time analytics platforms and modern data warehouses at scale.
• Collaboration: Collaborate with commercial partners and the broader data community to ensure integrations represent best practices in the modern data stack.

Requirements

• Experience: 5+ years of software development experience with a focus on data engineering, ETL/ELT pipelines, or database integrations.
• Python: Strong Python proficiency with experience in data-focused libraries (Pandas, SQLAlchemy) and familiarity with the Python data ecosystem.
• dbt: Hands-on experience with dbt, ideally including custom adapter development, advanced dbt modeling patterns, or contributions to dbt packages.
• Modern Data Stack: Experience with modern data stack tools such as Fivetran, Airbyte, or similar ELT platforms.
• Java: Solid Java development skills, including understanding of JVM performance tuning and concurrent programming patterns.
• Database Fundamentals: Strong understanding of database fundamentals, including SQL, data modeling, query optimization, and familiarity with OLAP/analytical databases.
• Communication: Outstanding written and verbal communication skills for effective collaboration.
• Open-Source Passion: A passion for open-source development, including community engagement and contributing to the evolution of core systems.

Bonus Points For

• Familiarity with ClickHouse or similar high-performance data platforms.
• Prior contributions to open-source projects.
• Expertise in building sinks or source connectors for big data frameworks.
• Golang knowledge for high-performance data processing components.

Company Information

About ClickHouse: Established in 2009, ClickHouse is a leader in open-source column-oriented database systems, aiming to be the fastest OLAP database globally. We empower users to generate real-time analytical reports via SQL queries, focusing on speed for escalating data volumes. ClickHouse Cloud is utilized by global enterprises including Lyft, Sony, IBM, GitLab, Twilio, and HubSpot. It is available as open-source or on AWS, GCP, Azure, and Alibaba.

Salary Ranges

• New York Area / San Francisco Area: $157,000 - $232,000 USD
• Washington State: $141,300 - $197,200 USD
• General US Remote: $125,600 - $185,500 USD
• Los Angeles, CA / Washington, DC: $141,300 - $208,800 USD

Employment Type:

• [Employment Type will be specified here]

Location Type:

• [Location Type will be specified here]