SOX compliance is driving our data architecture decisions more than analytics needs at this point

BI lead at a publicly traded company and the sox compliance requirements for financial reporting data are shaping our entire data platform in ways I didn't anticipate. Every piece of financial data that appears in a dashboard used by leadership needs a clear audit trail from the source system through every transformation step to the final number. If an auditor asks "where did this revenue figure come from" I need to trace it all the way back to the individual transactions in netsuite and show every calculation along the way.

This means our ingestion pipelines can't just load data, they need to log metadata about every load including timestamps, row counts, and change detection results. Our transformation layer needs to be version controlled and documented at every step. The dashboards need to show data lineage information alongside the metrics.

The practical impact is that any change to the data pipeline, even something as simple as adding a new source, requires change management documentation and sometimes approval from the compliance team before deployment. It's slowed down our ability to iterate and add new data sources significantly. Are other bi teams at public companies dealing with this level of compliance overhead?