Software Engineer

Software Engineer, AnalyticsAustin, or Remote (with flexibility for timezone overlap)About DreambaseDreambase is the AI-native analytics platform for Supabase. We connect directly to your Supabase database and let AI agents generate dashboards, reports, and insights automatically — no data team, no pipelines, no SQL required. We are a small, fast-moving team building something genuinely new at the intersection of AI, analytics, and the Supabase ecosystem.Your MissionBuild the analytics engine that makes Dreambase fast, accurate, and scalable across any data source and any volume. You will own the query layer, the OLAP processing pipeline, and the on-the-fly transformation systems that turn raw data from Supabase, ClickHouse, PostHog, and external APIs into production-ready dashboards, reports, and insights — at startup speed and enterprise scale.What You'll DoOwn the Query and OLAP Layer — Design and implement the systems that execute analytical queries across heterogeneous data sources. You know the difference between OLTP and OLAP workloads and you architect for both.Build On-the-Fly Transformations — Implement DuckDB and PGlite-powered transformation pipelines that execute in Edge Functions and WASM environments. Calculations, aggregations, and dataset joins that happen at the edge without hitting production databases.Scale Across Data Sources — Build the connectors and query routing layer that handles Supabase Postgres, ClickHouse, PostHog, and external APIs as unified analytics sources. Different engines, one consistent output.Design the Caching Architecture — Build the intelligent dataset caching system that persists query results at the right layer — Supabase Storage, edge cache, or in-memory — based on data freshness requirements and query cost.Power the Reports Engine — Implement the data pipeline that generates executive summaries and scheduled reports enriched from multiple sources, with transformations and calculations handled correctly at every layer.Optimize Relentlessly — Profile slow queries, design partition strategies, and build the monitoring systems that catch performance regressions before they reach users. You think about query plans the way other engineers think about code reviews.Own the Analytics Tools — Build the Query Analyzer, Dataset Analyzer, and the transparency layer that shows users exactly what is running against their data sources and how it performed.What We're Looking ForOLAP Expertise — You have built analytical query systems at scale. You understand columnar storage, vectorized execution, query planning, and the architectural differences between OLAP and transactional workloads.Distributed Systems Depth — You understand MapReduce patterns, distributed aggregation, and the tradeoffs involved in processing large datasets across partitioned data. You have worked with these systems in production, not just read about them.DuckDB and In-Process Analytics — You have used DuckDB in production and understand why in-process OLAP changes the calculus for analytical workloads. Bonus if you have explored PGlite for client-side or edge query execution.ClickHouse Experience — You have built or maintained ClickHouse-backed analytics systems and understand its data model, performance characteristics, and operational tradeoffs at scale.Edge and WASM Deployment — You understand what it means to deploy analytical compute to Vercel Edge Functions, Cloudflare Workers, or WASM environments. You know the constraints and you design systems that respect them.PostHog Familiarity — You understand PostHog's data model and event schema well enough to build reliable connectors and cross-source analytics on top of it.Postgres Depth — Comfortable with query planning, indexing strategies, and performance optimization in Postgres, including Supabase-specific patterns like PostgREST and RLS-aware query design.Accuracy Standards — A wrong number in an analytics product is a critical bug. You build validation systems and measure output correctness before calling anything done.Bonus Points ForProduction experience with ClickHouse, Apache Druid, Pinot, or other purpose-built OLAP databasesExperience with Apache Parquet, Apache Iceberg, or columnar storage formats at scaleFamiliarity with streaming analytics pipelines and real-time aggregation systemsExperience running analytical workloads in WASM or edge compute environmentsBackground as a data engineer or analytics engineer at a high-growth SaaS or developer tools companyOpen-source contributions to DuckDB, PGlite, or analytics toolingExperience building multi-source analytical systems that unify structured and event-based dataWhy This Role Is DifferentMost analytics engineering roles are about moving data from one warehouse to another. This one is about building the compute layer that runs analysis as close to the data as possible — in edge functions, in WASM, in DuckDB — so that Dreambase can deliver sub-second insights across enterprise-scale datasets without requiring a data warehouse, a dedicated data team, or a six-month implementation project.If you have wanted to work on the hard part of analytics infrastructure, this is it.How To ApplyShow us what you can do! Along with your resume & LinkedIn, we'd love to see:Case studies and examples that prove you're the best for this role - videos go a long way!Your GitHub profile or code samples that demonstrate your experience and expertise.A technical deep-dive demonstrating your opinions on the best AI stack recommendations for Dreambase.A brief note on why Dreambase excites you and your vision for the future of AI-native intelligence and analytics.Email View email address on click.appcast.io with the subject line "I'd love to join the dream! [Your Name]"