senior data engineer

Multi-Tenant Analytics Warehouse

Clarify · 5:00

Design a multi-tenant analytics warehouse for a B2B SaaS product.

Known Requirements

  • • Onboard 150 tenants in year one
  • • Daily batch loads and near-real-time dashboards
  • • Support ad-hoc SQL by analysts

Constraints

  • • Strict tenant data isolation
  • • PII must be encrypted at rest and in transit
  • • Data freshness < 10 minutes for critical metrics

Clarifying Questions

Ask up to five questions. Reveal constraints by being specific.

5 questions remaining

    Reveals

    • Ask a question to reveal more constraints.

    Phase Control

    Advance when ready or let the timer move you forward.