Not an officer, I was an Intel NCO though (USAF MSgt).
I was at the ANG unit out at Westfield, MA. It was a flying squadron, and my job (and the officers I worked with) primarily involved supporting flying operations, as well as Security Forces and other base agencies (Civil Engineers, , EOD, Medical, Command Staff, etc). Probably 75% pilot support, 20% Security Forces and 5% other agencies on base. We took info from other sources that have already been passed through analysis, and then further analyzed it for "what about this do our guys need to know?" We'd then provide briefings or further research.
The ANG unit at Otis at the Cape has lost all their planes and now is strictly an Intel base. I don't know exactly how they run, as I had no real desire to travel to the Cape to work with them. Likewise any dedicated Intel unit - I was squadron Intel, and was happy to stay there.
Usually, squadron level intel is for the lower ranks, both Officer and Enlisted, and as you increase rank you "graduate" to the higher echelons where there is more information, but less application.
You will not get a shoe phone, tuxedo, decoder ring or assassination training.