Shared foundation, role-specific views
Six very different roles needed their own tools without splitting the truth.
Options considered
Separate products per role, or one shared data layer with role-specific views on top.
The choice
One shared data layer with six role-specific view compositions: one source of truth, six interpretations of it.
Trade-off accepted
A more demanding data model up front, in exchange for real-time visibility across teams and no duplicate reporting.