It is not insane, not sure why to include SSIS when storedprocs alone can do the ETL process.
On the other hand, I would refer to the database as a Reporting Database 'cause it doesn't look like a proper Data Warehouse e.g. "one table per report".
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.