Full-Stack Developer for Custom SaaS

Job Description: We are looking for an elite Full-Stack Developer to build a high-velocity, custom web-based Sales Leaderboard and Performance Tracking application from scratch. The previous developers failed because they could not handle dynamic relational data structures, time-series aggregations, and strict role-based access control (RBAC). If you are just a WordPress developer or element-shifter, do not apply. We need an engineer who can architect a clean, scalable database and a lightning-fast, high-end frontend. Core System Architecture & Features: 1. Multi-Level Authentication Hierarchy (Strict RBAC) Agent Level: Personal login. Access is restricted exclusively to their personal dashboard, individual KPIs, historic performance, and manual entry forms. Manager Level (Parent-Child Hierarchy): Access to their personal production plus real-time aggregation of their specific team’s production. Cannot see other teams' data unless explicitly granted. Admin/Executive Level: Global override access. Full visibility into all individual, team, and company-wide metrics, with user/team management capabilities. 2. End-of-Day (EOD) Manual Log Engine A clean modal/pop-up triggered by a prominent action button at the end of the shift. Required Input Fields: Dials/Calls Made Presentations Completed Sales Closed (Count) Annual Premium (AP) Written ($) Leads Received (Count) Lead Spend ($) (Flexible/anytime upload capability) 3. Analytics, Time-Series Aggregations & Leaderboards Dynamic Leaderboards: High-end visual rankings sorting agents and teams by KPIs (AP, Sales, Dials). Timeframe Toggles: Instant filtering across Daily, Monthly, and Yearly intervals. Advanced Metrics Tracking: The system must automatically calculate rolling conversion rates (e.g., Dials-to-Presentations, Presentations-to-Sales) and ROI calculations based on the uploaded Lead Spend vs. Annual Premium. Technical Stack Preferences: Frontend: Next.js, React, or Vue.js (Tailwind CSS for ultra-clean UI). Backend/Database: Node.js (TypeScript) or Python (FastAPI/Django) paired with PostgreSQL or Supabase for robust relational data mapping and time-series efficiency. Auth: NextAuth, Clerk, or Supabase Auth configured for secure, ironclad RBAC. How to Apply (The Filter): To prove you read this entire brief and actually understand the assignment, start your application with the phrase "ARCHITECT FOUND." Briefly outline: What database structure you would use to efficiently calculate Daily/Monthly/Yearly metric rollups without destroying query speeds as team data scales. Link 1–2 specific examples of custom dashboard/SaaS platforms you have built from scratch involving multi-tier user logins.