Software Engineer- C++/ClickHouse

About Tinybird:
At Tinybird, we help developers and data teams take flight by unlocking the power of real-time data to quickly build data pipelines and innovative data products. With Tinybird, you can effortlessly ingest multiple data sources at scale, query and shape it using the 100% pure SQL you already know and love, and publish results as low-latency, high-concurrency APIs for your applications to chirp about. Developers can create fast APIs, faster—what used to take hours and days now only takes minutes! Tinybird is the essential tool that data engineers and software developers have been waiting for enabling you to drive innovation with ease.

What are we looking for?
We are looking for someone who wants to contribute to Open Source as a full time job. In particular, someone that wants to contribute to ClickHouse, the database on which Tinybird is built. The Open Source landscape is evolving quickly, with many prominent companies re-evaluating the licenses of their products to safeguard against market monopolization. Despite these shifts, we remain steadfast in our belief that Open Source is a powerful force for good. After all, it’s the foundation of our professional journeys. Our goal is to enhance ClickHouse, not only to meet our own needs but also to give back to the community. We are committed to ensuring that ClickHouse remains the fastest database for years to come. Join us in this exciting endeavor!

About you::
• You have C++ experience, and you are already working with/contributing to ClickHouse, or
• You have C++ experience in another type of product but are keen to become a ClickHouse internals expert
• You are an experienced programmer (in C++ or other), and have a deep understanding of how databases work internally.
Bonus Points:
• You are fluent in English. If you speak Spanish, Russian, or Mandarin also, that would be amazing and it would make us all wonder what we have done with our lives.
• You communicate well in writing. This is important not only because we favor asynchronous work but also because you will have to write documentation, guides, and the occasional blog post.
• Ideally, someone who participate as part of the oncall team, to understand not only our product, but also the issues our clients face.
• Ideally, you are located somewhere in Europe, or at least not too many time zones away. This is not essential but would certainly make it easier, as, for now, our engineering team is entirely in the CET timezone.

What will you do?:
• At our company, everyone is an integral part of the product team. While your primary focus will be on ClickHouse, your daily priorities will be shaped by our product goals.
• Your day might involve tackling critical ClickHouse bugs that impact our customers or developing exciting new features. You'll also collaborate with team members to find optimal solutions for various ClickHouse challenges. For example, our past contributions include:

• Made JOINs 100x faster
• Added JOIN support to parallel replicas
• Fixing the argument priority on lambda functions.
• Many performance improvements.
• Multiple Pull Requests to improve how ClickHouse handles query limits and KILL requests (#2667, #31636, and #32271).
Others:
• Context lock contention fix
• MergeTree FINAL extract non intersecting parts ranges
• Analyzer support recursive CTEs

We engage in daily discussions about the product, balancing immediate challenges with long-term vision. Your insights into ClickHouse’s internals will be invaluable in shaping our strategies and decisions. Our design philosophy involves working backward: someone proposes a solution, articulates its importance, outlines its functionality, and drafts a potential announcement blog post (which remains unpublished at this stage). The team reviews it, asks questions, and assesses its feasibility. You’ll be a key player in this process! We often create what we call an MSP (“Minimum Shitty Prototype”) to gain a rough understanding of how the solution might work and to gauge the effort required for implementation.

#LI-Remote

How We Work:
We’re a fully remote company, committed to a remote-first culture.
With offices in Madrid and New York City, we love face-to-face interactions, you can visit whenever it suits you!
As we’re in the early stages, your contributions will have a significant impact on everything we do.
We believe in transparency, so you’ll always be in the loop about what’s happening.
Check out our blog or follow us on LinkedIn to find out more about what’s important to us.