Dremio · posted · checked
Staff Software Engineer – Query Planner & Reflections
AWSAzureC++GCPJavaRemote · PortugalStaff+
Who can apply
Remote · Portugal
Location: Portugal - Remote
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.