I have had my nose pierced for about 5 years and I currently have a nose ring in.
Where I am from some places will employ you with a small stud in, but it depends entirely on what the job is. For example, in a fast food restaurant they will not allow you to wear one unless it is covered by a plaster. Some places also let you wear retainers (a clear stud) as they are barely visible unless you're looking at it close up (you can cover them in foundation to make it look more skin coloured). The hole is not that visible if you take the jewellery out, especially if you wear foundation. I used to take mine out every day for school and anybody from school who would see me out always used to ask me when I got my nose pierced because they had never noticed anything there before.
The problem with nose piercings is that they take a long time to heal properly, mine took just over a year. I suggest if you do plan on getting it pierced you do it when you have a break from school/work because you're not supposed to change/take out the jewellery until you've had the piercing for at least 6 weeks. It WILL get irritated and sore if you take it out and put it back in again throughout the day until it is fully healed.
I also have my belly pierced (I did have it done twice at the bottom, but they unfortunately rejected so now I only have the top part done). Even though they are surface piercings and have a higher risk than some other piercings of rejecting they are usually good. I don't know anyone who has had any severe problems. The key is to clean it properly and not touch it. A lot of the time belly piercings get sore because people touch and play with them which spreads germs and unsettles the healing process which will make the skin reject it. If you're riding horses whilst it's still healing be especially careful when mounting and dismounting as the last thing you want is for the piercing to get caught.