Senior SQL Engine Architect for AI-Powered Analytics

InterSystems; Boston (MA); On-site; USD 144,000 - 205,000; Full time

Benefits offered by this job

Medical, vision, and dental insurance

Short-term and long-term disability, &

life insurance

401(k) Profit Sharing Contribution

Paid Time Off and Holidays

Parental Leave

Tuition reimbursement

Job summary

InterSystems in Boston is seeking a Distinguished Developer for the SQL Engine group to define the next-generation query processing stack for analytics and AI workloads. You will contribute to parsing, optimization, plan generation, and vectorized execution within a multi-model data platform.

You will design data processing abstractions and execution engines that enable AI-native features like fast vector search, graph traversal, and probabilistic joins within a familiar SQL interface, while

Qualifications

• 10 years of experience in systems-level or database internals engineering.
• Expertise in SQL query engines, optimizers, execution runtimes, or data compiler toolchains.
• Experience with multi-model data systems (SQL JSON, vector search, graph traversal).
• Proficiency in at least one systems programming language 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.
• Passion for performance, correctness, and usability.
• PhD degree or published research experience is advantageous.

Responsibilities

• Design next-generation query processing stack for analytics and AI workloads.
• Contribute to parsing, validation, and transformation of queries.
• Perform logical/physical optimization over multi-model data (row, columnar, stream, document, vector).
• Handle plan generation and adaptive execution strategies.
• Develop code generation and vectorized execution techniques.
• Improve compiler-accelerated storage access patterns for AI workflows.
• Collaborate with our multi-model storage engine.
• Design data processing abstractions and execution engines enabling AI-native features in SQL.
• Architect and implement query optimization and execution components at scale.
• Build tooling for AI and analytics convergence; work on indexing and caching strategies.
• Mentor engineers and influence long-term system direction; champion quality and innovation.

Skills

SQL query engines

optimizers

execution runtimes

data compiler toolchains

multi-model data systems

systems programming languages

LLVM codegen

relational algebra

compiler construction

AI infrastructure familiarity

quality and usability focus

PhD or research experience

Education

PhD degree or published research experience

Job description

InterSystems in Boston is seeking a Distinguished Developer for the SQL Engine group to define the next-generation query processing stack for analytics and AI workloads. You will contribute to parsing, optimization, plan generation, and vectorized execution within a multi-model data platform.

You will design data processing abstractions and execution engines that enable AI-native features like fast vector search, graph traversal, and probabilistic joins within a familiar SQL interface, while