Dremio logo

Dremio

More roles at Dremio

Senior Staff Software Engineer - Query Engine

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 2 weeks ago · Added 8 weeks ago

Been open since 8 weeks ago. Long-running listings are sometimes left up after the role is filled.

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
Not mentioned in the advert
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

  • “Query planning and optimization: Deep understanding of cost-based optimization and rule-based query rewriting, ideally with hands-on experience in Apache Calcite or a similar framework.”
  • “Access control: Experience with role-based or fine-grained access control in data platforms or database systems 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 team owns the SQL planner and optimizer, built on Apache Calcite, and the reflections engine that transparently rewrites queries to use pre-computed materializations instead of raw source data. The team sits between SQL and execution, owning the systems that turn queries into efficient plans and make them fast. As a Senior Staff Software Engineer, you'll set technical direction for these systems: driving ambiguous, cross-team initiatives, raising the bar through design and code review, and growing other senior engineers. Your work will directly affect query performance, correctness, and cost across Dremio's cloud data platform. What you'll be doing

Set technical direction: Define architecture and roadmap for the query planner and reflections systems, including next-generation features.

Build the planner: Design, implement, test, and support planning rules, cost-based optimization, query rewriting, and reflection matching and substitution.

Own complex initiatives: Lead design and delivery of projects that cross team boundaries, working with Query Execution, Catalog, Datalake, and Product.

Work with open source: Work deeply with Apache Calcite and Apache Iceberg, and drive contributions upstream where it benefits Dremio.

Diagnose difficult problems: Investigate query planning correctness and performance issues, including reflection matching, using query profiles, telemetry, benchmarks, logs, and production data.

Design for every deployment: Build systems that run correctly across Dremio's deployment models and public clouds.

Use AI-assisted development tools: Apply AI tools to code comprehension, debugging, test generation, documentation, and incident analysis.

Apply engineering judgment: Validate AI-generated code and recommendations through review, testing, benchmarking, and engineering judgment.

Raise the engineering bar: Participate in design and code reviews, set technical standards, and mentor senior and staff-level engineers.

Partner across the company: Work with Product on multi-quarter roadmap decisions and with Support and field engineering on the highest-impact customer issues.

What we're looking for

Software engineering experience: 10+ years developing production software, including 5+ years of strong Java.

Query planning and optimization: Deep understanding of cost-based optimization and rule-based query rewriting, ideally with hands-on experience in Apache Calcite or a similar framework.

Database fundamentals: Strong knowledge of SQL, query processing, performance, and schema design.

Computer science fundamentals: Strong foundation in data structures, algorithms, concurrency, and multithreaded programming.

Technical leadership: Track record of driving system-level architecture decisions, leading complex cross-team initiatives, and mentoring senior engineers.

Access control: Experience with role-based or fine-grained access control in data platforms or database systems is a plus.

Cloud and storage: Understanding of distributed file systems and object stores such as S3, ADLS, or HDFS; experience with AWS, Azure, or Google Cloud.

Engineering judgment: Ability to evaluate tradeoffs, validate solutions rigorously, and make sound decisions when working with unfamiliar or AI-assisted implementations.

Communication and ownership: Ability to navigate ambiguous, cross-org problems independently, with strong communication skills and a commitment to delivering high-quality software.

Bonus points if you have

Requirements

  • ·Query engines: Experience with distributed query engines, database engines, or large-scale data processing systems.
  • ·Planning techniques: Materialized view matching, query rewriting, statistics and cardinality estimation, or cost model design.
  • ·Open source: Contributions to Apache Calcite, Apache Iceberg, or similar planner and data platform projects.
  • ·Data platforms: Apache Arrow, Apache Iceberg, Parquet, Spark, or cloud object stores.

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 2mo 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.