We get some kids on the site from time to time who haven't done their homework and expect the answers to their life's ambitions to be handed to them on a silver platter by those who have been where they want to go. Clearly, you do not fall into that category.
While I am an officer with experience in an SF Group, I'm not an SF officer so I'm not going to speculate on what you can expect as a junior team leader other than to say if SF is like other branches, as the junior officer in the unit you can expect to do all the crap jobs that the other officers with more time in the unit don't feel like doing ;)
Are you here at Bragg? If so, I will be glad to link you up with any one of about a 1/2 dozen SF officer friends of mine who would be happy to chat with you. One of them graduated from the Q course less than a month ago and may have the most up-to-date answers for you.
Additionally, I know of an SF NCO who's going to be hosting what will probably be a kick-ass Cinco de Mayo party, and probably wouldn't mind if a fellow operator showed up with a couple of questions (and maybe a case of beer).
Welcome to the site, best of luck with your goal of becoming SF.