Principal Architect
Free to start · No card · 5 credits the moment you sign up
Job description
About the Role
As a Principal Engineer, you will be responsible for the architectural design and end-to-end implementation of a high-performance OLAP query engine and semantic layer. The primary goal is to develop a custom JSON-based query language (DSL) and a translation engine that converts these requests into optimized SQL for columnar databases. This role requires a deep understanding of systems programming, compiler theory, and multi-dimensional data modeling to serve high-concurrency read loads in a microservices environment.
What You'll Do
- Architectural Design & Query Execution
- Compiler & DSL development: Design a custom JSON-based OLAP query language. Define eBNF grammars and build a translation layer to convert functional formulas and DSL requests into an optimized execution plan.
- SQL generation & optimization: Implement and oversee the generation of highly optimized SQL tailored for columnar databases including ClickHouse, SingleStore, and DuckDB.
- Semantic layer management: Architect the representation of multi-dimensional data models within columnar structures, ensuring efficient data retrieval and aggregation.
- Custom function logic: Implement logic for custom functions, determining the optimal balance between SQL push-down and application-layer execution
- Caching & Performance Engineering
- Multi-dimensional caching: Envisage and implement a distributed caching strategy for multidimensional data, utilizing shared memory systems like Redis.
- Concurrency & scaling: Build and maintain high-performance microservices using Java (Micronaut or Spring Boot) with Project Loom (Virtual Threads) to handle massive concurrent read loads.
- Low-level optimization: Manage system-level performance including connection pooling, array pooling, and off-heap memory management.
- JVM tuning: Apply expert knowledge of Java Garbage Collectors (including ZGC and Shenandoah) to maintain low-latency response times.
- Engineering Excellence & AI Integration
- AI-augmented development: Leverage AI coding agents and tools to accelerate the software development lifecycle, from prototyping to debugging.
- Technical documentation: Maintain a disciplined approach to software development by documenting architectural decisions, design patterns, and technical specifications.
- Technical leadership: Act as the primary technical authority on query engine internals, providing guidance on complex systems-level challenges.
What We're Looking For
- 15+ years in software engineering with a focus on backend systems and data infrastructure
- Strong theoretical and practical knowledge of compilers, ASTs, eBNF, and query planning
- In-depth understanding of SQL, query optimization, and the internal workings of columnar databases
- Expert proficiency in Java, specifically regarding multi-threading, asynchronous I/O, networking, and memory management
- Proven experience in designing distributed caching layers and managing state across microservices
- Ability to decompose complex data problems into scalable architectural components
- Clear verbal and written communication skills, with a strong tendency to document thoughts and architectural ideas
- A rigorous approach to software craftsmanship, including testing, telemetry, and performance benchmarking
- Minimum of 1 year of experience using AI coding agents to enhance development productivity
- Prior experience developing financial systems such as ERP, EPM, or General Ledger platforms is an added plus
Why this Role
You will own the internals of the query engine at the heart of a next-generation financial planning platform — the layer where compiler theory, columnar database performance, and multi-dimensional semantics converge.
Why Planful
- 2 Volunteer days per year, Birthday PTO, and quarterly company Wellness Days
- 3 months supply of diapers and meal deliveries for the first month of your Maternity/Paternity leave and generous parental leave
- Talkspace access and mental health support
- Annual company-wide gatherings held in cities like San Diego, Denver, Palm Springs, and Vegas!
- Office hubs in San Francisco, Toronto, and London. We also offer benefits such as home office setup, and monthly wifi and cell phone reimbursements for all employees, in-office or remote.
- Employee Resource Groups such as Women of Planful, Parents of Planful, and many more. We encourage our teammates to bring their authentic selves to the team, and have full support in creating new ERGs & communities along the way
Pay Transparency Statement
At Planful our top priority is to support our employees and ensure each individual has access to equal growth opportunities. Pay decisions take into consideration the individual's skillset, experience, knowledge, qualifications for the role, and specific work location.
The OTE range for this role is $325,000 - $375,000 USD per year, depending on experience and location. As a part of this role, you are also eligible for equity, benefits and wellbeing resources.
Originally posted on Himalayas
Prepare your application
Use the description above to assess your fit for Planful. This checklist is guidance from Resumize, rather than additional requirements from the employer. Imported listings can be shortened or change after collection, so confirm the complete description and current availability before sending an application.
Match requirements to evidence
Identify the responsibilities and skills the employer explicitly names. For each important requirement, choose one example from your work, education, training, or projects. Explain what you did, how you did it, and what changed as a result. Include a measurable outcome when you can support it. If you lack a requirement, describe related experience accurately instead of adding an unfamiliar skill to your resume.
Put the most relevant examples near the top of your resume. Keep job titles, dates, qualifications, and contact details consistent across your application materials. Use the employer’s terminology when it describes your experience accurately; a copied list of keywords does not explain your contribution. A short, specific bullet is easier to review than a paragraph that mixes several unrelated duties.
Check the working arrangement
Confirm the location, schedule, employment type, and any eligibility requirements on the employer’s site. A remote label does not establish worldwide eligibility or flexible hours. If compensation, benefits, equipment, travel, or contract duration are missing from this listing, write down your questions for the recruiter. Do not assume details from another opening at the same company apply to this role.
Review before submitting
Follow the employer’s requested file format and application instructions. Open your exported resume and check that its text is selectable, its sections read in order, and its links work. Proofread names, dates, and contact information. Share confidential work samples only when you have permission, and use an anonymized example when necessary.
Submit through a trusted employer or recruiting destination. If the original listing has disappeared, search the employer’s careers page for the title rather than assuming the vacancy remains open. Save the application date, job reference, and the version of your resume you sent. Those details help you prepare for a later conversation and avoid submitting conflicting information through several job boards.
Review your resume for writing and readability feedback, or browse other openings if this opportunity is unavailable.