Place it right before the ambush or pick in your edit, then follow the fallout with an enemy spotted cue for the reveal. For a failed objective attempt, let this play first and save the heavier alert sounds for when the fight actually breaks out.