You and the process

With a person
Anna, in-house recruiter
9 years hiring engineers
30 minutes with a real recruiter
They read your CV with you, on a call, and say where the offers are being lost.
Didn’t find what you were looking for? Tell us what to build
Dremio

Staff Software Engineer - Query Planner & Reflections

  • Remote
  • 6+ years

Salary

Not stated

Similar roles pay €75K - 105K a year · our estimate

AI summary

For members

The whole posting in a few lines. Sign up to read it here and on every role you open.

Sign Up to Read

Description

The company makes a unified lakehouse platform for self-service analytics and AI, used by hundreds of global enterprises. Customers run it in the cloud, in hybrid setups, and on-premises for data mesh, warehouse migration, data virtualization, and unified data access. It is built on open source projects including Apache Iceberg and Apache Arrow.

The Query Planner & Reflections team builds the SQL planner and optimizer, based on Apache Calcite, and the reflections engine. That engine rewrites queries to read precomputed materializations instead of raw source data, without users changing their queries.

This is a staff role where you set technical direction for the system and lead ambiguous initiatives that span several teams. You raise the engineering bar through design and code reviews and help other engineers grow.

Responsibilities

  • Set architecture and technical direction for the Query Planner and Reflections team across the OSS, Enterprise, and Cloud editions.
  • Own complex initiatives that cut across Query Execution, Catalog, and Datalake teams, from design through delivery.
  • Work in depth on Apache Calcite and Apache Iceberg, and push useful changes upstream.
  • Find the hardest correctness and performance problems in query planning and reflection matching, using query profiles, telemetry, and production data.
  • Use AI-assisted tools for code understanding, debugging, test writing, documentation, and incident analysis, and check AI-generated code through review, testing, and benchmarks.
  • Design systems that behave correctly across deployment models and public clouds.
  • Take part in design and code reviews and set standards for the team.
  • Work with Product on multi-quarter roadmap decisions, and with Support and field teams on the most important customer issues.

Requirements

  • A B.S. or M.S. in Computer Science or a related technical field, or equivalent experience.
  • 8-10+ years of experience building production software.
  • Deep knowledge of query planning and optimization, including cost-based and rule-based approaches. Hands-on work with Apache Calcite or a similar framework is preferred.
  • Strong database fundamentals in SQL, performance, and schema design.
  • A record of making system-level architecture decisions and leading complex cross-team work.
  • Experience setting technical direction for a team or a major component.
  • Ability to weigh tradeoffs and make sound calls on unfamiliar or AI-assisted implementations.
  • Ability to work through ambiguous, cross-organization problems on your own, with strong communication.
  • 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.
  • Bonus points if you have: experience with distributed query engines.
  • Bonus points if you have: hands-on work in query processing or optimization, materialized view matching, distributed systems, concurrency control, code generation, Apache Arrow, caching, or disk spilling.
  • Bonus points if you have: contributions to Apache Calcite, Apache Iceberg, or similar open source planner projects.

Conditions

The company will make reasonable accommodations for people with disabilities during the application and interview process; ask your recruiter to request one.

Official recruiting messages come only from the company's own domain, and suspected recruitment scams should be reported to local law enforcement.

Where you’d work

Fully remote

You can work from

  • Europe
  • Portugal

About the company

Dremio

  • Industry: SaaS

3 of their 3 open roles are remote

Your chances

We've checked whether it's still hiring and how crowded it is.

  • 19 checks run
  • 0 red flags

Still hiring?

13 checks

No red flags

How crowded?

6 checks

No red flags

Fits Me

How well does this role fit you?

Answer a few questions or drop your CV, and every role gets a fit score with the reasons, this one first.

  • Your field
  • Level
  • Stack
  • Work model
  • Salary floor
  • Must-haves
Details11 facts · Role, Location, Compensation, Company
Tech stack
  • Java
  • SQL
  • AWS
  • C++
  • Azure
Seniority
Staff
Industry
SaaS
Specialty
Backend
Region
Europe
Pay period
Annual
Show 5 more factsShow less

Role

Category
Development
Specialty
Backend
Seniority
Staff
Experience
10+ years
Tech stack
  • Java
  • SQL
  • AWS
  • C++
  • Azure

Location

Work model
Remote
Region
Europe
Remote from
  • Europe

Compensation

Salary
Salary by agreement
Pay period
Annual

Company

Industry
SaaS

Something wrong with this vacancy?

Similar vacancies

Share this vacancy

What's wrong with it?

The employer never sees who reported.

Reason