If you dream of being a pilot but actually you are not one, then your dream relates to your destination. Dream imagery of a pilot means you are in charge of flying to your destination. On a deeper level of analysis, you may not be in control of the choice of destination your plane is supposed to fly to, unless you see in your dream that you are flying a plane with your destination of choice, and not under a commercial airline, which chooses the destination.
At any rate, dream imagery of a pilot means you are moving to a place. In terms of work and job, it means you are progressing. You may not get a physical move to a new geographical location, but you are moving in terms of work and maybe, up the hierarchy of position at work.