Principal Architect

Planful, Inc.

Hyderabad

On-site

INR 2,500,000 - 4,500,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Volunteer days
Birthday PTO
Wellness days
Parental leave benefits
Mental health support
Annual company gatherings
Office hubs (SF, Toronto, London)
Home office setup reimbursement
Wifi & mobile reimbursements
ERGs & communities

Job summary

Planful, Inc. is seeking a Principal Architect to own the internals of a high-performance OLAP query engine and semantic layer within a microservices architecture.

You will design a JSON-based DSL and translate it into optimized SQL for columnar databases, balancing push-down and app-level execution while ensuring scalability. The role requires deep expertise in compilers, SQL optimization, and Java performance tuning, with leadership in AI-assisted development and thorough architectural

Qualifications

  • 15+ years in software engineering with backend focus
  • Strong theoretical and practical knowledge of compilers, ASTs, eBNF, and query planning
  • Deep understanding of SQL, query optimization, and columnar databases
  • Expert proficiency in Java, multi-threading, asynchronous I/O, networking, and memory management
  • Experience designing distributed caching layers and managing state across microservices
  • Ability to decompose complex data problems into scalable architectural components
  • Clear written and verbal communication with strong documentation habits
  • Minimum of 1 year using AI coding agents to enhance development productivity
  • Experience with financial systems like ERP/EPM/GL is a plus

Responsibilities

  • Architectural design and end-to-end implementation of a high-performance OLAP query engine and semantic layer
  • Design a custom JSON-based OLAP DSL and a translation engine to generate optimized SQL for columnar databases
  • Oversee SQL generation and optimization for ClickHouse, SingleStore, and DuckDB
  • Model multi-dimensional data semantics within columnar structures for efficient retrieval and aggregation
  • Implement custom function logic balancing SQL push-down and application-layer execution
  • Develop and maintain a distributed caching strategy for multidimensional data (Redis)
  • Build high-performance microservices using Java with modern concurrency (Project Loom)
  • Tune JVM parameters and memory management for low-latency responses
  • Lead AI-integrated development, documentation of decisions, and architectural patterns
  • Mentor teams and provide guidance on query engine internals and performance benchmarking

Skills

Architectural design
Compiler theory
OLAP / data warehouse
Java & multi-threading
SQL optimization
Distributed caching
Microservices
Project Loom
AI coding agents
Financial systems domain

Tools

Redis
ClickHouse
SingleStore
DuckDB
Micronaut
Spring Boot
Java

Job description

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.

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
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Solutions Architect - Customer Excellence Optimization
Solutions Architect - Customer Excellence Optimization

Planful, Inc. • Hyderabad

On-site
INR 2,500,000 - 4,000,000
Volunteer days
Birthday PTO
Wellness days
+2
Data Architect
Data Architect

Onit, Inc. • Pune District

On-site
INR 3,500,000 - 6,000,000
Health Coverage
Flexible paid time off
Volunteer day
+1
Sr. Software Engineer I
Sr. Software Engineer I

Planview • Bengaluru

On-site
INR 2,400,000 - 4,200,000
Unplugged Days
Generous PTO
Region specific benefits
+2
Senior Business Analytics Engineer - India
Senior Business Analytics Engineer - India

Juniper Square • India

Hybrid
INR 3,000,000 - 6,000,000
Health, dental, and vision care
Life insurance
Mental wellness coverage
+6
Data Architect
Data Architect

K1 Investment Management, LLC • Pune District

On-site
INR 4,000,000 - 8,000,000
Health coverage for employee and fam
Flexible paid time off
Generous family leave and caregiving
+4
Senior Staff Data Engineer
Senior Staff Data Engineer

Meeru AI Inc • Hyderabad

Remote
INR 3,500,000 - 6,000,000
Remote work
Flexible engagement
Technical Lead- Data Engineering
Technical Lead- Data Engineering

Juniper Square • India

Remote
INR 1,200,000 - 2,300,000
Engineer III - Data Engineer
Engineer III - Data Engineer

Anaplan • Gurugram District

On-site
INR 2,500,000 - 4,000,000
Business Intelligence Analyst II
Business Intelligence Analyst II

Planview • Bengaluru

Hybrid
INR 1,500,000 - 2,500,000
Unplugged Days
Generous PTO
Region-specific benefits
+4
Senior Technical Lead / Architect
Senior Technical Lead / Architect

Techversant Infotech Pvt Ltd • Ernakulam

On-site
INR 1,200,000 - 2,400,000
Career growth opportunities
Family medical insurance
Flexible work timings