Not sure I agree with not doing over night jobs.
I've built data warehouses in my last 3 jobs for finance reporting joining the data from the finance application and CRM systems and set them up to run first thing in the morning, all the data is available and I can answer any question on the data within minutes, summaries are also a doddle as cutting the data is a simple query. I'm sure there are examples where you would need "live" data but a snapshot at the end of the previous day is usually enough for most reporting requirements. I just don't see the benefit of direct connections where using an output and loading that in works just as well. This is just my experience so others may have a different opinion.