The family office sector is undergoing a profound shift as the "great wealth transfer" continues to reshape wealth management.