Jobs / Portugal / Dremio Corporation

Dremio Corporation

Senior Staff Software Engineer - Query Engine

Portugal - Remote · Remote · Europe Posted 16 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 managementJavaLeadershipAWSAzureGoogle 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 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 wit

Apply on employer site ↗