What Just seeking some good talent!
Where At BrightEdge, we innovate at the intersection of AI, SEO, and enterprise growth. We're not just shaping the future of enterprise SEO and content performance; we're also redefining how digital experiences drive real business results. Trusted by more than 55% of the Fortune 100 and 500, alongside 2000+ enterprise brands, our AI-powered platform transforms content into measurable traffic, engagement, and revenue.
About the Role:
Build the world's most efficient data engine, using petabytes to deliver real-time SEO/AI insights. Design ClickHouse (real-time/high-concurrency) + BigQuery (batch/ad-hoc) hybrid architecture as performance gatekeeper. No ETL/pipelines, pure query/UI optimisation for dashboards.
Title: Senior/Staff Software Engineer/Architect
Location: 100% remote
What You'll Do
Hybrid Architecture:
- Route workloads: ClickHouse for sub-second UI queries vs Data warehouse for petabyte scans.
- ClickHouse schemas: MergeTree engines, primary/skipping indexes, materialised views/PREWHERE for GROUP BY dashboards.
- Data warehouse: Partitioning/clustering/nested fields maximising slot efficiency
Extreme Optimisation:
- Profile complex SQL → sub-second responses on trillion-row datasets.
- Materialised views/projections pre-calculating heavy aggregations.
- Compression (DoubleDelta/Gorilla/ZSTD) + cold storage (S3 Disk engine)
Cost Engineering:
- Migrate high-frequency queries from BigQuery pay-per-scan → ClickHouse persistent compute.
- Infinite retention via storage tiering without infinite costs.
Build features/products:
- Using backend techs to build everything from scratch.
What You Bring:
- Expert ClickHouse: Production query/UI optimisation w/ metrics.
- BigQuery Advanced: Partitioning/clustering/cost optimisation at the petabyte scale.
- Owns dashboard queries (PM/UX-facing), zero ETL/Kafka/CDC.
- Stack: SQL/Python/Go, dbt, K8s, Iceberg/Delta Lake, Trino/Doris.
Why
- BrightEdge has a global presence with offices in San Mateo, New York, London, Sydney, Tokyo & more.
- Work with passionate leaders and cutting-edge tech in a fast-paced, high-growth environment.
- Culture built on Customer Success, People Success, Excellence, Urgency, and Winning.
- Join a growth-stage SaaS company shaping the future of search and content marketing.
- Remote-first, work/manage your schedule as you like it.
Ready to build the future at BrightEdge Apply now!