Twilio has their SuperSIM (https://www.twilio.com/docs/iot/supersim) for these use cases but the pricing might be too high for what you're looking for. There's also Hologram (https://www.hologram.io/). I'd try looking for IoT data providers (rather than cellular ones).

I've also personally worked with these guys before and they are legit: https://www.zipitwireless.com/