Senior Software Engineer, Semantic Layer

📋 Description

• Design, develop, and sustain the essential features of MetricFlow, which includes metric definitions, query compilation, dimensional modeling, and SQL generation across various data warehouses (Snowflake, BigQuery, Databricks, Redshift, and others).

• Take ownership of MetricFlow as an open-source initiative — manage issue triaging, review external pull requests, oversee releases, and engage with the community on GitHub and Slack.

• Collaborate with engineers working on dbt Cloud, dbt Core, and the Semantic Layer service to ensure MetricFlow integrates smoothly with the broader dbt ecosystem.

• Enhance the performance, reliability, and observability of metric query execution at scale.

• Work alongside product, design, and developer-relations teams to convert customer and community feedback into implemented enhancements.

• Produce clear technical documentation, RFCs, and design documents that elevate the team's standards for thinking and delivering.

• Mentor fellow engineers through code reviews, pairing, and providing technical guidance.

⛳️ Requirements

• Significant professional software engineering experience, with a proven history of delivering production systems.

• Extensive expertise in Python, including modern typing, testing methodologies, and packaging.

• Strong foundation in SQL and a working understanding of how analytical query engines and data warehouses process queries.

• Experience in designing systems that entail parsing, compilation, or transformation — such as query planners, DSL compilers, type systems, or rule-based engines.

• Solid understanding of software design principles: clean APIs, modularity, testability, and backward compatibility.

• Exceptional written and verbal communication skills — capable of clearly articulating complex trade-offs to engineers, PMs, and external community members.

• Experience working in a distributed, asynchronous team environment.

🏝️ Benefits

• Competitive compensation: Market-leading salary, equity, comprehensive health insurance, generous time off, learning & wellness stipends, and support for home-office expenses.