Senior Software Engineer, Open-Source MetricFlow: Data Stack

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

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