S-2 is the intelligence officer in formations division sized and below. Above division (corps and army groups) the designation becomes G-2. There's another level above that but I'm not sure what letter he is.
FYI the various staff positions under the CO and XO:
S-1 : Administration
S-2 : Intelligence
S-3 : Operations
S-4 : Supply