Principal Software Engineer (Agentic Data Platform)
Horizon3
- United States
- Lead/Staff
- Posted
Skills
Required
- database
- schema
- PostgreSQL
- application code
- Go / Python
- database architecture
- data architecture
- SQL
- GiST / GIN
- Neo4j
- AWS Neptune
Preferred
- analytical query patterns / BI/reporting workloads
- operational data
- open-source database tooling / PostgreSQL ecosystem
Join NodeZero as a Principal Software Engineer for the Agentic Data Platform. In this individual contributor role, you will be the technical anchor of NodeZero's data infrastructure, making consequential database architecture decisions and defining standards for data storage, querying, and migration at scale. You will write code, author design documents, and set the technical direction for the Database Platform team. This is a deeply hands-on role that requires expertise in PostgreSQL, multi-tenant databases, and data architecture tradeoffs.
Définir et conduire la feuille de route technique pour la plateforme de base de données en partenariat avec le responsable senior de l'ingénierie et l'organisation plus large de la plateforme Pentest.
Être l'expert définitif de NodeZero sur PostgreSQL à grande échelle, en optimisant les requêtes, en indexant, en partitionnant, en répliquant et en poolant les connexions.
Experience architecting multi-tenant databases at scale: row-level security, tenant isolation, schema-per-tenant vs. shared-schema tradeoffs
Responsibilities
- Posséder les décisions architecturales les plus complexes en matière de base de données, y compris la conception du schéma, les stratégies de partitionnement, les modèles de migration et les approches de scalabilité.
Requirements
- As a remote first company, we require minimum 25Mbps consumer grade broadband connection
- Track record of growing engineers through code review, pair programming, and architectural mentorship — especially engineers who are strong in application code but earlier in their database expertise
- Proficient in Go or Python — able to write production application code, not just SQL
- Deep, production-proven PostgreSQL expertise: query planner internals, advanced indexing (partial, expression, GiST/GIN), partitioning strategies, logical replication, vacuuming at scale, and connection pool tuning
- Able to communicate complex database decisions clearly in writing — for design docs, ADRs, and cross-team reviews — so engineers without deep DB expertise can understand and apply the reasoning
- Able to reason about long-horizon schema design: what does this schema look like in two years, at 10× the current data volume, with three new feature teams writing to it?
- Familiarity with graph data models and graph databases (Neo4j, AWS Neptune) or graph-like query patterns in relational systems (recursive CTEs, ltree, adjacency list)
- Demonstrated track record of defining database architecture at scale — from design doc to production — across multiple companies or teams
- Proven ability to drive database standards across multiple teams without direct reporting authority — including teams that are not the Database Platform team
- Experience with schema migration at scale in production systems: zero-downtime migrations, backwards-compatible schema evolution, and migration tooling (Flyway, golang-migrate, or equivalent)
- Experience establishing database engineering culture: schema review norms, migration safety standards, and query performance review processes
- Strong opinions on data architecture tradeoffs: normalization vs. denormalization, consistency vs. availability, OLTP vs. OLAP workload separation, and schema-first vs. schema-last design
- Background in cybersecurity data: vulnerability databases, network scan schemas, or attack surface management data models
- Experience with time-series databases (TimescaleDB, InfluxDB) in addition to relational
- Familiarity with data platform compliance requirements: SOC 2 Type II, FedRAMP data handling, or GDPR/CCPA
Preferred
- Experience with analytical query patterns or BI/reporting workloads on operational data
- Contributions to open-source database tooling or PostgreSQL ecosystem projects
Pay
USD 255,000 - 290,000
jobapplier