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! |
