01Overview
Back-end Engineer - Query / API
Deep ClickHouse - query optimization, materialized views, projections, partition pruning, ARRAY JOIN, aggregation states
Has built and operated latency-sensitive analytics APIs at scale - thinks p95/p99, not just correctness
Multi-tenant query isolation and quota patterns
Strong API design - REST and ideally GraphQL; pagination, filtering, faceting over high-cardinality data
Caching strategies - query-result, materialized, edge
Aurora/PostgreSQL for relational/transactional data alongside the OLAP store
Node.js or Go for API layers; TypeScript across the stack a plus
Active user of AI coding tools (Cursor, Claude Code, or equivalent)
Bonus: federated query systems (Trino, Presto, ClickHouse remote tables)
Bonus: ML inference serving / feature stores
Bonus: streaming, video, or observability domain
Preferred candidate profile .
