About The Role

Build the next-generation DAX-like formula engine that turns complex evaluation contexts into productive SQL on modern data warehouses. As a Staff Engineer on the BI Engine team, you will own the core compiler and runtime for our standalone dax_engine — spanning the parser, metadata layer, query planner, SQL translation backends, and client connectivity — and deliver a BI experience that faithfully mirrors native models while integrating tightly with Arrow- and DuckDB-based storage.

Responsibilities

Engine Ownership:

Own the Spotonix BI engine end to end BI catalog and metadata, formula-language grammar and parser, query planner and optimizer, SQL generation,execution layers, client connectivity,session management, and multi-dialect SQL support.
Drive observability for plan generation, SQL issuance, and cache effectiveness, partnering with integrations teams to support additional warehouses, metadata loaders, and client APIs.

Compiler & Query Planning

Design and optimize the query compiler that lowers expressions into an internal multidimensional algebra,



applies rule- and cost-based transformations, orchestrates algebraic plans, manages evaluation contexts, and enforces lineage propagation before emitting SQL.
Evolve the execution runtime translate complex algebra into SQL with maximum warehouse pushdown and expose the instrumentation hooks needed by clients and regression suites.

BI Algebra Design

Own the BI algebra itself define and implement the suite of DAX,MDX-style operators (hierarchy navigation, cube operators, table manipulations, iterators) and ensure each algebraic primitive ships with tests and SQL strategies.
Expand DAX function coverage and time-intelligence patterns while maintaining correctness and semantic fidelity across all supported warehouse backends.

Technical Leadership & Collaboration

Mentor engineers on query-compilation fundamentals, context transition debugging, and deterministic developer workflows (diagram genera

📌 Staff Engineer, DAX-Like BI Engine (Pune)
🏢 Spotonix
📍 Pune