Principal Software Engineer, Agentic Data Platform
Horizon3 AI18 hours ago
Remote, United StatesStaff+
Base Salary
$255k - $290k/yr
Responsibilities
- Define and drive the Database Platform technical roadmap with engineering leadership.
- Own database architecture decisions involving schema design, partitioning, migrations, scalability, and multi-tenant data isolation.
- Establish PostgreSQL standards for query optimization, indexing, replication, vacuuming, and connection pooling.
- Architect and guide graph-based asset data models representing hosts, services, credentials, and vulnerabilities.
- Own schema review processes and ensure migrations are safe, reversible, backward-compatible, and zero-downtime.
- Build tooling and standards for schema governance, migration safety, and query performance review.
- Mentor P4 and P5 engineers through code review, design review, pairing, and architectural guidance.
- Define data contracts and architectural guardrails with Data Ingestion, Asset Inventory, API Platform, and Security Research teams.
Requirements
- Deep, production-proven PostgreSQL expertise, including query planner internals, advanced indexing, partitioning, logical replication, vacuuming, and connection pool tuning.
- Experience architecting multi-tenant databases at scale, including row-level security, tenant isolation, and shared-schema versus schema-per-tenant designs.
- Production experience with zero-downtime migrations, backward-compatible schema evolution, and migration tooling such as Flyway or golang-migrate.
- Familiarity with graph data models and graph databases such as Neo4j and AWS Neptune, or graph-like relational query patterns including recursive CTEs, ltree, and adjacency lists.
- Proficiency in Go or Python with the ability to write production application code.
- A demonstrated track record of defining database architecture from design through production across multiple companies or teams.
- Strong understanding of data architecture tradeoffs, including normalization, denormalization, consistency, availability, OLTP, OLAP, and schema design approaches.
- Ability to reason about long-term schema design and communicate complex database decisions through design documents, ADRs, and cross-team reviews.
- Experience driving database standards and engineering culture across teams without direct reporting authority.
- Experience mentoring engineers through code review, pair programming, and architectural guidance.
- Preferred experience with cybersecurity data, time-series databases, SOC 2 Type II, FedRAMP, GDPR/CCPA, analytical workloads, BI/reporting, or open-source PostgreSQL and database tooling.
Benefits
- Fully remote work at a 100% remote company.
- Minimum 25 Mbps consumer-grade broadband connection required.
- Up to 5% travel may be required.
- Health, vision, and dental coverage for employees and families.
- Flexible vacation policy and generous parental leave.
- Growth and career development opportunities.
- Inclusive, collaborative, and innovative work culture.
- Potential eligibility for equity in the form of stock options.
Tech Stack
Categories
BackendData Engineering
About Horizon3 AI
Horizon3 AI builds NodeZero, a proactive security platform that autonomously performs penetration testing and validates attack paths across on‑prem, cloud, and hybrid environments. The company sells its software by subscription to security and IT teams at enterprises and government agencies, helping prioritize and verify fixes. Founded in 2019 and headquartered in San Francisco, it is privately held and serves customers across regulated industries and the public sector.