Senior Full Stack Developer

🧠 EGEAL FINAL COMPLETE SCOPE (NO BS MASTER VERSION) SYSTEM STATUS 🟢 WORKING (SELLABLE CORE EXISTS) * Lead capture (Carrd → Make.com → Airtable) * Stripe checkout + payment flow * Webhook verification (Stripe secure) * Basic lead unlocking after payment * Promo code system (logic exists) * Commission calculation system * Influencer + campaign structure (partial but usable) * Dashboard (shows leads + unlocked data) * CSV export (founder + admin) * Lead scoring system (works but incomplete inputs) ⸻ 🟡 PARTIALLY WORKING (LOGIC OK, DATA BROKEN) * Influencer attribution chain (fragile Airtable linking) * Conversion tracking (computed, not stored) * Subscription system (logic correct but Stripe schema bug) * Promo usage counter (race condition exists) * Leaderboard system (logic correct, data incomplete) * Revenue aggregation (missing subscription inclusion) ⸻ 🔴 CRITICAL SYSTEM GAPS (BLOCK SCALE + AUTOMATION) 1. DATA INTEGRITY (MAJOR) * Missing Founder links in Airtable * Broken Campaign → Lead relationship consistency * Leads can become “orphaned” in chain ⸻ 2. CLICK TRACKING SYSTEM (MISSING) * No click database * No /track endpoint * No funnel visibility before signup ⸻ 3. EVENT LOGGING SYSTEM (MISSING) No system to track lifecycle events: Missing: * lead_created * click_registered * payment_started * payment_success * lead_unlocked * commission_created * webhook_failed ⸻ 4. COMMISSION PAYOUT SYSTEM (DEAD) * payout function exists but is NOT connected * no execution flow (manual only) ⸻ 5. STRIPE SUBSCRIPTION BUG (CRITICAL) * incorrect period mapping (subscription.items.data[0]) * causes billing date corruption ⸻ 6. ATTRIBUTION SYSTEM INCOMPLETE Missing full chain: click → lead → payment → unlock → revenue → payout Currently: * only partial chain exists ⸻ 7. MONITORING / OBSERVABILITY (MISSING) * no Sentry * no alert system * no system health tracking * no webhook failure notifications ⸻ 8. PROMO CODE RACE CONDITION * usage counter not atomic * can break at scale ⸻ 9. RETRY / RECOVERY SYSTEM (MISSING) * no retry queue * Make.com failures can silently drop data * no reconciliation mechanism ⸻ 10. TRACEABILITY SYSTEM (MISSING BUT CRITICAL FOR SCALE) * no global trace_id * cannot track full journey across systems ⸻ 🧾 FINAL DEV EXECUTION STRUCTURE ⸻ PHASE 1 — FIX DATA FOUNDATION (CRITICAL FIRST) MUST FIX: * Founder linking in Airtable * Campaign → Lead consistency * backfill missing relationships RESULT: ✔ no orphan leads ✔ correct attribution base ⸻ PHASE 2 — FIX STRIPE + REVENUE CORE MUST FIX: * subscription date bug * correct Stripe schema usage * revenue aggregation (include subscriptions) RESULT: ✔ correct money tracking ✔ stable billing data ⸻ PHASE 3 — BUILD FULL ATTRIBUTION SYSTEM MUST ADD: * click tracking (/api/track) * Click_Events table * full funnel mapping RESULT: ✔ click → lead → payment visibility ⸻ PHASE 4 — BUILD EVENT LOGGING SYSTEM MUST ADD: * Event_Log table * system-wide event tracking * all lifecycle events stored RESULT: ✔ full system traceability ⸻ PHASE 5 — COMMISSION + PAYOUT AUTOMATION MUST DO: * connect payOutPendingCommissions * create payout endpoint or cron * Stripe Connect execution RESULT: ✔ automatic payouts ✔ no manual financial work ⸻ PHASE 6 — MONITORING + ALERTS MUST ADD: * Sentry (or equivalent) * webhook failure alerts * Stripe failure notifications RESULT: ✔ no silent failures ⸻ PHASE 7 — SCALE SAFETY LAYER MUST ADD: * retry system (Make.com + backend) * atomic promo code usage fix * global trace_id system * optional reconciliation job RESULT: ✔ system safe at scale Must have experienced * full stack developer * next.js developer * node.js developer * api integration * stripe api * automation * airtable * webhook * debugging * saas development Frontend I have code and deisgn ready some small changes need