Dremio
Staff Software Engineer - Query Planner & Reflections
engineeringfull-timePortugal - Remote
SALARY
Not listed
WORK TYPE
hybrid
JOB TYPE
full-time
INDUSTRY
general
✦ AutoApply Sick of applying? We apply to roles like this for you, up to 20 a month.
Learn more
About the role
About the role
Dremio's Query Planner & Reflections (QPR) team owns the SQL planner and optimizer — built on Apache Calcite — and the reflections substitution engine that transparently rewrites queries to hit pre-computed materializations instead of raw source data. As a Staff Software Engineer, you'll set technical direction for this system: driving ambiguous, cross-team initiatives, raising the bar through design and code review, and helping other engineers.
What you'll be doing
- Set architecture and technical direction for the Query Planner and Reflections team spanning next-generation features across OSS, Enterprise, and Cloud editions.
- Own design, implementation, and delivery of complex initiatives that cross team boundaries (Query Execution, Catalog, Datalake).
- Work deeply with Apache Calcite and Apache Iceberg, including driving contributions upstream where it benefits Dremio.
- Diagnose the hardest 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 apply engineering judgment to validate AI-generated code through review, testing, and benchmarking.
- Design architectures that run 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 the highest-impact customer issues.
What we're looking for
- B.S./M.S/Equivalent in Computer Science or a related technical field or equivalent experience
- 8-10+ years of experience developing production-level software.
- Fluency in Java/C++ is a plus.
- Deep understanding of query planning and optimization: cost-based optimizers, rule-based rewriting, ideally hands-on with Apache Calcite or a similar framework.
- Strong database fundamentals: SQL, performance, schema design.
- Track record of driving system-level architecture decisions and leading complex, cross-team initiatives.
- Setting technical direction for the 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-org problems independently; strong communication skills.
- Understanding of distributed file systems such as S3, ADLS, or HDFS; AWS, Azure, or GCP experience is a plus.
Bonus points if you have
- 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.
✦ Sick of applying to 40 jobs a month?
I rewrite your resume for ATS by hand first. Once you sign off on it, AutoApply applies to up to 20 roles like this a month, cover letter in your own voice each time. From $99/mo, cancel anytime.
Get AutoApply