Scale Executive Financial Reporting Pipeline

Scenario

You are redesigning a financial reporting process for a B2B software business as revenue lines, legal entities, and stakeholder groups expand. The current workflow relies on spreadsheet-based consolidations and manually maintained business logic, which has led to recurring mismatches between finance, sales, and executive dashboards during month-end close. Leadership wants a scalable reporting pipeline that supports consistent KPI definitions, faster refreshes, and controlled access for a growing set of consumers. The new design must support both scheduled reporting and ad hoc analysis without creating multiple versions of the truth.

Current State

Scale: ~25 source feeds, 150M fact rows/year, 3 years of retained history, 300+ internal stakeholders, month-end peak refresh window under 2 hours, standard daily freshness target under 30 minutes after source delivery.

Question

How would you design this reporting pipeline so it scales with business growth and stakeholder count while keeping metric definitions consistent, refreshes reliable, and downstream reporting easy to extend? Describe the architecture, data model, orchestration, and controls you would put in place to support both ongoing operations and future growth.