Staff Software Engineer

ABOUT THE ROLE We're hiring a Staff Software Engineer to join the Semantic Layer team at Fivetran and dbt Labs. This is a high-ownership role where you'll design, build, and maintain core features of MetricFlow, an open-source semantic engine that powers the dbt Semantic Layer. As a key contributor to MetricFlow, you'll work at the intersection of language design, query compilation, and distributed data execution, solving problems that directly shape how thousands of organizations measure their business. WHAT YOU'LL DO As a Staff Software Engineer, you'll be responsible for designing, building, and maintaining core features of MetricFlow, including metric definitions, query compilation, dimensional modeling, and SQL generation across multiple data warehouses. You'll also own MetricFlow as an open-source project, triage issues, review external pull requests, manage releases, and engage the community on GitHub and in Slack. Additionally, you'll 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. You'll also 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, and write clear technical documentation, RFCs, and design docs. WHAT YOU'LL NEED To be successful in this role, you'll need strong professional software engineering experience, with a strong track record of shipping production systems. You should have deep proficiency in Python, including modern typing, testing practices, and packaging. You should also have 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 is also essential. Finally, you should have a solid grasp of software design principles, including clean APIs, modularity, testability, and scalability. WHY REMOTE As a remote team, we're committed to providing a flexible and inclusive work environment that allows our engineers to work from anywhere. We believe that this approach enables us to attract and retain top talent from around the world and fosters a culture of collaboration, innovation, and excellence. BENEFITS We offer a competitive salary, stock options, and a comprehensive benefits package, including health insurance, parental leave, and education stipend. We're committed to supporting our employees' growth and development, and we provide opportunities for professional growth, mentorship, and career advancement.