Search Remote Jobs

Staff Software Engineer – Query Planner, Reflections

Job not on LinkedIn

🔥 23 minutes ago

🇵🇹 Portugal – Remote

⏰ Full Time

🔴 Lead

🧑‍💻 Full-stack Engineer

Where this job comes from

Posted on Dremio's careers page, not through a job board

First seen by Remote Rocketship 23 minutes ago

Logo of Dremio

Dremio

201 - 500 employees

Founded 2015

📚 Education

🤝 B2B

☁️ SaaS

Education • B2B • SaaS

Dremio is an innovative company that offers educational resources and certifications through Dremio University, providing courses and badges in data analytics and product development. It aims to empower professionals in the tech and data field by offering specialized training for roles such as Data Analyst and Data Engineer, ultimately enhancing their skills and career prospects.

📋 Description

• Set architecture and technical direction for the Query Planner and Reflections team across OSS, Enterprise, and Cloud editions • Own the design, implementation, and delivery of complex initiatives crossing Query Execution, Catalog, and Datalake teams • Work deeply with Apache Calcite and Apache Iceberg, including upstream contributions where beneficial to Dremio • Diagnose difficult 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; validate 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 establish technical standards • Partner with Product on multi-quarter roadmap decisions and with Support and field teams on high-impact customer issues

🎯 Requirements

• 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, including cost-based optimizers and rule-based rewriting; ideally hands-on with Apache Calcite or a similar framework • Strong database fundamentals: SQL, performance, and schema design • Track record of driving system-level architecture decisions and leading complex, cross-team initiatives • Experience setting technical direction for a team or major component • Ability to evaluate tradeoffs and make sound decisions 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 • Experience with AWS, Azure, or GCP is a plus • Experience with distributed query engines is a bonus • Hands-on experience in query processing or optimization, materialized view matching, distributed systems, concurrency control, code generation, Apache Arrow, caching, or disk spilling is a bonus • Contributions to Apache Calcite, Apache Iceberg, or similar open-source planner projects are a bonus

Apply Now

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Similar Jobs

🕒 November 3

Elastic

1001 - 5000

💼 Consulting

📦 Logistics

Principal engineer leading vector similarity search development for Elastic’s Elasticsearch platform. Building algorithms, features, and fixes with a globally distributed engineering team.

🕒 November 3

Elastic

1001 - 5000

💼 Consulting

📦 Logistics

Principal engineer building vector search features and algorithms for Elastic’s Elasticsearch platform. Leading distributed development of scalable vector similarity capabilities in modern Java.

🕒 November 2

DataCamp Limited

51 - 200

📡 Telecommunications

☁️ SaaS

🏢 Enterprise

Senior Product Engineer building scalable AI-powered learning systems at DataCamp. Owning ambiguous product projects, shaping architecture, and mentoring engineers.

🕒 October 22

Cisco

10,000+ employees

🔧 Hardware

🔐 Security

🏢 Enterprise

Software Architect designing Cisco dCloud’s demo automation platform. Building Go/Python services, Kubernetes infrastructure, APIs and AI tools for Cisco solution demos.

🕒 October 14

Block Labs

51 - 200

💼 Consulting

📣 Marketing

📦 Logistics

Staff Frontend Engineer owning multi-brand React, Next.js and TypeScript platforms at Block Labs, a Web3, AI and iGaming technology studio. Building design systems and shipping consumer-facing products with AI agents.

Built by Lior Neu-ner. I'd love to hear your feedback — Get in touch via DM or support@remoterocketship.com
Follow Remote Rocketship on LinkedInFollow Remote Rocketship on InstagramFollow Remote Rocketship on FacebookFollow Remote Rocketship on TikTok