I believe that your thinking with a holiday dates table is spot on Joshua.

Your job could simply determine if today's date is in the table, and if not, could then run another separate job using sp_start_job to perform the actual import.