Backend Engineer

Data warehousing is a core product for PostHog users and a foundational platform for internal teams. As a Backend Engineer, you'll help build the tools that enable users to import, transform, and analyze their data via SQL, while also creating the infrastructure that powers current and future PostHog features. Our data stack is end-to-end, developing our own SQL parser from scratch, building pipelines to import data from APIs and databases, creating a SQL editor for data exploration, and developing a materialization pipeline to transform and serve data efficiently. Your core responsibility will be to maintain and grow our data pipeline that enables our users to import their data from API and database sources. The work will span anything from expanding the source library for our users to refactoring how we stream data from ClickHouse to object storage using Arrow. You should be very comfortable building well-architected and well-tested code but also pragmatic and know how to scope implementations in a way that allows you to ship fast.