Distinguished Systems Developer - SQL Engine

<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</strong></li> <li>Contribute to building&nbsp;<strong>programmable, intelligent data pipelines</strong>&nbsp;that drive downstream ML model performance</li> <li>Mentor engineers, guide technical debates, and influence long-term system direction</li> <li>Champion a culture of&nbsp;<strong>quality, rigor, and innovation</strong></li> </ul> <p><strong>What We’re Looking For</strong></p> <ul> <li><strong>10+ years</strong>&nbsp;of experience in systems-level or database internals engineering</li> <li>Proven expertise in&nbsp;<strong>SQL query engines</strong>,&nbsp;<strong>optimizers</strong>,&nbsp;<strong>execution runtimes</strong>, or&nbsp;<strong>data compiler toolchains</strong></li> <li>Experience with&nbsp;<strong>multi-model data systems</strong>&nbsp;(SQL + JSON, vector search, graph traversal)</li> <li>Expert in at least one&nbsp;<strong>systems programming languages, or LLVM-based codegen environments</strong></li> <li>Strong grasp of&nbsp;<strong>relational algebra</strong>,&nbsp;<strong>compiler construction</strong>, and&nbsp;<strong>data-intensive workloads</strong></li> <li>Familiarity with&nbsp;<strong>AI infrastructure or ML inference pipelines</strong>&nbsp;is a strong plus</li> <li>Passion for designing software that balances&nbsp;<strong>performance, correctness, and usability</strong></li> <li><strong>PHD degree </strong>or published research experience is highly advantageous.</li> </ul> <p><strong>Our Engineering Culture</strong></p> <ul> <li><strong>Innovation is expected</strong>: Engineers propose, prototype, and lead from the front</li> <li><strong>Excellence over ego</strong>: Code is debated, ideas are tested, and the best ones win</li> <li><strong>Long-term vision</strong>: We optimize for architectural clarity and product longevity</li> <li><strong>Cross-domain thinking</strong>: We solve storage, processing, and AI problems together</li> <li><strong>Sane pace, deep focus</strong>: We value craft, creativity, and time to do both well</li> </ul> <p><strong>Ready to Build What’s Next?</strong></p> <p>If you dream of working on&nbsp;<strong>deep query systems</strong>, love&nbsp;<strong>systems-level programming</strong>, and want to help create a platform that bridges&nbsp;<strong>SQL, multi-model data, and AI</strong>—we’d love to talk.</p> <p>&nbsp;</p> <hr> <p><em>We are an equal-opportunity employer and do not discriminate because of race, color, religion, sex, national origin, ancestry, marital status, veteran status, age, disability, sexual orientation or gender identity or expression or any other legally protected category. InterSystems is an E-Verify Employer in the United States.</em></p><div class="content-pay-transparency"><div class="pay-input"><div class="description"><p><span style="font-size: 14px;">InterSystems is providing a current good faith estimate of the anticipated base salary range for this position depending on a variety of factors including experience, education, skills, and performance.</span></p> <p><span style="font-size: 14px;">Other compensation may include a discretionary annual variable target incentive.</span></p> <p><span style="font-size: 14px;">The company also provides generous employee benefits including:</span></p> <ul> <li style="font-size: 14px;"><span style="font-size: 14px;">Medical, vision, and dental insurance</span></li> <li style="font-size: 14px;"><span style="font-size: 14px;">Short-term and long-term disability, and life insurance</span></li> <li style="font-size: 14px;"><span style="font-size: 14px;">401(k) Profit Sharing Contribution</span></li> <li style="font-size: 14px;"><span style="font-size: 14px;">Paid Time Off and Holidays</span></li> <li style="font-size: 14px;"><span style="font-size: 14px;">Parental Leave</span></li> <li style="font-size: 14px;"><span style="font-size: 14px;">Tuition reimbursement</span></li> </ul></div><div class="title">The estimated base compensation range for this role is:</div><div class="pay-range"><span>$144,000</span><span class="divider">&mdash;</span><span>$205,000 USD</span></div></div></div><div class="content-conclusion"><p style="font-weight: 400;"><strong>About InterSystems</strong></p> <p style="font-weight: 400;">InterSystems, a creative data technology provider, delivers a unified foundation for next-generation applications for healthcare, finance, manufacturing, and supply chain customers in more than 80 countries. Our data platforms solve interoperability, speed, and scalability problems for large organizations around the globe to unlock the power of data and allow people to perceive data in imaginative ways. Established in 1978, InterSystems is committed to excellence through its 24×7 support for customers and partners around the world. Privately held and headquartered in Boston, Massachusetts, InterSystems has 38 offices in 28 countries worldwide. For more information, please visit&nbsp;<a href="https://cts.businesswire.com/ct/CT?id=smartlink&amp;url=https://www.intersystems.com/&amp;esheet=53379223&amp;newsitemid=20230410005415&amp;lan=en-US&amp;anchor=InterSystems.com&amp;index=4&amp;md5=3edf749fa33f5a2ac0c355c410576e90" data-outlook-id="1e721f69-f681-4067-9281-970e94b3ef11"><strong>InterSystems.com</strong></a>.</p></div>