# Staff Software Engineer — Dynamic Tables, Performance

**Company:** [Snowflake](https://hotfix.jobs/companies/snowflake)
**Location:** Bellevue, WA
**Role:** Backend Engineering
**Salary:** $236k – $339k/yr
**Experience:** 10+ years
**Skills:** C++, Java, SQL, Query Optimization, Incremental View Maintenance, Stream Processing, Materialized Views, Distributed Systems, Algorithms, Data Structures, Profiling, Benchmarking, BigQuery, Redshift, Iceberg
**Posted:** 2026-05-06

> Leads design and implementation of performance improvements for Snowflake's Dynamic Tables incremental view maintenance engine, focusing on complex query shapes, scalability, and cost-efficiency. Requires 10+ years in large-scale data systems with expertise in query optimization or stream processing, plus C++/Java proficiency.

## Job Description

## What You'll Do

- Lead the design and implementation of performance improvements to the incremental view maintenance engine, including multi-join incrementalization, novel incrementalization semantics, incremental window functions, and stacked operations.
- Help define the roadmap for the incremental view maintenance engine, identifying key performance, scalability, and correctness milestones, prioritizing high-impact enhancements, and aligning technical investments with product and research goals.
- Collaborate across teams to co-design improvements that benefit incremental pipelines.
- Mentor engineers, drive design reviews, and raise the technical bar for the team through architectural leadership and high-quality code.
- Contribute to the research and publication roadmap; the team has an active presence at top-tier database conferences (SIGMOD, VLDB).

## What We're Looking For

- 10+ years of experience building and optimizing large-scale data systems, with deep expertise in at least one of: query optimization, incremental/stream processing, or materialized view maintenance.
- Strong computer science fundamentals — algorithms, data structures, and distributed systems design.
- Proficiency in **C++** or **Java**; experience with systems-level performance analysis (profiling, benchmarking, regression detection).
- Demonstrated ability to lead multi-engineer, cross-team technical initiatives and translate ambiguous problem spaces into concrete engineering plans.
- Experience operating systems at cloud scale (multi-tenant SaaS, petabyte-scale data, thousands of concurrent workloads).
- Strong written and verbal communication skills; ability to present complex technical trade-offs to both engineering and product audiences.

## Nice to Have

- Experience with a major analytical DBMS (**BigQuery**, **Redshift**, **Databricks**, **Teradata**, **Oracle**, **SQL Server**).
- Familiarity with stream processing algorithms.
- Experience with CDC pipelines, data lake architectures (**Iceberg**, **Delta**), or the broader data engineering ecosystem (**dbt**, **Airflow**, **Fivetran**).
- Advanced degree (MS or PhD) in Computer Science, with emphasis on database systems.

## Similar roles

- [Staff Software Engineer](https://hotfix.jobs/jobs/1ba96d26-d00e-4d6f-b9c5-cb73b2bfbeed) - Snowflake - Menlo Park, CA - $236k – $339k/yr
- [Staff Software Engineer](https://hotfix.jobs/jobs/430458ce-5802-4555-971d-f6b9744c97dd) - Snowflake - Menlo Park, CA - $236k – $339k/yr
- [Staff Software Engineer - Parameters](https://hotfix.jobs/jobs/ba05d8f8-0294-4163-91cf-c1dda4e7a0da) - Snowflake - Bellevue, WA - $236k – $339k/yr
- [Staff Softare Engineer, Cortex AI Infrastructure](https://hotfix.jobs/jobs/c52a5071-ad56-48ab-9310-ef0feaeffd0d) - Snowflake - Menlo Park, CA - $236k – $339k/yr
- [Staff Software Engineer - Flink Control Plane](https://hotfix.jobs/jobs/6434894a-f78c-41b5-9f10-6a285dae3552) - Confluent - Remote - $236k – $277k/yr

**Apply:** https://hotfix.jobs/jobs/40bc04ef-4528-488d-89af-d753f7152bd9
**Canonical:** https://hotfix.jobs/jobs/40bc04ef-4528-488d-89af-d753f7152bd9