Deep experience operating Postgres in production, focusing on concurrency and performance issues.
Strong systems intuition with an ability to identify bottlenecks and tradeoffs.
Experience designing and owning analytical data architectures, like read-optimized schemas.
Ability to lead complex, ambiguous projects with a focus on clear solutions.
High ownership mindset with a passion for data integrity and long-term system maintenance.
Curiosity and pragmatism combined with a drive to create foundational systems that support others.
Minimum 5 years of relevant experience.
Responsibilities
Own and manage core data systems that handle millions of enriched videos.
Stabilize and enhance high-throughput data ingestion pipelines.
Design efficient data access patterns for fast analytics under load.
Define boundaries between transactional and analytical workloads.
Create read-optimized data models that facilitate insightful queries.
Enable AI-native analytics for improved data querying and reasoning.
Make impactful architectural decisions to enhance the data platform's evolution.
Establish and promote best practices for reliability and performance.
Benefits
Flexible work environment that encourages innovation.
Opportunities for personal and professional growth.
Collaborative culture focused on teamwork and knowledge sharing.
Full Job Description
What You'll Work On
Own the core data systems that power Plot. You'll take responsibility for how millions of enriched videos flow from ingestion 1 storage 1 analytics 1 product surfaces.
Stabilize and harden high-throughput write paths. Our pipelines ingest and enrich data continuously; you'll diagnose failure modes, reduce error rates, and make ingestion reliable, observable, and predictable.
Design data access patterns that stay fast under pressure. You'll ensure dashboards and analytical queries remain responsive even while large volumes of data are being written concurrently.
Separate transactional and analytical concerns. You'll lead decisions around which workloads belong where, and design the systems and contracts that keep them from stepping on each other.
Build read-optimized models for insight, not just storage. This includes partitioning strategies, rollups, and schemas that reflect how data is actually queried - by humans and by AI.
Enable AI-native analytics. You'll shape how our internal tools and AI agents query and reason over data, making it possible to answer complex analytical questions without brute-force scans.
Make architectural calls that matter. You'll evaluate tradeoffs, write RFCs, and guide the evolution of Plot's data platform as scale, product needs, and AI capabilities grow.
Raise the bar for reliability and performance across the team. You'll define best practices, unblock other engineers, and become a go-to resource for data-related decisions.
What We're Looking For
Deep experience operating Postgres in production under real-world read/write concurrency. You understand partitioning, locking, autovacuum, connection pooling, and why systems fail in subtle ways.
Strong systems intuition. You think in bottlenecks, failure modes, and tradeoffs - not just indexes or tooling.
Experience designing or owning analytical data architectures, including read-optimized schemas, aggregations, or large-scale querying patterns.
Comfort leading ambiguous, high-impact work. You can take a messy system, form a clear mental model, and chart a pragmatic path forward.
High ownership mindset. You like digging into logs, metrics, and real data - and you care deeply about correctness, reliability, and long-term maintainability.
Curiosity, pragmatism, and a desire to build foundational systems that other engineers and AI systems depend on. No degree requirements.
