Distinguished Systems Developer - SQL Engine

InterSystems

Where
Boston, MA
Pay
$144K to $205K a year

Posted 10 months ago· Checked live at InterSystems 2 hours ago

Stale: open 310 daysUp for more than two weeks. It may already be filled.

See how you score for this job

One sentence and your resume. We score it against what InterSystems asks for, line by line.

See my score
Is this job still open?
Yes. We checked it live on InterSystems's own hiring page 2 hours ago.
What is the job?
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.
What does it pay?
$144K to $205K a year, as the posting states.
Our verdict
Stale. Up for more than two weeks. It may already be filled.

What the job is

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.

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.

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

The estimated base compensation range for this role is

$144,000 - $205,000 USD

Similar open jobs

Software engineer jobs in Boston (368)Jobs in Boston (7098)