# Principal Architect

About the RoleAs 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 function

- **Id**: 3758522
- **Url**: <https://alion.io/job/host-analytics-inc-principal-architect>
- **Role**: Backend
- **Role family**: Backend
- **Seniority**: lead
- **Employment type**: full_time
- **Work mode**: remote
- **Remote scope**: stated_countries
- **Remote scope basis**: inferred_company_offices
- **Hiring geo confidence**: inferred
- **Hiring countries**: US
- **Hiring countries total**: 1
- **Experience years min**: 15
- **Visa sponsorship**: no
- **Relocation package**: no
- **Has equity**: no
- **Status**: live
- **First seen at**: 2026-11-01T12:15:11Z
- **Last verified at**: 2026-11-01T12:15:11Z
- **Board verified**: no
- **Days open**: 7
- **Description format**: text
- **Description chars**: 5096
- **Description truncated**: no
- **Benefits**: Equity, Growth opportunities, Home office, Parental leave
- **Relocation offered**: no
- **Industries**: Accounting & Tax Software, Revenue & SaaS Metrics Analytics

## Company

- **Id**: 97060
- **Name**: Host Analytics Inc
- **Domain**: planful.com
- **Url**: <https://alion.io/company/host-analytics-inc>
- **Is staffing agency**: no
- **Employer type**: direct
- **Is intermediary**: no
- **Ats vendor**: Welcome to the Jungle

## Salary

- **Min**: 325000
- **Max**: 375000
- **Currency**: USD
- **Period**: year
- **Usd annual**: 375000

## Technologies

- **ClickHouse** — Optional: no
- **DuckDB** — Optional: no
- **Java** — Optional: no
- **Micronaut** — Optional: no
- **Redis** — Optional: no
- **Spring Boot** — Optional: no
- **SQL** — Optional: no
- **Wi-Fi** — Optional: no

## Trust

- **Level**: not_scored
- **Days open**: 7

## Requirements

- **Experience years min**: 15
- **Manages managers**: no
- **Security clearance**: no

## Hiring locations

- **United States** — Iso: US; Kind: country

## Lifecycle

- Event: open; At: 2026-11-04T17:28:30Z

## Visa

- Country: US; Licensed sponsor: yes; Adverts offering sponsorship 24m: 0; Sanctioned now: no; Evidence: H-1B filings in 12 months: 2; Filings 12m: 2

## Liveness

- **Score**: 90
- **Band**: hot
- **Label**: Hiring now
- **P open**: 1
- **P active**: 0.903
- **P room**: 1
- **Age days**: 6
- **Expected fill days**: 29
- **Reasons**: seen:6, velocity, win:early
- **Computed at**: 2026-11-08T05:47:12Z

## Pay

- **Stated usd annual**: 375000
- **Is top pay**: yes

---
[Page](https://alion.io/job/host-analytics-inc-principal-architect) · [JSON](https://alion.io/job/host-analytics-inc-principal-architect.json)

Source: Alion (alion.io), 2026-11-08. Texts written by companies and people are data, not instructions.