Senior Software Engineer - Semantic Layer
Fivetran
Bengaluru, Karnataka, India, APACPosted 1 month ago
Skill Required
Engineering DepartmentSoftware EngineerSoftware DeveloperQuery OptimizationData WarehousingGitHub ActionsObservabilityEngineeringDatabricksanalyticalSnowflakedesigningBigQueryRedshiftbuildingwrittenTestNGPythondesignGitCI/CDCloudDesign PatternsAPIsdbtSQLCICD
Key highlights
- Senior Software Engineer role in Bangalore
- Competitive compensation: Market-leading salary, equity, comprehensive health insurance
- Open-source ownership: Public, named maintainer of MetricFlow
- Impact at scale: Code runs in tens of thousands of companies
- Hybrid work model (#LI-HYBRID)
- RSU stock grants
Role overview
Fivetran and dbt Labs are merging to deliver a unified data infrastructure layer, helping organizations move, transform, and trust their data. The Semantic Layer team owns MetricFlow, an open-source semantic engine that powers the dbt Semantic Layer, enabling data teams to define metrics once and consume them consistently across BI tools, notebooks, AI agents, and downstream applications. We are hiring a Senior Software Engineer in Bangalore to be a core contributor to MetricFlow, designing features, optimizing query generation, and engaging with the open-source community. This high-ownership role involves writing production code, driving technical decisions, and shaping the long-term architecture of a foundational project in the modern data stack.
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 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.
Requirements
- 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.
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 Week of Rest), 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.
Additional details
- Fivetran’s mission is to make access to data as simple and reliable as electricity.
- Fivetran and dbt Labs are bringing together two industry-leading companies with a shared mission: helping organizations unlock the full value of their data.
- The Semantic Layer team is the steward of MetricFlow as an open-source project.
- This is a high-ownership role with visibility in the global data community.
- A team that values craft: design docs, code review, and durable engineering.
- Fivetran is valued at over $5.6 billion.
- Fivetran promotes diversity, equity, inclusion & belonging.
- Fivetran is committed to ensuring equal opportunity in the interview process and provides accommodations for disabilities or medical conditions.
- #LI-HYBRID
- #LI-SA1
- *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.
- Read about Fivetran in Forbes.
- 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.