Staff Engineer, DAX-Like BI Engine (Pune Division)

About The Role Build the next-generation DAX-like formula engine that turns complex evaluation contexts into effective SQL on up-to-date 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 (diagr .