It depends. I've seen lat transfers go to sea duty and shore duty (targeteer, squadron AI, COCOM/JIOC). Generally they try to get you a sea duty billet to help you get caught up on the milestones required for intel career progression, but to make O-4 you pretty much need sea duty and a competitive tour, and with 6-7 years in you won't get to complete both of them. The detailer will most likely take your time in your previous community into account, meaning you're less likely to get an ENS billet, but I have seen lat transfer LTs get squadron intel jobs, which do typically go to first tour ensigns. In other words, there's not necessarily a set career path, but the detailer will try to balance your previous experience with the need to get you intel experience ahead of the O-4 board.