CSV Ingestion Pipeline

You work as an engineer for a YouTube content company which frequently extracts large CSV files containing engagement data extracted from YouTube. The company wants to generate custom reports and dashboards. The system must support uploads from both web UI and API, efficiently parse and validate the data, store it reliably, and make it available for fast querying and reporting.

How would you architect this end-to-end CSV upload and ingestion system?