Software Engineer - Compiler

Sigma Computing Sigma Computing · Data AI · San Francisco, CA · Engineering

Software Engineer - Compiler role at Sigma Computing, focusing on transforming user-driven spreadsheet interactions into highly optimized SQL queries for business intelligence. The role involves designing, building, and maintaining compiler infrastructure, applying optimization strategies, and contributing to both backend (Rust) and frontend (TypeScript) foundations. Requires strong CS fundamentals, compilers, algorithms, and SQL optimization.

What you'd actually do

  1. Tackle core challenges at the intersection of data modeling, query compilation, and large-scale interactive analytics—making it possible for end-users to query data warehouses efficiently without deep technical knowledge
  2. Design, build, and maintain sophisticated compiler infrastructure and intermediate representations that translate spreadsheet operations into optimized query plans
  3. Apply advanced optimization strategies to improve performance and accuracy across a wide range of query workloads and data architectures
  4. Contribute to both backend (Rust) and key frontend foundations (TypeScript), evolving critical abstractions that enable end-to-end workflow optimizations and new features
  5. Debug, analyze, and resolve complex issues, ensuring robustness and maintainability in a rapidly evolving product

Skills

Required

  • compilers
  • algorithms
  • SQL Optimization
  • Rust
  • TypeScript
  • software systems engineering

Nice to have

  • distributed systems
  • query optimization
  • database internals
  • API design
  • data model design
  • cloud infrastructure
  • Rust
  • Go
  • Node
  • K8s
  • GraphQL

What the JD emphasized

  • 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