Staff Software Engineer — Dynamic Tables, Performance

Reposted 19 Days Ago
Be an Early Applicant
Bellevue, WA, USA
Hybrid
236K-339K Annually
Expert/Leader
Artificial Intelligence • Big Data • Cloud • Machine Learning • Software • Database • Analytics
Let's build a world where data and AI turn possibilities into reality.
The Role
The Staff Software Engineer will lead performance improvements for the incremental view maintenance engine, define roadmaps, mentor engineers, and contribute to technical publications.
Summary Generated by Built In

At Snowflake, we are powering the era of the agentic enterprise. To usher in this new era, we seek AI-native thinkers across every function who are energized by the opportunity to reinvent how they work. You don’t just use tools; you possess an innate curiosity, treating AI as a high-trust collaborator that is core to how you solve problems and accelerate your impact. We look for low-ego individuals who thrive in dynamic and fast-moving environments and move with an experimental mindset — who rapidly test emerging capabilities to discover simpler, more powerful ways to deliver results. At Snowflake, your role isn't just to execute a function, but to help redefine the future of how work gets done.

About Dynamic Tables

  • Dynamic Tables (DTs) are Snowflake's declarative streaming transformation primitive. Customers define a SQL query and a freshness target; Snowflake handles the rest: orchestrating refreshes, maintaining snapshot consistency across a DAG of dependencies, and automatically incrementalizing the computation so that cost scales with what changed. Dynamic Tables is one of the fastest growing products at Snowflake and is a core part of Snowflake’s Data Engineering strategy.

    The Dynamic Tables performance team is responsible for making incremental refresh fast, predictable, and cost-efficient across increasingly complex query shapes. As a Staff Engineer on this team, you will own the technical direction for critical performance initiatives and be a force multiplier for the engineers around you.


    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.

Every Snowflake employee is expected to follow the company’s confidentiality and security standards for handling sensitive data. Snowflake employees must abide by the company’s data security plan as an essential part of their duties. It is every employee's duty to keep customer information secure and confidential.

Snowflake is growing fast, and we’re scaling our team to help enable and accelerate our growth. We are looking for people who share our values, challenge ordinary thinking, and push the pace of innovation while building a future for themselves and Snowflake.

How do you want to make your impact?

For jobs located in the United States, please visit the job posting on the Snowflake Careers Site for salary and benefits information: careers.snowflake.com

Skills Required

  • 10+ years of experience building and optimizing large-scale data systems
  • Deep expertise in query optimization or incremental/stream processing
  • Proficiency in C++ or Java
  • Experience with systems-level performance analysis
  • Demonstrated ability to lead multi-engineer cross-team initiatives
  • Experience operating systems at cloud scale
  • Strong written and verbal communication skills

Snowflake Compensation & Benefits Highlights

The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Snowflake and has not been reviewed or approved by Snowflake.

  • Equity Value & Accessibility Equity grants (RSUs) and an ESPP are central to total compensation and are described as highly valuable. Feedback suggests many see equity as a major satisfaction driver with meaningful upside potential.
  • Fair & Transparent Compensation Pay is considered competitive and accompanied by clear communication on salary, equity, and advancement. Feedback suggests pay practices emphasize fairness and transparency.
  • Parental & Family Support Paid parental leave, fertility benefits, adoption assistance, and family planning resources are notably comprehensive. Feedback suggests these programs materially support major life events.

Snowflake Insights

Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Bozeman, MT
9,023 Employees
Year Founded: 2012

What We Do

Snowflake powers the end-to-end data lifecycle – from ingesting and processing data to analyzing and modeling it, to building and sharing data and AI applications – helping engineers, analysts, and leaders innovate faster and achieve more with their data. We're on a mission to empower every enterprise to achieve its full potential through data and AI.

Why Work With Us

Snowflake is where data does more, and so do you. More innovating, more growing, and more collaborating. Here, you’ll find the sweet spot between building big and moving fast, in technology and your career.

Gallery

Gallery

Similar Jobs

Snap Inc. Logo Snap Inc.

Manager, Software Engineering, MDP

Artificial Intelligence • Cloud • Machine Learning • Mobile • Software • Virtual Reality • App development
Hybrid
4 Locations
5000 Employees
195K-343K Annually

Collectors Logo Collectors

Senior Software Engineer

Consumer Web • eCommerce • Machine Learning • Software • Sports • Analytics
Remote or Hybrid
US
2246 Employees
141K-229K Annually

HiBob Logo HiBob

Business Development Representative

HR Tech • Information Technology • Professional Services • Sales • Software
Remote or Hybrid
United States
1350 Employees
64K-64K Annually

HiBob Logo HiBob

Customer Experience Manager

HR Tech • Information Technology • Professional Services • Sales • Software
Remote or Hybrid
United States
1350 Employees
140K-170K Annually

Similar Companies Hiring

Hanover Park Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
42 Employees
Kepler  Thumbnail
Fintech • Software
New York, New York
6 Employees
Onshore Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
60 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account