This was an article that really helped me understand it
https://sarahconstantin.substack.com/p/the-great-data-integr...
https://sarahconstantin.substack.com/p/the-great-data-integr...
The problem as enunciated also 100% tracks with my time as a consultant -- delivering solutions was 40% people-fixing and 60% code-fixing.