Staff Software Engineer - Semantic Layer

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-size: 10pt;"><strong>About Us</strong></span></p> <p><span style="font-size: 10pt;">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.</span></p> <p><span style="font-size: 10pt;">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-size: 10pt;"><strong>About the Team</strong></span></p> <p><span style="font-size: 10pt;">The Semantic Layer team owns the systems that turn dbt models into trusted, reusable business metrics. At the heart of this is <strong>MetricFlow</strong> — the open-source semantic engine that powers the dbt Semantic Layer. MetricFlow lets data teams define metrics once in code and consume them consistently across BI tools, notebooks, AI agents, and downstream applications.</span></p> <p><span style="font-size: 10pt;">This team is the steward of MetricFlow as an open-source project: shipping releases, reviewing community contributions, evolving the query compiler, and ensuring it integrates cleanly with the broader dbt ecosystem. You'll work at the intersection of language design, query compilation, and distributed data execution — solving problems that directly shape how thousands of organizations measure their business.</span></p> <p><span style="font-size: 10pt;"><strong>About the Role</strong></span></p> <p><span style="font-size: 10pt;">We're hiring a Senior Software Engineer to join the Semantic Layer team in Bangalore. You'll be a core contributor to MetricFlow — designing features, optimizing query generation, hardening the open-source codebase, and partnering with the community of contributors and adopters around it. This is a high-ownership role: you'll write production code, drive technical decisions, and help shape the long-term architecture of one of the most important projects in the modern data stack.</span></p> <p><span style="font-size: 10pt;"><strong>What You'll Do</strong></span></p> <ul> <li style="font-size: 10pt;"><span style="font-size: 10pt;">Design, build, and maintain core features of MetricFlow, including metric definitions, query compilation, dimensional modeling, and SQL generation across multiple data warehouses (Snowflake, BigQuery, Databricks, Redshift, and others).</span></li> <li style="font-size: 10pt;"><span style="font-size: 10pt;">Own MetricFlow as an open-source project — triage issues, review external pull requests, manage releases, and engage the community on GitHub and in Slack.</span></li> <li style="font-size: 10pt;"><span style="font-size: 10pt;">Collaborate with engineers across dbt Cloud, dbt Core, and the Semantic Layer service to ensure MetricFlow integrates seamlessly with the rest of the dbt ecosystem.</span></li> <li style="font-size: 10pt;"><span style="font-size: 10pt;">Improve performance, reliability, and observability of metric query execution at scale.</span></li> <li style="font-size: 10pt;"><span style="font-size: 10pt;">Partner with product, design, and developer-relations teammates to translate customer and community feedback into shipped improvements.</span></li> <li style="font-size: 10pt;"><span style="font-size: 10pt;">Write clear technical documentation, RFCs, and design docs that raise the bar for how the team thinks and ships.</span></li> <li style="font-size: 10pt;"><span style="font-size: 10pt;">Mentor other engineers through code review, pairing, and technical guidance.</span></li> </ul> <p><span style="font-size: 10pt;"><strong><span class="notion-enable-hover" data-token-index="0">Skills We're Looking For</span></strong></span></p> <ul> <li style="font-size:…