Design an analytics platform for external career data

External providers send snapshots and updates of people's career profiles. Design the data platform for an internal analytics team:

• Backfilling and ingesting provider data idempotently while keeping the raw records and their lineage.
• Modeling users and their career history in tables that join cleanly and keep history instead of overwriting it.
• Building versioned aggregates for common questions, and handling late records and corrections without silently changing published numbers.
• Serving a dashboard with filters and drill-downs that shows how fresh and complete the data is.