Software Engineer - Compiler

4w4 weeks ago

Sigma Computing

San Francisco, US · Full-time · $170,000 – $235,000

About this role

Sigma Computing is redefining business intelligence by making complex data analysis accessible through a high-performance platform built for the modern data stack. The Compiler Team plays a foundational role, transforming user-driven spreadsheet interactions into highly optimized SQL queries for seamless exploratory analytics on cloud data warehouses.

You will tackle core challenges at the intersection of data modeling, query compilation, and large-scale interactive analytics, designing and maintaining sophisticated compiler infrastructure and intermediate representations that translate spreadsheet operations into optimized query plans. You will also apply advanced optimization strategies to improve performance and accuracy across diverse query workloads and data architectures.

You will contribute to both backend (Rust) and key frontend foundations (TypeScript), evolving critical abstractions for end-to-end workflow optimizations. You will debug and resolve complex issues, ensuring robustness and maintainability in a rapidly evolving product. Collaborate with engineers and product stakeholders to drive technical best practices and architectural decisions.

This role offers the chance to work on core systems that power Sigma's intuitive spreadsheet interface, ensuring speed, reliability, and scalability for all users. You will join a group of dedicated engineers building the foundations that make complex data analysis accessible without deep technical knowledge, with opportunities to influence compiler infrastructure and learn cutting-edge technologies.

Requirements

5+ years experience engineering high-quality software systems
Demonstrated success building and maintaining complex infrastructure or core platform services
Deep understanding of Computer Science fundamentals, particularly in compilers, algorithms, SQL Optimization
Passion for teamwork, technical ownership, and continually raising the engineering bar
Experience working in an iterative, high-cadence environment

Responsibilities

Tackle core challenges at the intersection of data modeling, query compilation, and large-scale interactive analytics
Design, build, and maintain sophisticated compiler infrastructure and intermediate representations that translate spreadsheet operations into optimized query plans
Apply advanced optimization strategies to improve performance and accuracy across a wide range of query workloads and data architectures
Contribute to both backend (Rust) and key frontend foundations (TypeScript), evolving critical abstractions that enable end-to-end workflow optimizations and new features
Debug, analyze, and resolve complex issues, ensuring robustness and maintainability in a rapidly evolving product
Collaborate with engineers and product stakeholders to review designs and code, driving technical best practices and architectural decisions throughout the team and company