Staff Software Engineer - Semantic Layer

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, and volunteer days off
• RSU stock grants*
• Professional development and training opportunities
• Company virtual happy hours, free food, and fun team-building activities
• Monthly cell phone stipend
• Access to an innovative mental health support platform that offers personalized care and resources in areas such as: therapy, coaching, and self-guided mindfulness exercises for all covered employees and their covered dependents.

*May vary by country and worker type - please reach out to your recruiter for more information

Click here to learn more about Fivetran's Benefits by Region.

We’re honored to be valued at over $5.6 billion, but more importantly, we’re proud of our core values of Get Stuck In, Do the Right Thing, and One Team, One Dream. Read about us in Forbes.

Fivetran brings together high-quality talent across the globe to make data access as easy and reliable as electricity for our customers. We value and recognize that our customers benefit from having innovative teams made of people from many backgrounds, experiences, and identities. Fivetran promotes diversity, equity, inclusion & belonging through attracting, recruiting, developing, and retaining a diverse workforce, not only because it is the right thing to do, but because it helps us build a world-class company to better serve our customers, our people and our communities.

To learn more about Fivetran’s culture and what it’s like to be part of the team, click here and enjoy our video.

To learn more about our candidate privacy policy, you can read our statement here.

We are committed to ensuring that all candidates have an equal opportunity to participate in our interview process. If you require accommodations at any stage of the process due to a disability, medical condition, or any other circumstance, please don't hesitate to submit your request by filling out this form. We will work with you to provide reasonable accommodations to facilitate your participation and ensure a fair and accessible interview experience. Your request and any information provided will be kept confidential and will not impact your candidacy. We look forward to hearing from you and accommodating your needs to the best of our ability.