InterSystems is looking to build the next-generation query processing stack for their data platform, optimizing for both traditional analytics and emerging AI-driven workloads. This involves handling multi-model data and enabling AI-native features within a familiar SQL interface.
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 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
- Passion for designing software that balances performance, correctness, and usability
Responsibilities
- Build the next-generation query processing stack
- Optimize query processing across traditional analytics and emerging AI-driven workloads
- Contribute to query parsing, validation, and transformation
- Develop logical/physical optimization over multi-model data (row, columnar, stream, document, vector)
- Implement plan generation and adaptive execution strategies
- Work on code generation and vectorized execution
- Develop compiler-accelerated storage access patterns for AI workflows
Other
- Distinguished Developer
- Mentor engineers, guide technical debates, and influence long-term system direction
- Champion a culture of quality, rigor, and innovation
- 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
- PHD degree or published research experience is highly advantageous.
- 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.
