Developer Job Specification: Automated Data Processing Portal for Warm & Inflyte Overview: We are looking for an experienced backend developer (preferably with API integration and automation experience) to build a custom platform/portal that automates our current manual data processing workflow between Warm Radio Airplay Tracking and Inflyte DJ Feedback. We currently download: this from Warm Which is plays on radio: https://www.dropbox.com/scl/fi/hwyb5rwx6bwyxfvmptkiz/WARM-Report-for-Mau-P-All-Songs-2024-12-13_2025-03-13.xlsx?rlkey=yf2a9tqooyi4fgvk2t4c6xejk&e=1&dl=0 and this from Inflyte which is DJ Feedback: https://www.dropbox.com/scl/fi/xi3d5fc3jkf4txtyiopjc/Inflyte_stats_189484-4.docx?rlkey=4oiagwg19beuo9lcmjtyk13lr&e=1&dl=0 Currently, we download data from both platforms manually, reformat it in Excel, and update a Google Sheet weekly. Example: https://www.dropbox.com/scl/fi/q1uc6iqcf3jqa2xuwxs3k/Mau-P-The-Less-I-know-The-Better-Radio-Club-Report-wc-3_3-NERVOUS.xlsx?rlkey=234f890e9799b4pv7n1z3llic&e=1&dl=0 We need a streamlined automated solution to handle this process. Project Requirements 1. Core Functionality • API Integration (https://www.dropbox.com/scl/fi/nyfhnldl6g3qn0jhiowc8/Inflyte-Customer-API-v1.5.pdf?rlkey=k52sdcygmt3uiv2u7fy6cj968&e=1&dl=0) ◦ Connect to Warm API (Radio Airplay Tracking) - https://www.warmmusic.net/ ◦ Connect to Inflyte API (DJ Feedback) - https://inflyteapp.com/ ◦ Extract relevant data from both sources • Data Processing & Transformation ◦ Normalise, clean, and format the extracted data to match our required structure ◦ Merge both data sources appropriately • Google Sheets Integration ◦ Append new weekly data to an existing Google Sheet ◦ Move previous week's data to the bottom of the sheet ◦ Ensure easy manual editing when required 2. Additional Features (Nice-to-Have) • Automated Weekly Scheduler ◦ Set up an automatic weekly data update ◦ Option for manual trigger (button inside a simple web UI) • Basic User Interface (Optional but preferred) ◦ Secure login for internal team ◦ Dashboard to view processed data logs & allow manual refresh • Error Handling & Logging ◦ Notify us via email/Slack if the automation fails Tech Stack Preference (Flexible) • Backend: Python (Flask/Django) or Node.js (Express) • Database: Google Sheets API (or PostgreSQL if needed) • Hosting: AWS Lambda, Google Cloud Functions, or Heroku • Frontend (Optional): React/Next.js (for basic UI) Ideal Candidate Skills • Experience working with API integrations (RESTful APIs, JSON) • Proficiency in Python or Node.js for automation • Google Sheets API knowledge • Cloud hosting experience (AWS/GCP/Heroku) • Strong problem-solving and debugging skills How to Apply To be considered, please send a proposal including: • Relevant past experience with API automation & Google Sheets • Your suggested approach for building the system • Any portfolio/examples of similar work Looking forward to working with a skilled developer who can streamline our process and save us valuable time!