
Staff Software Engineer – Query Planner, Reflections
Posted Nov 12

Posted Nov 12
This is a fully remote position, open to applicants in Portugal.
• 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.
• 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.
• 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.
Helpware
Introhive
Boeing
M9 Solutions
Get handpicked remote jobs straight to your inbox weekly.