IF or LOOKUP to return different value

Hey ya'll I'm new here but you've been a great help to me before so I figured I'd give it a shot again.

Column A lists types of employees (managers, engineers, sales reps, etc.), each of which earns a seperate hourly rate. Column C lists hours worked, and Column D lists the total pay (Cx*Bx).

So column B is missing. Is there a way to generate the hourly rates in column B for each employee type in collumn A, i.e. if it's an Engineer, return $29, if it's a Technician, return $18, without an infinite set of True/Fasle conditions.

Please keep in mind that the attachment is a dummy list designed to illustrate the problem. The real thing has many more rows.

Thanks in advance....