D

Dremio

Open data lakehouse for in-place analytics

Staff Software Engineer - Query Planner & Reflections

Backend EngineeringPosted on Nov 12
Full-timeRemote in PortugalNo salary listedRemote

About the Job

Requirements

  • A B.S., M.S., or equivalent in Computer Science or a related technical field, or equivalent experience.
  • 8–10+ years of experience developing production-level software.
  • Deep understanding of query planning and optimization, including cost-based optimizers and rule-based rewriting; hands-on experience with Apache Calcite or a similar framework is desirable.
  • Strong database fundamentals, including SQL, performance, and schema design.
  • A track record of driving system-level architecture decisions and leading complex, cross-team initiatives.
  • Experience setting technical direction for a team or major component.
  • Ability to evaluate tradeoffs and make sound decisions when working with unfamiliar or AI-assisted implementations.
  • Ability to navigate ambiguous, cross-organizational problems independently.
  • Understanding of distributed file systems such as S3, ADLS, or HDFS.
  • Fluency in Java or C++ is a plus.
  • AWS, Azure, or GCP experience is a plus.

Responsibilities

  • Set architecture and technical direction for the Query Planner and Reflections team across next-generation features in OSS, Enterprise, and Cloud editions.
  • Own the design, implementation, and delivery of complex initiatives that cross team boundaries, including Query Execution, Catalog, and Datalake.
  • Work deeply with Apache Calcite and Apache Iceberg, including driving upstream contributions when beneficial to Dremio.
  • Diagnose difficult correctness and performance issues in query planning and reflection matching using query profiles, telemetry, and production data.
  • Use AI-assisted development tools for code comprehension, debugging, test generation, documentation, and incident analysis, and validate AI-generated code through review, testing, and benchmarking.
  • Design architectures that operate correctly across deployment models and public clouds.
  • Participate in design and code reviews and set technical standards for the team.
  • Partner with Product on multi-quarter roadmap decisions and with Support and field teams on high-impact customer issues.

Desired Qualifications

  • Experience with distributed query engines.
  • Hands-on experience in query processing or optimization, materialized view matching, distributed systems, concurrency control, code generation, Apache Arrow, caching, or disk spilling.
  • Contributions to Apache Calcite, Apache Iceberg, or similar open-source planner projects.

About the Company

Dremio

Open data lakehouse for in-place analytics

Dremio provides an open data lakehouse platform that lets enterprises run self-service analytics directly on data lake storage without copying data into warehouses. It combines Dremio Sonar, a high-performance SQL query engine with an integrated semantic layer and Data Reflections for acceleration, with Dremio Arctic for Iceberg metadata management and Git-like branching to isolate work. It differentiates itself with in-place lake querying, an open-core model offering free and enterprise editions, and features for AI-assisted analytics through the Agentic Lakehouse. The goal is to help large organizations modernize their data infrastructure by enabling fast, self-service analytics with governance and AI-enabled insights.

Company size
201-500
Company stage
Series E
Total funding
$410M
Headquarters
Santa Clara, CA
Founded
2015

Recently Posted Jobs

Explore more opportunities at Dremio

See more jobs