Senior Software Engineer - Semantic Layer

Fivetran, Inc.; United States; On-site; USD 41,560 - 72,730; Full time

Benefits offered by this job

100% employer-paid medical insurance

Generous paid time-off policy (PTO)

Monthly cell phone stipend

Professional development and training

Open-source ownership and impact

Job summary

Fivetran is hiring a Senior Software Engineer for the Semantic Layer team to contribute to MetricFlow, design features, optimize query generation, and harden the open-source codebase. You will partner with a community of contributors and adopters globally, owning critical architecture decisions in a high-ownership role.

You will write production code, drive technical decisions, and collaborate with product, design, and developer-relations teams to ship meaningful improvements across data

Qualifications

• 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 — e.g. query planners, DSL compilers, type systems, or rule-based engines.
• Excellent written and verbal communication — you can explain complex tradeoffs clearly to engineers, PMs, and external community members.

Responsibilities

• 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 Slack.
• Collaborate with engineers across dbt Cloud, dbt Core, and the Semantic Layer service to ensure MetricFlow integrates with the dbt ecosystem.
• Improve performance, reliability, and observability of metric query execution at scale.
• Mentor other engineers through code review, pairing, and technical guidance.

Skills

Python

SQL

Open source

Distributed teams

Software design

Job description

Overview

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.

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.

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
• 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.

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.

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.