- 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
- Robust 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 domainRole & responsibilities
Preferred candidate profile
📌 Back-end Engineer - Query / API (Karnataka)
🏢 Avig Business Solutions
📍 Karnataka
Reply to this offer
Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.