Staff Software Engineer – Query Planner, Reflections

Posted Nov 12

This is a fully remote position, open to applicants in Portugal.

📋 Description

• Establish the architectural and technical vision for the Query Planner and Reflections team across OSS, Enterprise, and Cloud editions.

• Take ownership of the design, execution, and delivery of intricate initiatives that span Query Execution, Catalog, and Datalake teams.

• Engage deeply with Apache Calcite and Apache Iceberg, including making upstream contributions that benefit Dremio.

• Identify and resolve challenging correctness and performance issues in query planning and reflection matching through analysis of query profiles, telemetry, and production data.

• Utilize AI-assisted development tools for code understanding, debugging, test creation, documentation, and incident analysis; ensure the quality of generated code through review, testing, and benchmarking.

• Create architectures that function effectively across various deployment models and public cloud environments.

• Take part in design and code reviews and help establish technical standards.

• Collaborate with the Product team on multi-quarter roadmap planning and work alongside Support and field teams to address high-impact customer challenges.


⛳️ Requirements

• B.S./M.S. or equivalent in Computer Science or a related technical discipline, or equivalent professional experience.

• 8-10+ years of experience in developing software at a production level.

• Proficiency in Java/C++ is advantageous.

• In-depth knowledge of query planning and optimization, including cost-based optimizers and rule-based rewriting; ideally, hands-on experience with Apache Calcite or a comparable framework.

• Strong foundational knowledge of databases: SQL, performance, and schema design.

• Proven ability to influence system-level architecture decisions and lead complex, cross-team projects.

• Experience in setting the technical direction for a team or significant component.

• Capability to assess trade-offs and make informed decisions in the face of unfamiliar or AI-assisted implementations.

• Proficient in navigating ambiguous, cross-organizational challenges independently; possesses strong communication skills.

• Familiarity with distributed file systems such as S3, ADLS, or HDFS.

• Experience with AWS, Azure, or GCP is a plus.

• Background in distributed query engines is an advantage.

• Practical experience in query processing or optimization, materialized view matching, distributed systems, concurrency control, code generation, Apache Arrow, caching, or disk spilling is beneficial.

• Contributions to Apache Calcite, Apache Iceberg, or similar open-source planner projects are a plus.


🏝️ Benefits

• Opportunity to work on cutting-edge technology in a dynamic environment.

• Collaborative and innovative team culture.

• Competitive salary and performance-based incentives.

• Comprehensive health benefits and wellness programs.

• Flexible working hours and remote work options.

• Professional development opportunities and support for ongoing education.

People also viewed

Helpware5 hours ago

Senior Principal Java Software Engineer

MX flagMexico OnlyFull-timeFull-stack Engineer
ApplyView job
Introhive6 hours ago

Software Engineer Contractor

CA flagCanada OnlyFreelanceFull-stack Engineer
ApplyView job
Boeing6 hours ago

Senior Embedded Software Engineer

US flagUnited States OnlyFull-timeFull-stack Engineer$171.7k – $232.2k/year
ApplyView job
M9 Solutions6 hours ago

HCM Technical Lead

US flagUnited States OnlyFull-timeFull-stack Engineer$225k – $260k/year
ApplyView job
Game Plan Tech6 hours ago

Product Engineer

US flagUnited States OnlyFull-timeFull-stack Engineer
ApplyView job
Airbus6 hours ago

Systems & Software Architect

DE flagGermany OnlyFull-timeFull-stack Engineer
ApplyView job

Never miss a great job!

Get handpicked remote jobs straight to your inbox weekly.

Trusted by 7,400+ designers