Staff Software Engineer - Semantic Layer

Role details

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. About Us 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. About the Team The Semantic Layer team owns the systems that turn dbt models into trusted, reusable business metrics. At the heart of this is MetricFlow — 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. 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. About the Role 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. What You'll Do 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). Own MetricFlow as an open-source project — triage issues, review external pull requests, manage releases, and engage the community on GitHub and in Slack. 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. Improve performance, reliability, and observability of metric query execution at scale. Partner with product, design, and developer-relations teammates to translate customer and community feedback into shipped improvements. Write clear technical documentation, RFCs, and design docs that raise the bar for how the team thinks and ships. Mentor other engineers through code review, pairing, and technical guidance. Skills We're Looking For Strong professional software engineering experience, with a strong track record of shipping production systems. Deep proficiency in Python , including modern typing, testing practices, and packaging. Strong SQL fundamentals and a working understanding of how analytical query engines and data warehouses execute queries. Experience designing systems that involve parsing, compilation, or transformation — for example: query planners, DSL compilers, type systems, or rule-based engines. Solid grasp of software design principles: clean APIs, modularity, testability, and backwards compatibility. Excellent written and verbal communication — you can explain complex tradeoffs clearly to engineers, PMs, and external community members. Experience collaborating in a distributed, asynchronous team environment. Nice to Have Prior experience contributing to or maintaining a popular open-source project. Familiarity with dbt, MetricFlow, LookML, Cube, or other semantic-layer technologies. Background in data warehousing internals, query optimization, or analytical SQL dialects. Experience with CI/CD, GitHub Actions, and release engineering for Python libraries. Exposure to building developer-facing APIs, SDKs, or CLIs. Why Join Us Impact at scale: Your code will run inside the data platforms of tens of thousands of companies, including some of the world's largest enterprises. Open-source ownership: You'll be a public, named maintainer of a foundational project — your work is visible, reviewed, and used by the global data community. A team that values craft: We invest in design docs, code review, and durable engineering. We ship fast, but we don't ship sloppy. Competitive compensation: Market-leading salary, equity, comprehensive health insurance, generous time off, learning & wellness stipends, and home-office support. #LI-HYBRID #LI-JI1 Perks and Benefits 100% employer-paid medical insurance * Generous paid time-off policy (PTO), plus paid sick time, inclusive parental leave policy, holidays (including a year end Global