Hi Erik,
Helluva change from Cancun, eh?
From local diving perspective (within the Lower Mainland), the typical haunts are Whytecliff Park, Porteau Cove, Whiskey Cove, Kelvin Grove, Ansell Place, etc. They are all within a 10-30 minute drive of Vancouver. They can be relatively simple dives or as technical as you want to get.
On any given weekend, year-round, you'll find numerous divers at Whytecliff and Porteau Cove, but you'll also find a number of classes, as well.
There is a large tech community here, so I'm sure you'll find lots of buddies looking to do technical dives with you.
My LDS is in Langley, so I'll let the "city boys" suggest shops for you to deal with in town. From what I've read, they're all pretty decent shops.
When you're here, you should try and grab
151 Dives or order it from her online. It's a great resource of many local dives.
My suggestion is to keep reading and posting and get to know a few people. We all meet from time-to-time for a dive and many of us dive together fairly regularly and we'd be happy to have you join in when you're up here.
Todd