Why This Job is Featured on The SaaS Jobs
This Staff Software Engineer role sits at a core SaaS platform problem: making a multi-tenant, cloud data product deliver predictable performance and cost efficiency as customer workloads and query shapes evolve. The focus on Dynamic Tables highlights a modern SaaS pattern where product differentiation comes from managed, declarative primitives that abstract orchestration, freshness targets, and correctness guarantees behind a simple interface.
From a SaaS career perspective, the work builds durable systems expertise that transfers across data infrastructure companies: incremental computation, distributed execution, performance regression detection, and roadmap shaping where technical trade-offs directly influence customer experience. The cross-team design component also reflects how mature SaaS platforms are built, with shared engines and primitives that multiple product surfaces depend on.
The role fits engineers who prefer deep technical ownership over a critical subsystem and who enjoy turning ambiguous performance questions into measurable improvements. It is well matched to someone comfortable leading design reviews, mentoring peers, and collaborating with product and research stakeholders, particularly where publication-quality rigor and production constraints need to coexist.
The section above is editorial commentary from The SaaS Jobs, provided to help SaaS professionals understand the role in a broader industry context.
Job Description
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.
Build the Future of Declarative Data Pipelines
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.
Snowflake is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to age, color, gender identity or expression, marital status, national origin, disability, protected veteran status, race, religion, pregnancy, sexual orientation, or any other characteristic protected by applicable laws, regulations, and ordinances.
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
