Distinguished Systems Developer - SQL Engine

InterSystems
Boston
Workplace: OnsiteFull timeUSD 144,000 - 205,000 annuallyFunction: Software EngineeringExperience: 10+ yearsSkills: ["Mentorship","Technical leadership","Collaboration","Quality focus"]

Design and build InterSystems’ next-generation query processing stack in the SQL Engine group, spanning query parsing through logical/physical optimization and adaptive execution. Work on code generation and vectorized execution, and collaborate with platform and storage teams to integrate multi-model indexing and caching. Enable AI-native features like fast vector search, graph traversal, and probabilistic joins within a familiar SQL interface at petabyte scale, while mentoring engineers.

Loading

Loading job details...

Preparing the role view and application actions.

FursaFursa
InterSystems
InterSystems
7 months ago

Distinguished Systems Developer - SQL Engine

✓ Verified Job

Canonical indexed version, validated from employer's careers page.

Source: Company careers pageValidated by: Fursa AI
Last checked: 18 hours agoStatus: Live

Job Summary

Design and build InterSystems’ next-generation query processing stack in the SQL Engine group, spanning query parsing through logical/physical optimization and adaptive execution. Work on code generation and vectorized execution, and collaborate with platform and storage teams to integrate multi-model indexing and caching. Enable AI-native features like fast vector search, graph traversal, and probabilistic joins within a familiar SQL interface at petabyte scale, while mentoring engineers.
Location: Boston
Workplace: Onsite
Employment Type: Full time
Job Function: Software Engineering
Seniority: Mid level

Key Responsibilities

  • •Build query parsing, validation, transformation, and the next-generation query processing stack.
  • •Implement logical/physical optimization across multi-model data and develop plan generation with adaptive execution strategies.
  • •Create code generation and vectorized execution, including compiler-accelerated storage access patterns for AI workflows.
  • •Design data processing abstractions and execution engines enabling AI-native features like vector search, graph traversal, and probabilistic joins within a SQL interface.
  • •Mentor engineers, guide technical debates, and collaborate with platform and storage teams on multi-model indexing and caching strategies.

Pay and Benefits

Salary: USD 144,000 - 205,000 annually
Perks:Health InsuranceVisionDental401kPaid LeaveParental LeaveLife InsuranceDisability Insurance

Key Requirements

  • •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 language or LLVM-based codegen environments.
  • •Strong grasp of relational algebra, compiler construction, and data-intensive workloads.
Experience:10+ years
Skills:MentorshipTechnical leadershipCollaborationQuality focus
Languages:English
Tech Stack:SQLJSONVector searchGraph traversalRelational algebraCompiler constructionLLVM

Company Brief

InterSystems
Develops database management, interoperability, and analytics platforms—particularly for healthcare and financial services. Known for products like Caché, Ensemble, HealthShare and the InterSystems IRIS data platform enabling integrated data management and real-time applications.
Industry: Data Infrastructure
Company Size: Enterprise (1,001+ employees)
Growth: Established Company
Headquarters: Cambridge, United States
Founded: 1978
WebsiteLinkedIn