Welcome to Pittsburgh. It's a great place to live and call home.
As for neighborhoods, it all depends upon what you are looking for. Convenience may also be a very important consideration, so first research area's near where you will be working. There are resources on the Internet that are very helpful but you also should tour the area's to get firsthand knowledge of them.
As for rentals you may have to check many sources. Newspapers, for rent signs, Internet sites including craigslist (but be careful of scams) may be good resources. You may need to contact multiple agents as most rentals (unlike sales) are not on the multi-list .
If you do not already have black and gold in your wardrobe you will find it plentiful here. Go Steelers!
Good luck and welcome to Pittsburgh.