Staff Software Engineer, Query Infrastructure

Posted 2 days ago

Apply Now

Resume Score

Check how well your resume matches this job before you apply.

Sign in to check score

About the role

  • Staff Software Engineer improving Nova, Amplitude’s OLAP engine powering its AI analytics platform. Optimizing query infrastructure, distributed systems, reliability, and cloud efficiency.

Responsibilities

  • Own core components across query execution, columnar storage, and distributed compute
  • Design elastic query infrastructure for AI agents as first-class clients, targeting 10× query throughput with predictable performance and lower cost per query
  • Solve performance problems across engine internals and cloud infrastructure, including JVM and memory optimization and distributed execution
  • Own production reliability through on-call, incident investigation, and architectural improvements
  • Set technical direction for major initiatives and lead them from proposal through production with clear milestones and measurable results
  • Decide what to build, what to adopt, and how to evolve Nova for its next order of magnitude in scale
  • Work across engineering and product to set priorities and resolve trade-offs between capabilities, complexity, and cost
  • Help senior engineers take on larger technical problems through design reviews, debugging, and shared ownership

Requirements

  • 8+ years of industry experience in backend or infrastructure engineering, with depth in distributed data systems
  • Hands-on experience building or extending analytical or OLAP systems, including query engines, columnar storage, large-scale data processing or streaming frameworks, or equivalent
  • Track record of leading multi-month, cross-team technical projects from design through production, including significant cost or performance wins on cloud infrastructure
  • Strong computer science fundamentals: distributed systems (partitioning, replication, consistency, failover), data structures and algorithms, concurrency, and performance optimization
  • Demonstrated technical influence beyond the immediate team: leading design discussions, driving cross-team alignment, and mentoring engineers
  • Proficiency in Java, C++ or Python
  • Experience with query or OLAP systems such as Druid, ClickHouse, Presto/Trino, Spark, BigQuery or Snowflake
  • Experience with SQL planning and optimization, or building SQL layers over heterogeneous storage
  • Familiarity with open table and columnar formats including Iceberg, Parquet, Arrow and ORC, and warehouse-native architectures
  • Familiarity with product analytics, experimentation platforms, event-driven data systems, or serving data to LLM and agent workloads

Benefits

  • Excellent Medical, Dental and Vision insurance coverages, with 100% employer-paid premiums for employee Medical, Dental, Vision on select plans
  • 401(k) retirement plan with an employer match of up to 1% of eligible pay each pay period up to $2,000 annually
  • Flexible time off
  • Paid holidays
  • Monthly wellness stipend
  • Monthly commuter transit/parking stipend
  • Quarterly learning and development stipend
  • New hire home office equipment stipend
  • 12 weeks of Paid Parental Leave
  • Carrot Fertility Benefits/Adoption/Surrogacy support
  • Back-up Child Care support
  • Mental health and wellness benefits, including no-cost employee access to Modern Health coaching and therapy sessions
  • Employee Stock Purchase Program (ESPP)
  • Mentorship programs
  • Management training
  • Wellness initiatives
  • Charitable giving grant
  • Paid volunteer time off

Job type

Full Time

Experience level

Lead

Salary

Not specified

Degree requirement

No Education Requirement

Tech skills

BigQueryCloudDistributed SystemsJavaPythonSnowflakeSparkSQLC++

Location requirements

HybridVancouverCanada

Report this job

Found something wrong with the page? Please let us know by submitting a report below.