Place it just before the visual reveal in your edit, then let the moment breathe before the next beat. For a second alert, follow it with the Bell Ding Sound Effect, and for a bigger payoff, lead into it with the Dramatic Dun Dun Dun Sound Effect.