I just enlisted as a Civil Affairs Specialist today as a reservist, what can I expect from this job?

As a junior enlisted Soldier you may have several functions. You may be used as a data miner going through published information on a country of interest and helping your Civil Affairs Team leadership develop a profile of the country's civilian landscape. During Key Leader Engagements, you will likely be taking notes of the engagement and helping your Team leader establish a relationship with the key leader (tribal leader, elder, law enforcement official, mayor, etc.)

You will likely be a vehicle driver for your CAT (Civil Affairs Team), and possibly pull security while the team leader and team sergeant engage with the local leaders.

If you happen to land in a higher unit, like brigade level, you may find yourself part of the CMOC (Civilian-Miitary Operation Center). In this, you will assist in sorting through all the events that occur during combat operations and providing the information the leaders need to determine what events involving local civilians have an impact on military operations. If there is a displaced civilian collection point or camp set up, then you will be involved in processing the people that move through the camp.

1SG (Join to see) would be a good resource for this question

SPC (Join to see) I have been doing this for 18 years, and one thing I can tell you is that every time you go on mission, it will be different.
It will be different from the last time (and what you were trained) because -
1. The culture of that particular spot is different
2. The motives of the people in charge (them and you) will be different
3. The resources you have to work with are changeable
4. Even if you go to the same place, the situation will have changed (ie Iraq, Afghanistan, Bosnia...)
5. The political climate will be different (our and theirs)
6. The people ostensibly on the same team as you change and so do their mindsets
7. The guidance from military and State Dept channels will change

The single biggest piece of advice I can give you is to learn from training and your NCOs tools and techniques to do your job, but the actual art of targeting, attacking a problem, affecting desired results, and exploiting opportunities is an art that you have to learn for yourself with experience. What works for me surely won't for you, because our talents and personalities are different.

If you have specific questions, shoot. I try and do my best to answer, and you'll be hard-pressed to stump me.

You will a lot of chances for deployments because 90% of your field is in the Reserves.