NI businesses are facing a "very, very difficult" time in January when the Brexit transition period ends, a senior civil servant has warned.