Staff Software Engineer – Semantic Layer

This is a fully remote position, open to applicants in India.

📋 Description

• Design, develop, and maintain the essential features of MetricFlow, which includes metric definitions, query compilation, dimensional modeling, and SQL generation across various data warehouses such as Snowflake, BigQuery, Databricks, Redshift, and more.

• Take ownership of MetricFlow as an open-source initiative — manage issue triage, review contributions from outside developers, oversee release management, and foster community engagement on GitHub and Slack.

• Work collaboratively with engineers from dbt Cloud, dbt Core, and the Semantic Layer service to guarantee that MetricFlow integrates smoothly within the overall dbt ecosystem.

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

• Collaborate with product, design, and developer relations teams to convert customer and community insights into implemented enhancements.

• Produce clear technical documentation, requests for comments (RFCs), and design documents that elevate the team's standards for thinking and delivery.

• Provide mentorship to fellow engineers through code reviews, collaborative programming, and technical advice.

⛳️ Requirements

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

• Profound expertise in Python, encompassing modern typing, testing methodologies, and packaging.

• Strong foundational knowledge of SQL and an 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.

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

• Exceptional written and verbal communication skills — capable of conveying complex trade-offs clearly to engineers, product managers, and members of the external community.

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