Even for small freelance jobs in the US, I've always had to provide a social security number to get paid. Sure, as an individual, I could pay you some amount of cash under the table but a company can't really legitimately do that.

As others have said, that doesn't mean you can't go by a "pen name" if you like assuming the company is reasonably flexible with email addresses, employee directories, etc.