Put it at the peak of a goal edit, just after the shot and before the crowd reaction, then follow it with a cheer sound to stretch the celebration. Save it for the winning moment in a montage, not the build-up clips, so the payoff stays in one place.