All jobs
Planful logo

Principal Architect

Planful · Posted 1 month ago

  • Hyderabad, Telangana, India (On-site)
  • On-site
  • Full-time
  • 15+ yrs

About the role

About The Role

As a Principal Architect, 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

To Foster The Best In Class Work We’re So Proud Of, We’ve Created a Best In Class Culture, Including

  • 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

Skills

Systems programmingCompiler theoryMulti-dimensional data modelingJSON-based query language designSQL optimizationColumnar databasesJava (Micronaut or Spring Boot)Project Loom (Virtual Threads)Distributed cachingConcurrency managementLow-level performance optimization

Quark9 guide

How to land this Principal Architect role

Our notes for applicants, based on how software engineering hiring usually works and on 599 similar open jobs on Quark9.

Resume checklist for this job

Most companies screen resumes with an ATS before a person reads them. Make sure each skill you genuinely have appears in your resume in the same words the job uses.

Must have

  • Systems programming
  • Compiler theory
  • Multi-dimensional data modeling
  • JSON-based query language design
  • SQL optimization
  • Columnar databases
  • Java (Micronaut or Spring Boot)
  • Project Loom (Virtual Threads)
  • Distributed caching
  • Concurrency management
  • Write each bullet as action plus result: "Cut p95 latency from 800 ms to 200 ms by adding Redis caching"
  • Keep a skills line that matches the job's stack word for word, so ATS filters pick it up
  • Put your strongest one or two projects first, with links to code or the live product
Check your resume against this job free

What interviewers expect: senior and leadership

Expect conversations about strategy, building teams and stakeholder management. Lead with outcomes at business level and how you made the people around you better.

How software engineering interviews usually run

  1. An online coding test or a recruiter screen on your stack and projects
  2. One or two technical rounds on data structures, problem solving and your core language
  3. A system design or low-level design round for mid and senior roles
  4. A hiring manager round on ownership, teamwork and how you handle production issues

Questions worth preparing

  • Design a URL shortener. How would you scale reads, and where would you cache?
  • Find the first non-repeating character in a string. What is the time complexity?
  • Explain how you would debug an API that became slow after a release.
  • Describe the hardest bug you fixed and how you found it.

Every company runs its own process, so treat this as a likely shape, not a promise. Practise a mock interview on Quark9 and get scored feedback before the real one.

The market for Architect roles right now

  • Most openings are in Bengaluru, Bengaluru East, Chennai, Hyderabad, and 1 of the 20 we looked at offers remote work.
  • The skills these jobs ask for most:
Technical leadershipGenAI architectureMachine learningNatural language processing

From open jobs on Quark9 matching “Architect”, updated every few minutes.

Similar jobs