Selected Answer
I'm sure there are many templates you could find on the internet to help with this, but I can give you a simple one to start with.
The most important thing is how you store the data; after you get that figured out, everything else it just about accessing it in an efficient and easy way.
Attached is a sample file that I just created; it's not perfect, but it should get you pointed in the right direction. As you will notice, it is VERY simple. That is OK! The difficult part will be sorting through the data in order to extract the specific information that you want.
Basically, this is a starter setup and you can add as many pieces as you want to it to make it more user-friendly; including data-validation drop-down menus for the jobs, separate first and last name fields along with a column for a unique ID number for each employee, a custom worksheet used to sift through the data, etc.
You can ask new questions for each additional feature you need. Also, don't forget to search this site to see if some of the tutorials for what you want to do already exist.