We need a Python developer to build an automated scoring/ranking system that pulls data from multiple sports APIs and generates daily reports. What we need: We have 3 data sources (sports stats APIs — will share docs after hiring) that we need to pull data from daily, run through a custom scoring algorithm, and output the results to a Google Sheet that our team reviews each morning. Specifically: - Connect to 2-3 REST APIs to pull daily player/team statistics - Build a scoring engine that ranks entries based on weighted criteria (we'll provide the formula, but it involves ~10 factors with different weights) - Output results to Google Sheets with formatting (color coding for top/bottom performers) - Automated daily execution (cron job or similar — we have a Linux VPS) - Simple logging so we can see if something failed - Clean, documented code we can maintain ourselves What we have already: - API keys and documentation for all data sources - The scoring formula in a spreadsheet (needs to be translated to code) - A Google Cloud project set up with Sheets API enabled - A VPS running Ubuntu where this will run Nice to have but not required: - Historical data tracking (append daily results rather than overwrite) - Slack notification when the daily run completes or fails This is a straightforward project for someone experienced with API integrations. We're not looking for anything fancy — just reliable, clean code that runs daily without issues. 1. What would be your estimated cost and timeline for this project? 2. Describe a similar project where you integrated multiple APIs and processed/transformed the data. 3. How would you handle a situation where one of the APIs is down or returns unexpected data during the daily run?