Jobs / Portugal / Dremio Corporation

Dremio Corporation

Staff Software Engineer - Query Planner & Reflections

Portugal - Remote · Remote · Europe Posted 8 days ago

Apply on employer site ↗ Tailor my CV first Source: Company careers site

Optional: we can tailor a CV and cover letter for this job from your real experience first (the first one is free).

Skills this job asks for

Warehouse operationsSQLProduct managementJavaC++CommunicationAWSAzureGoogle Cloud

Add your CV (free) to see which of these your CV is missing.

Where you can work from

Europe only

Based on the listing's location: Portugal - Remote.

The company's headquarters is not the same as where you may work from. Visa sponsorship only matters if you would relocate; see below.

Visa sponsorship, if you would relocate

Sponsorship verdict

No sponsorship evidence yet

No government record and no wording either way. Not a refusal: ask the recruiter.

  • No government sponsor record hereNo government sponsor record covers this employer in this country.
  • The posting doesn’t mention sponsorshipSilence isn’t a refusal — ask the recruiter before investing much time.
  • Can’t check pay against the visa rulesWe don’t have visa salary rules for this country yet.
  • Confirmed live todayWhen a source last listed this job as open.
Details and sources

A verdict summarises public evidence. It is not legal advice and never a guarantee: the employer and the immigration authority decide. Sign in to factor in where you can already work.

Before you apply

Sponsorship unknown

No register record and no sponsorship wording in the posting. Worth asking the employer before investing significant time.

These come from the posting’s own wording. Read the original listing to confirm. See better-fit alternatives →

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. 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. What we value At Dremio, we hold ourselves to high standards when it comes to People, Thinking, and Action. Our Gnarlies (that's what we call our employees) communicate with clarity, drive accountability, and are respectful towards each other. We confront brutal facts

Apply on employer site ↗