Distinguished Systems Developer - SQL Engine
InterSystemsBoston, Massachusetts, United States · Posted 7 months agoDescription
At InterSystems, we’re redefining the future of analytics and intelligent data platforms. Our high-performance, hyper-capacity engine supports a multi-model storage layer—blending structured, semi-structured, and unstructured data—to power a new generation of AI-native and real-time workloads.
We believe in technical craftsmanship, deep collaboration, and a culture where ambitious people can build bold systems. The SQL Engine group is the nerve center of our product—where query processing meets distributed intelligence. 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.
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.
What You’ll Do
As a Distinguished Developer in the SQL Engine group, you'll help build the next-generation query processing stack, optimizing across both traditional analytics and emerging AI-driven workloads. You’ll contribute to:
- Query parsing, validation, and transformation
- Logical/physical optimization over multi-model data (row, columnar, stream, document, vector)
- Plan generation and adaptive execution strategies
- Code generation and vectorized execution
- Compiler-accelerated storage access patterns for AI workflows
- Collaborative integration with our multi-model storage engine
You’ll design data processing abstractions and execution engines that enable AI-native features like fast vector search, graph traversal, and probabilistic joins—all within a familiar SQL interface.
Your Impact
- Architect and implement query optimization and execution components that scale across petabytes
- Design tooling and frameworks that make AI and analytics convergence seamless
- Collaborate with platform and storage teams to leverage multi-model indexing and caching strategies
- Contribute to building programmable, intelligent data pipelines that drive downstream ML model performance
- Mentor engineers, guide technical debates, and influence long-term system direction
- Champion a culture of quality, rigor, and innovation
What We’re Looking For
- 10+ years of experience in systems-level or database internals engineering
- Proven expertise in SQL query engines, optimizers, execution runtimes, or data compiler toolchains
- Experience with multi-model data systems (SQL + JSON, vector search, graph traversal)
- Expert in at least one systems programming languages, or LLVM-based codegen environments
- Strong grasp of relational algebra, compiler construction, and data-intensive workloads
- Familiarity with AI infrastructure or ML inference pipelines is a strong plus
- Experience using AI-assisted tools (e.g. copilots, summarisation tools, or chatbots) with an ability to critically evaluate and verify AI-generated outputs
- Demonstrated ability to learn, evaluate, adapt to, propose and implement AI-augmented workflows in order to continually enhance your own, and the team’s productivity
- Passion for designing software that balances performance, correctness, and usability
- PHD degree or published research experience is highly advantageous.
Our Engineering Culture
- Innovation is expected: Engineers propose, prototype, and lead from the front
- Excellence over ego: Code is debated, ideas are tested, and the best ones win
- Long-term vision: We optimize for architectural clarity and product longevity
- Cross-domain thinking: We solve storage, processing, and AI problems together
- Sane pace, deep focus: We value craft, creativity, and time to do both well
Ready to Build What’s Next?
If you dream of working on deep query systems, love systems-level programming, and want to help create a platform that bridges SQL, multi-model data, and AI—we’d love to talk.
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.
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.
Other compensation may include a discretionary annual variable target incentive.
The company also provides generous employee benefits including:
- Medical, vision, and dental insurance
- Short-term and long-term disability, and life insurance
- 401(k) Profit Sharing Contribution
- Paid Time Off and Holidays
- Parental Leave
- Tuition reimbursement
About InterSystems
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 InterSystems.com.
AI Disclaimer
InterSystems may use AI tools for its internal operations including administrative tasks during recruitment (e.g., organizing candidate information). InterSystems’ approach to AI is guided by the InterSystems Responsible AI Guidelines. AI is not used to make or influence hiring decisions. All decisions are made by InterSystems employees.
Candidates may use AI for CV or interview preparation, provided materials are truthful and reflect their own experience. AI tools and third-party transcription services must not be used during interviews or assessments.
Please note that the use of wearable technology, including any AI-related tools or other technology-connected devices (such as META or Google smart glasses and/or wearables, and/or any similar devices), is strictly prohibited during the interview and screening process with InterSystems. Any applicant who requires a wearable device or any type of technology support during the interview process as a reasonable accommodation under the ADA or applicable state or country laws and regulations must contact the InterSystems Human Resources Department prior to attending or participating in any interview or screening process.
Similar jobs
Est. 174,500 USD
The InterSystems IRIS data platform is the engine behind some of the world’s most important applications. At its core is a super scalable, high performance database engine built to naturally and flexibly store data acces…
Est. 247,000 USD
InterSystems is seeking a strategic and technically hands-on Director of Development to lead innovation and execution for the Data Models engineering team, as well as core platform architecture initiatives across the bro…
Est. 157,500 USD
The Technical Services Engineer III is responsible for the design, availability, performance, and security of InterSystems’ corporate infrastructure (virtual and physical). This includes on premises, private cloud, and d…
Est. 111,000 USD
The Technical Services Engineer II is responsible for the availability, performance, and security of InterSystems’ corporate infrastructure (virtual and physical). This includes on premises, private cloud, and data cente…
Est. 149,500 USD
Platform Engineering is seeking an experienced engineering manager to lead a team responsible for building and evolving the internal platforms that power software development across the company. This role leads engineers…
Est. 137,000 USD
Our Platform Engineering team builds and evolves the internal platforms that power software development across InterSystems. We develop build systems, developer tools, cloud-native infrastructure, automation, and AI-enab…
Est. 166,000 USD
InterSystems is a global leader in healthcare data management and interoperability, providing mission-critical technology that powers hospitals, health systems, and national infrastructures worldwide. Our products underp…
Est. 114,000 USD
InterSystems is the place for someone looking for a challenging IT career and access to the kind of training, expertise and development tools that only a large company can offer. Our international reach also means you ha…
Est. 114,000 USD
Join InterSystems as a Senior Quality Development Systems Engineer, and contribute to developing high quality, robust software by building the validation systems that certify customer-scale behavior and release readiness…
Est. 173,000 USD
We are seeking a Principal Cloud Kubernetes Engineer to join our global infrastructure team to lead the architecture, strategy, and evolution of our cloud-native platform across public cloud and on-premises environments.…
Est. 114,000 USD
Join InterSystems and help us shape the future of digital healthcare. The sheer scale of our capabilities and client engagements and the way we collaborate, operate and deliver value provides an unparalleled opportunity…
Est. 128,500 USD
At InterSystems, we’re building the next generation of powerful, intuitive software for critical systems across healthcare, finance, data management, and beyond. As a Senior UX Designer on our UX team, you’ll help shape…
Est. 67,451 USD
Administrative Assistant The Administrative Assistant will provide a full range of administrative support to their assigned stakeholders. The employee must be highly professional, detail oriented, and exhibit strong orga…
Est. 51,000 EUR
The Platform Engineer is responsible for designing, automating, governing, and optimizing the technical platforms, environments, and infrastructure supporting software implementations. The role leverages AI-assisted plat…
Est. 131,500 USD
We are seeking a highly skilled Clinical Informatics Specialist to play a pivotal role in the architecture and development of our canonical data model and transformation framework within the InterSystems ecosystem. Focus…
Est. 114,000 USD
Join InterSystems and help us build the next generation of the EMR. The sheer scale of our capabilities and client engagements and the way we collaborate, operate and deliver value provides an unparalleled opportunity to…
Est. 114,000 USD
As a Senior Quality Development Engineer on the InterSystems IRIS® Data Platforms Health team, you will contribute to the development of high quality, robust InterSystems software by uncovering weaknesses and areas for i…
Est. 139,500 USD
Join InterSystems and help us build the next generation of the EMR. The sheer scale of our capabilities and client engagements and the way we collaborate, operate and deliver value provides an unparalleled opportunity to…
Est. 165,000 USD
Cloud Security Architect A cloud security architect must be conversant with a breadth of technologies used to protect data, workloads, and systems within cloud platforms. Responsibilities of a cloud security architect in…
Est. 148,000 USD
InterSystems technology powers some of the world’s most mission-critical applications, managing over one billion patient records globally. The Government Affairs role is responsible for shaping public policy and legislat…
Est. 210,500 USD
InterSystems is seeking a Senior Advisor, Healthcare Delivery, North America IDNs / Providers to join our Global Healthcare Market Strategy team. This senior-level individual contributor will own the market narrative, dr…
Est. 167,500 USD
The Chief Architect for HealthShare is accountable for the architectural direction of the HealthShare platform and its evolution toward a more adoptable, upgradeable, and operationally efficient product. This role works…
Est. 151,000 USD
As the Cloud Alliances Manager – North America, you will be responsible for defining the joint GTM strategy with top cloud partners. You will execute on this strategy in order to drive revenue growth through these partne…
Est. 108,000 USD
InterSystems Corporation, a leading developer of database and integration technologies, is seeking candidates for its North American Sales Engineering Group. The role is client-facing, fast-paced, wide-ranging and challe…
Est. 108,000 USD
InterSystems Corporation, a leading developer of database and integration technologies, is seeking candidates for its North American Financial Services Sales Engineering Group. The role is client-facing, fast-paced, wide…
Est. 113,500 USD
As the Partner Manager, Healthcare – North America, you will be responsible for driving partner-sourced and partner-influenced revenue by building, managing, and scaling high-performing healthcare partners across the Uni…
Est. 142,000 USD
We are seeking an experienced Technical Program Manager to support the growth of the world's most innovative HealthCare data platform. InterSystems HealthShare is the engine behind some of the world's most critical healt…
Est. 137,500 USD
We are seeking an experienced Engagement Manager to lead managed services engagements for healthcare organizations leveraging InterSystems technologies, including IRIS, IRIS for Health, HealthShare, IntelliCare, TrakCare…
Est. 148,500 USD
As a Quality Development Manager, you will contribute to developing high quality, robust InterSystems HealthShare® software by working hard to uncover weaknesses and areas for improvement. If you are passionate about sof…
Est. 114,000 USD
Join InterSystems and help us build the next generation of the EMR. The sheer scale of our capabilities and client engagements and the way we collaborate, operate and deliver value provides an unparalleled opportunity to…