I think I got it figured out... the issue has to do with the "fingerprint" for sftp (scp). For some reason, even if I set the SQL Server job to use my login, the security fingerpring needs to be in the cache of the sql server agent service user. I am not sure yet if this is a temporary or permanent solution... I need to do some more research on sftp security.