Senior Staff Software Engineer

About this role

<div class="content-intro"><p>From Fivetran’s founding until now, our mission has remained the same: to make access to data as simple and reliable as electricity. With Fivetran, customer data arrives in their warehouses, canonical and ready to query, with no engineering or maintenance required. We’re proud that more organizations continue to leverage our technology every day to become truly data-driven.</p></div><p><span style="font-family: helvetica, arial, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);"><strong>About the Role</strong></span></p> <p><span style="font-family: helvetica, arial, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">Fivetran and dbt Labs are bringing together two industry-leading companies with a shared mission: helping organizations unlock the full value of their data. Together, we’re delivering the data infrastructure layer that helps organizations move, transform, and trust their data — from the moment data moves, through every transformation, to the context teams and AI systems rely on. Fivetran helps organizations automate data movement across the systems, clouds, engines, and tools they rely on. dbt Labs pioneered analytics engineering, helping teams transform data into reliable, governed insights. Together, we support thousands of organizations as they build a trusted foundation for analytics, AI, and better business decisions. As we bring our teams and technology together, we’re building on the strengths of both companies while continuing to deliver the products and experiences our customers know and trust. It’s an exciting time to join us: we’re creating a company with the scale, talent, and technology to help more organizations put their data to work with greater speed, confidence, and impact. During this transition period, you may see references to both Fivetran and dbt Labs throughout our recruiting process as we integrate our teams, systems, and career sites.</span></p> <p><span style="font-family: helvetica, arial, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">We're looking for a senior-level technical leader to architect, build, and lead our Semantic Layer, the service that turns our customers' raw warehouse data into consistent, reusable metrics and analytical models they can trust across their entire organization.</span></p> <p><span style="font-family: helvetica, arial, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">You'll drive the architecture and long-term technical direction of the semantic layer, raising the bar for its performance, reliability, and analytical power so customers can ask any question of their data and get a fast, correct answer.</span></p> <p><span style="font-family: helvetica, arial, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">The work is very diverse, all the way from designing the modeling and query semantics, to building and optimizing the query execution engine, to operating sync and compute services on our global Kubernetes compute cluster. You'll also be responsible for ensuring the technical excellence of your team and owned services, by reviewing code, contributing to architectural designs, and mentoring your junior colleagues.</span></p> <p><span style="font-family: helvetica, arial, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">This is a full-time, fully remote position.</span></p> <p><span style="font-family: helvetica, arial, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);"><strong>Technologies You’ll Use</strong></span></p> <p><span class="emphasis" style="font-family: helvetica, arial, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">Python, Postgres, DuckDB, Data Warehouses, Kubernetes, Docker, GCP, BuildKite, Grafana</span></p> <p><span style="font-family: helvetica, arial, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);"><strong>What You’ll Do</strong></span></p> <p><span style="font-family: helvetica, arial, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">- Design, build, and lead the architecture of Fivetran's semantic layer, defining the modeling and query semantics that power metrics and analytics across customer data</span></p> <p><span style="font-family: helvetica, arial, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">- Independently design and implement features and performance improvements to create highly scalable distributed data systems on the cloud</span></p> <p><span style="font-family: helvetica, arial, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">- Develop, maintain, and test code</span></p> <p><span style="font-family: helvetica, arial, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">- Drive technical direction and architectural designs across the team and owned services</span></p> <p><span style="font-family: helvetica, arial, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">- Conduct design and code reviews</span></p> <p><span style="font-family: helvetica, arial, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">- Understand and fix challenges related to performance and scalability of query execution over large data warehouses</span></p> <p><span style="font-family: helvetica, arial, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">- Collaborate with peers, product managers, customer support, and other stakeholders to deliver the best product with high quality, performance, and…