Build and optimize the core of a distributed compute engine in Rust for SQL and AI query processing. Responsibilities include designing and delivering engine capabilities, improving query performance, writing maintainable code, and solving complex systems and concurrency problems. The role requires expertise in data structures, algorithms, performance optimization, systems programming, hardware fundamentals, asynchronous programming, atomics, locks, and cache design.