About the role
<p>&nbsp;</p> <p>At&nbsp;<strong>InterSystems</strong>, we’re redefining the future of analytics and intelligent data platforms. Our high-performance, hyper-capacity engine supports a&nbsp;<strong>multi-model storage layer</strong>—blending structured, semi-structured, and unstructured data—to power a new generation of&nbsp;<strong>AI-native and real-time workloads</strong>.</p> <p>We believe in technical&nbsp;<strong>craftsmanship</strong>, deep&nbsp;<strong>collaboration</strong>, and a culture where ambitious people can build bold systems. The SQL Engine group is the nerve center of our product—where&nbsp;<strong>query processing meets distributed intelligence</strong>. We consider engineering a science, an art, and a craft, and we cultivate an environment where the most talented minds can thrive, innovate, and make a lasting impact.</p> <p>This is your chance to design the core foundations of a data platform trusted by the world's most mission critical systems and AI research teams.</p> <p><strong>What You’ll Do</strong></p> <p>As a Distinguished Developer in the SQL Engine group, you'll help build the&nbsp;<strong>next-generation query processing stack</strong>, optimizing across both traditional analytics and emerging AI-driven workloads. You’ll contribute to:</p> <ul> <li><strong>Query parsing, validation, and transformation</strong></li> <li><strong>Logical/physical optimization over multi-model data (row, columnar, stream, document, vector)</strong></li> <li><strong>Plan generation and adaptive execution strategies</strong></li> <li><strong>Code generation and vectorized execution</strong></li> <li><strong>Compiler-accelerated storage access patterns for AI workflows</strong></li> <li><strong>Collaborative integration with our multi-model storage engine</strong></li> </ul> <p>You’ll design&nbsp;<strong>data processing abstractions and execution engines</strong>&nbsp;that enable&nbsp;<strong>AI-native features</strong>&nbsp;like fast vector search, graph traversal, and probabilistic joins—all within a familiar SQL interface.</p> <p><strong>Your Impact</strong></p> <ul> <li>Architect and implement&nbsp;<strong>query optimization and execution components</strong>&nbsp;that scale across petabytes</li> <li>Design tooling and frameworks that make&nbsp;<strong>AI and analytics convergence seamless</strong></li> <li>Collaborate with platform and storage teams to leverage&nbsp;<strong>multi-model indexing and caching strategies</st