Senior Software Engineer - Query Optimization - job 1 of 2

About the role

In this role, you will work on some of Dremio's core features including Reflections, distributed query optimizer, and SQL support. You will grow as a leader through mentoring, collaborating with other developers and taking ownership of complex issues to deliver high quality distributed systems at a massive scale.

What you'll be doing

• Own design, implementation, testing, and support of next-generation features related to Dremio's query planner and Reflections technology
• Work with open source projects like Apache Iceberg and Apache Calcite
• Use modular design patterns to deliver an architecture that's elegant, simple, extensible and maintainable
• Solve complex technical problems and customer issues while improving our telemetry and instrumentation to proactively detect issues before they arise and make debugging more efficient
• Design and deliver architectures that run optimally on public clouds like GCP, AWS, and Azure
• Mentor other team members for high quality and design
• Collaborate with Product Management to innovate and deliver on customer requirements and with Support and field teams to ensure customer success

What we're looking for

• B.S./M.S/Equivalent in Computer Science or a related technical field or equivalent experience
• Fluency in Java/C++ with 8+ years of experience developing production-level software
• Strong foundation in data structures, algorithms, multi-threaded and asynchronous programming models, and their use in developing distributed and scalable systems
• Strong database fundamentals including SQL, performance, and schema design is a big plus
• Experience in developing complex and scalable distributed systems and delivering, deploying, and managing microservices successfully
• Passion for learning, quality, zero downtime upgrades, availability, resiliency, uptime of the platform, and using latest technologies
• Ability to solve ambiguous, unexplored, and cross-team problems effectively
• Hands-on experience with AWS, Azure, and Google Cloud Platform
• Understanding of distributed file systems such as S3, ADLS, or HDFS
• Background in large scale data processing systems (e.g., Hadoop, Spark, etc.) is a plus
• Ability to scope and plan solutions for big problems and mentors others on the same
• Interested and motivated to be part of a fast-moving startup with a fun and accomplished team
  

Bonus points if you have

• Experience with distributed query engines
• Hands on experience in query processing or optimization, distributed systems, concurrency control, data replication, code generation, networking, storage systems, heap management, Apache Arrow, SQL Operators, caching techniques, and disk spilling
• Hands on experience with multi-threaded and asynchronous programming models

What we offer

• Medical, dental and vision insurance
• 401(k) Plan
• Short term / long term disability and life insurance
• Pre-IPO stock options
• Flexible PTO
• 16 hours of volunteer time off
• 12 company paid holidays, including Juneteenth
• Remote work options
• Monthly "Get Stuff Done" (GSD) Days
• Paid parental leave
• Employee Assistance Program (EAP)
• Quarterly swag surprise

**Certain benefits are only allowed to full-time Dremio employees and may not be the same across all locations. #LI-JW1 #LI-Remote

The compensation range for this position is $154,545 to $209,091 per year. The base pay actually offered will take into account internal equity and also may vary depending on the candidate's geographic region, job-related knowledge, skills, and experience among other factors. Depending on the position offered, the on target earnings (OTE) may include a bonus or commission.