Software Engineer — Hog/QL

Posted 22 Days Ago
Hiring Remotely in USA
Remote
Mid level
Software • Analytics
The Role
You will design and expand PostHog's SQL dialect and programming language capabilities, impacting all engineers and external users significantly.
Summary Generated by Built In
About PostHog

We equip every developer to build successful products.

We started with open-source product analytics, launched out of Y Combinator's W20 cohort.

We've since shipped more than a dozen products, including a built-in data warehouse, a customer data platform, and PostHog AI, an AI-powered analyst that answers product questions, helps users find useful session recordings, and writes custom SQL queries.

Next on the roadmap are messaging, customer analytics, ai task creation and coding based on customer data, logs and support analytics.
Our values are not a poster on the wall full of aspiration. They’ve come from how we really work, day in day out.

PostHog is Open Source, product led, and a default alive company that is well funded.

What you'll be doing


PostHog has created two languages that power almost all our products.

PostHog SQL (aka HogQL): our SQL dialect that wraps ClickHouse SQL, and provides a safe and flexible way to query data in our systems. Any data that's queried and returned to our app goes through this layer.

Hog: a programming language used to transform data in our realtime pipelines. Hog is SQL-compatible, and runs in a bytecode VM that can be embedded into Python, TypeScript and Rust programs.

You will be building and expanding our language capabilities. Some examples of what you might be working on are: adding support for objects into the Hog language, adding the create table statement to our data warehouse, or improving the select query tag for product analytics.

You’ll have a large impact on the company since every engineer in the company interacts with this layer, as well as most external users.
You’ll also need to keep up with the latest developments of the downstream query targets and document languages thoroughly.

You’ll fit right in if:

  • You’re a builder. You bring strong skills in building software at a product company and solid language design skills.
    For the language design we’re talking about actual practical implementation versus theoretical research, preferably in a work environment.

  • You have good knowledge of what’s out there. You are keeping up with the latest developments of the downstream query targets (Postgres, ClickHouse, DuckDB, Athena, etc.)

  • You have experience building compilers and/or interpreters

  • You bring experience with writing complex ANTLR grammar.

  • You bring programming and SQL skills. Python and C++ are a must, so is SQL. Experience with Rust is welcome.

  • You love getting things done. Engineers at PostHog have an incredible amount of autonomy to decide what to work on, so you’ll need to be proactive and just git it done.

  • You’re ready to do the best work of your career. We have incredible distribution, a big financial cushion and an amazing team. There’s probably no better place to see how far you can go.

If this sounds like you, we should talk.

We are committed to ensuring a fair and accessible interview process. If you need any accommodations or adjustments, please let us know

What’s in it for you?

Now that we've told you what you'll be building with us, let's talk about what we'll be building for you.


Top Skills

C++
Clickhouse
Posthog Sql
Python
Rust
Typescript
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: San Francisco, CA
60 Employees
Year Founded: 2020

What We Do

At PostHog, we're working to increase the number of successful products in the world.

Until now, tools for building products have been fragmented. Product analytics, heatmaps, session recording, web analytics, feature flags, and A/B testing are all helpful, but no one wants to buy, send data to, and integrate multiple products.

PostHog offers these tools (and more) in an integrated, open source platform which can be hosted in either the US or EU. Both versions are SOC2 certified, GDPR-ready, and HIPAA compliant.

We started PostHog during Y Combinator's W20 cohort and had the most successful B2B software launch on Hacker News since 2012 - with a product that was just 4 weeks old.

With over 100,000 users, we're default alive, growing 97% through word of mouth, and we are in the top 0.01% most popular repos on GitHub.

Similar Jobs

MetLife Logo MetLife

Customer Care Advocate Virtual Training Omaha 12.15.25

Fintech • Information Technology • Insurance • Financial Services • Big Data Analytics
Remote or Hybrid
Omaha, NE, USA
43000 Employees
20-20 Hourly

Applied Systems Logo Applied Systems

Bilingual Associate Customer Support Technician

Cloud • Insurance • Payments • Software • Business Intelligence • App development • Big Data Analytics
Remote or Hybrid
2 Locations
3000 Employees
42K-52K Annually

Applied Systems Logo Applied Systems

Development Engineer

Cloud • Insurance • Payments • Software • Business Intelligence • App development • Big Data Analytics
Remote or Hybrid
2 Locations
3000 Employees

Chamberlain Group Logo Chamberlain Group

Sr. Field Marketing Representative

Automotive • Hardware • Internet of Things • Mobile • Software • App development • PropTech
Remote or Hybrid
2 Locations
5769 Employees
80K-131K Annually

Similar Companies Hiring

Standard Template Labs Thumbnail
Software • Information Technology • Artificial Intelligence
New York, NY
10 Employees
PRIMA Thumbnail
Travel • Software • Marketing Tech • Hospitality • eCommerce
US
15 Employees
Scotch Thumbnail
Software • Retail • Payments • Fintech • eCommerce • Artificial Intelligence • Analytics
US
25 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account