Stop hand-building a galaxy of star schemas. If the business layer is modeled, the consumption layer - Unified Star Schema, mart, OBT, star - is downstream of it and should generate itself.
Analytical systems are built for questions that do not exist yet. A layered DAS/DAB/DAR architecture with ensemble modeling makes continuous change survivable.
Skills, semantic layers, and ontologies make analytics agents work, until they hit the messy data underneath. The durable fix is structural, not more context.
Replace hand-written staging SQL with declarative YAML contracts. A generator reads contracts and produces consistent, type-safe SQL across all your source systems. The contract becomes the documentation, the schema definition, and the transformation logic - all in one artifact.