Internal SMS Messaging Tool Development

I need to build an internal SMS messaging tool that integrates with Retool on the front end and AWS on the back end. This tool will allow our team to upload a CSV/Excel file with phone numbers, validate each number before sending a message, provision AWS End User Messaging (EUM) numbers, schedule messages, and generate reports.

✅ Not client-facing – Used only by our internal team.
✅ Retool as the front-end – To manage all messaging operations.
✅ AWS as the back-end – To handle SMS validation, sending, number provisioning, and tracking.

Key Features:
- Use Amazon Pinpoint for SMS validation, sending, and tracking.
- Generate reports on delivery status and message content.
- Implement automated validation of phone numbers via API.

Ideal Skills and Experience:
- Proficiency in Retool.
- Extensive experience with AWS, specifically Amazon Pinpoint.
- Knowledge of API integration for automated tasks.
- Ability to create detailed reporting systems.