You are designing the data pipeline behind a dashboard for a federal environment where access is tightly controlled and every data movement must be auditable. The dashboard needs to combine operational data from multiple internal systems and present different views to users based on role and clearance. Data quality, lineage, and repeatable publishing matter as much as freshness.
How would you design a dashboard for a federal environment where security and access controls are strict?