Dremio logo

Dremio

More roles at Dremio

Staff Software Engineer - Query Planner & Reflections

Work from home

Remote role where the employee must remain based in a particular country.

Portugal only

From the listing details: Source listing states candidate location: "Portugal - Remote"

Employer listed it 6 days ago · Added 3 days ago

First listed 6 days ago and still open.

Salary

Not stated

Location

Portugal only

Timezone

CET ±2

Contract

Full-time

Experience

Lead

Category

Software

The employer did not publish a salary, and we have too few comparable roles to estimate one.

What the advert says

Quoted word for word from the employer's advert. Where it says nothing, we say so.

Working hours
Not mentioned in the advert
Where you can work from
Customers rely on Dremio for cloud, hybrid, and on-prem lakehouses to power their data mesh, data warehouse migration, data virtualization, and unified data access use cases.
Contract
Not mentioned in the advert
Experience asked for
8-10+ years of experience developing production-level software.
Pay
Not mentioned in the advert

Remote flexibility

Work from home

This is a remote role, but the employee must be based in Portugal. It is work from home rather than work from anywhere.

What the employer says

  • Source listing states candidate location: "Portugal - Remote"

What Nomaders makes of it

  • Residency required in Portugal
  • Payroll and tax are likely handled in that country only

The quotes above are the employer's own words; the reading is ours. Always check the original listing and employment terms before working from another country.

Before you apply

Experience: employer states

Written as a nice-to-have

  • “Understanding of distributed file systems such as S3, ADLS, or HDFS; AWS, Azure, or GCP experience is a plus.”

Questions worth asking: Nomaders interpretation

  • No pay is stated. Ask for the salary range before investing time in interviews.
  • The advert does not say whether this is employment or a contractor arrangement. Ask, as it affects tax and benefits.

Produced automatically from this advert's text; not reviewed by a person. The employer's own page is the final word.

About the role

Be Part of Building the Future

Dremio is the unified lakehouse platform for self-service analytics and AI, serving hundreds of global enterprises, including Maersk, Amazon, Regeneron, NetApp, and S&P Global. Customers rely on Dremio for cloud, hybrid, and on-prem lakehouses to power their data mesh, data warehouse migration, data virtualization, and unified data access use cases. Based on open source technologies, including Apache Iceberg and Apache Arrow, Dremio provides an open lakehouse architecture enabling the fastest time to insight and platform flexibility at a fraction of the cost. Learn more at www.dremio.com.

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.

Requirements

  • ·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.
  • ·Dremio is committed to providing any necessary accommodations for individuals with disabilities within our application and interview process. To request accommodation due to a disability, please inform your recruiter.

Benefits

No benefits package published with this listing. Ask about it at first interview.

How to apply

  1. 1Check the flexibility label above, work from home, matches where you plan to live and work.
  2. 2Tailor your CV to the role at Dremio, mentioning your remote working experience and working hours (CET ±2).
  3. 3Apply directly on the employer's careers page using the button below. Nomaders never handles your application.

Found 4d ago. Last checked 17 Nov. Always confirm the details on the original posting, salary and location can change after publication.

Listing sourced from Company boards.

Pay not stated · You'll be taken to the employer's careers page.