Full-Time

Clickhouse Engineer

Posted on 4/18/2024

PostHog

PostHog

11-50 employees

Open source platform for product analytics

Data & Analytics

Junior, Mid, Senior

Remote in USA

Required Skills
Kubernetes
Python
AWS
Terraform
Ansible
Requirements
  • Proficiency in Python, Kubernetes, and AWS.
  • Experience building and operating high-scale complex data storage solutions
  • Strong interest and experience in ClickHouse (or similar OLAP databases) internals and query performance optimization
  • Can thrive in a culture of autonomy and self-direction
Responsibilities
  • Develop tooling for full and incremental backup and restore processes for ClickHouse clusters
  • Create schema and mutation management tools to make it easy for teams at PostHog to manage their own tables
  • Enhance visibility into cluster statuses
  • Automate dynamic provisioning of instances, utilizing Terraform and Ansible
  • Build query benchmarking and performance tooling to help engineers in identifying and optimize expensive queries
  • Make everythingā€”schema, queries, and cluster configurationsā€”faster and more efficient

PostHog provides a dynamic work environment due to its focus on open source technologies, allowing for continuous learning and collaboration in the development of comprehensive product analytics tools. By providing extensive features like event pipelines and API integrations, the company stands as a leader in facilitating advanced product development and analysis. This makes it a prime workplace for professionals keen on advancing their skills in a cutting-edge, data-centric industry.

Company Stage

Series B

Total Funding

$39.2M

Headquarters

San Francisco, California

Founded

2020

Growth & Insights
Headcount

6 month growth

ā†‘ 2%

1 year growth

ā†‘ 20%

2 year growth

ā†‘ 41%