Welcome to Western New York!!

The whole area is on the upswing. Jobs are increasing & the downtown area is seeing a lot of new development.
Amazon has just announced it is coming here, Geico has a large office, Yahoo has a facility & there is a solar panel manufacturing facility nearing completion. Our medical corridor in downtown has 3 large regional hospitals already, with our Children's hospital set to move to a new state of the art building on the campus in November.
We are a bridge away from Canada with many visitors regularly going either way. Sports: a minor league baseball team which has a downtown stadium that does fun theme nights & a Friday night bash with fireworks, Bills football (personally, not a big fan) & the Sabres hockey (that's my favorite sport!). Looks like you're a college football fan. UB is in the north towns & their team is on the rise with a good sized stadium & they are moving up in the ranks the last several years.
The weather: yep, it snows. I have lived thru about 6 "once in a lifetime" events in my 60 years. I had the 6+ feet in 24 hours event too, a couple of blizzards that got me stuck at work or unable to get to work & a surprise snowstorm that dumped 2 feet in downtown in a few hours. I am not a fan of snow, but I've lived in the south towns my whole life anyway. You get used to it. There are excellent ski resorts within an hour of the city & lots of snowmobiling trails.
But, it doesn't snow every day. Sometimes it gets to the 40's in January. We can got for weeks with only a little dusting of snow. I can go for weeks without shoveling. Schools get closed for bad weather a few times a year. But that is usually more in the south towns & many times it is more precautionary than absolute not.
On the other hand, we have a beautiful water front that has several marinas & lots of boating, fishing & recreational opportunities. We have a theater district that gets major plays. Hamilton is coming in 2018 I believe. An internationally renowned art museum. UB has a well respected medical school, a law school & there are many fine universities with many masters & doctorate schools.
As previous posters have said, the north towns get much less snow usually. So getting around is often easier there. It's just the way the winds hit the area. Hopefully the company he is going to has a relocation department or HR staff that can show you around & help you figure out the best area for you.
Also, we get snow. We don't get hurricanes or full force tropical storms. Our rare earthquakes are along the lines of something announced on the news & not felt. Tornadoes are rare but do occur. Flooding can happen in any area of the country, but no houses get washed away here. Power outages are usually short & the result of ice or windstorms. Usually power is restored quickly, but there have been a few isolated instances of longer outages. But that is really not the norm.
Sorry, I got carried away! Just know, Buffalo really isn't as bad as people think. Many people come here expecting to hate it & fall in love & never leave. Jim Kelly, the former pro quarterback didn't want to come to Buffalo so bad, he did everything he could to avoid it. He eventually came. And he's still here. In the Southtowns!