FWIW, PGHoard (https://github.com/aiven/pghoard/) is another PostgreSQL backup daemon that works with S3, GCS, Azure and Swift.

Implementing a SFTP backend using e.g. paramiko in PGHoard should be pretty simple.