Staff Software Engineer - Semantic Layer

Fivetran
Bengaluru
Workplace: HybridFull timeFunction: Software EngineeringSkills: ["Communication","Collaboration","Mentorship","Technical documentation"]

Build and maintain core features of the open-source MetricFlow semantic engine, including metric definitions, query compilation, dimensional modeling, and SQL generation across multiple data warehouses. Own MetricFlow as a public project by triaging issues, reviewing pull requests, managing releases, and engaging the community. Collaborate with dbt Cloud/Core engineers, improve performance and reliability at scale, and mentor others while contributing design docs, RFCs, and technical documentation.

Loading

Loading job details...

Preparing the role view and application actions.

FursaFursa
Fivetran
Fivetran
1 month ago

Staff Software Engineer - Semantic Layer

✓ Verified Job

Canonical indexed version, validated from employer's careers page.

Source: Company careers pageValidated by: Fursa AI
Last checked: 4 hours agoStatus: Live

Job Summary

Build and maintain core features of the open-source MetricFlow semantic engine, including metric definitions, query compilation, dimensional modeling, and SQL generation across multiple data warehouses. Own MetricFlow as a public project by triaging issues, reviewing pull requests, managing releases, and engaging the community. Collaborate with dbt Cloud/Core engineers, improve performance and reliability at scale, and mentor others while contributing design docs, RFCs, and technical documentation.
Location: Bengaluru
Workplace: Hybrid
Employment Type: Full time
Job Function: Software Engineering
Seniority: Mid level

Key Responsibilities

  • •Design, build, and maintain MetricFlow features including metric definitions, query compilation, dimensional modeling, and SQL generation across multiple data warehouses.
  • •Own MetricFlow as an open-source project by triaging issues, reviewing external pull requests, managing releases, and engaging the community on GitHub and Slack.
  • •Collaborate with engineers across dbt Cloud, dbt Core, and the Semantic Layer service to ensure seamless integration with the dbt ecosystem.
  • •Improve performance, reliability, and observability of metric query execution at scale.
  • •Partner with product, design, and developer-relations teams to translate feedback into shipped improvements, and mentor other engineers.

Pay and Benefits

Perks:Health InsuranceRsusPaid LeaveParental LeaveLearning BudgetWellness StipendHome Office

Key Requirements

  • •Strong professional software engineering experience with a track record of shipping production systems.
  • •Deep proficiency in Python, including modern typing, testing practices, and packaging.
  • •Strong SQL fundamentals and an understanding of how analytical query engines and data warehouses execute queries.
  • •Experience designing systems involving parsing, compilation, or transformation (e.g., query planners, DSL compilers, type systems, or rule-based engines).
  • •Solid software design principles including clean APIs, modularity, testability, and backwards compatibility.
Skills:CommunicationCollaborationMentorshipTechnical documentation
Languages:English
Tech Stack:MetricFlowDbtDbt CloudDbt CorePythonSQLSnowflakeBigQueryDatabricksRedshiftGitHubSlackGitHub ActionsCI/CDLookMLCube

Company Brief

Fivetran
Provides automated data integration and replication software that moves data from hundreds of sources into cloud data warehouses and analytics platforms. Helps engineering and analytics teams keep data pipelines reliable, current, and low-maintenance.
Industry: Data Infrastructure
Company Size: Enterprise (1,001+ employees)
Growth: Scaleup
Headquarters: Oakland, United States
Founded: 2012
WebsiteLinkedIn