Part Time
$8/hr
20
Jul 26, 2026
About Us
We are a vehicle rental company in Florida, USA. We rent cars to delivery and rideshare drivers — people who work for Uber, Lyft, DoorDash, and other similar gig platforms.
Our insurance company charges us based on how the cars are used. Miles driven while the renter is working on an app cost a different amount than miles driven for personal use. Every month we must give our insurance company a report that proves the split.
Right now we do this by hand. We have 20 cars. We are growing to 74 cars over the next three years. Doing this by hand will not work much longer. We need it automated.
What You Will Build
A system that pulls data from three places, combines it, and produces one report every month — with no manual work.
The three data sources
1. GPS trackers in each car. These tell us every trip: when it started, when it ended, and how many miles.
2. Argyle API (a REST API). This tells us when the renter was logged into a driving app and what they were doing.
3. GoHighLevel (our CRM). This tells us which renter had which car on which dates.
What the report must show, for each car, each month
• P0 — miles driven with the app OFF (personal use)
• P1 — miles driven with the app ON but not on a job
• P2 — miles driven while on a job
The most important rule: P0 + P1 + P2 must add up to the exact total from the GPS. Not close. Exact. Our insurance company checks this first.
We will give you a complete written specification. It explains the full method, the API fields to use, every difficult case and how to handle it, and a working Python prototype of the core logic. You are not designing this from nothing. You are building it properly and making it run by itself.
Your Responsibilities
Build phase — about 8 weeks
1. Set up a PostgreSQL database to store trips, jobs, cars, and renters.
2. Connect to the Argyle API. Handle login, paging through results, rate limits, and webhooks.
3. Automate getting the GPS data. Check if the GPS company has an API. If not, automate the export another way.
4. Connect to the GoHighLevel API to get rental records.
5. Build the calculation that splits the miles into P0, P1, and P2.
6. Write tests. We will give you one example with known correct answers. Your code must produce those exact numbers.
7. Generate the monthly Excel report and CSV automatically.
8. Set it to run on a schedule, with no one pressing a button.
9. Write documentation so another developer could take over.
Ongoing — after launch
• Watch the system and fix problems.
• Send us a weekly list of renters who have not connected their driving apps.
• Add new cars and new data sources as we grow.
• Improve accuracy over time.
Required Skills
• Strong Python. You must be very comfortable with pandas and with working with dates and times.
• REST API experience. You have connected to APIs before using authentication, paging, and error handling.
• Time zone knowledge. Our GPS records local Florida time. The Argyle API returns UTC. If you have never had a bug caused by time zones or daylight saving, this job will teach you the hard way.
• PostgreSQL or a similar SQL database.
• Automated testing. This report goes to an insurance company. Code that is not tested is not finished.
• Good written English. Most of our communication is written.
• You ask questions when something is unclear. Guessing is worse than asking.
Nice to Have
• Experience with GPS or vehicle tracking data
• Experience with webhooks
• Experience with openpyxl or another Excel library
• Experience with scheduled jobs (cron, Airflow, or similar)
• Experience with data that must be audited
I need to be able to at least manually produce this report within the week then from there we can work to build and automate it. For now if we can understand and create a video on how we will pull the data from the two systems and produce a clean report, underwriting with insurance will accept that. However, long term, we are expanding our fleet, so automation will be key to eliminate room for error.
Please reply with your experience and resume and salary requirements.