Senior Supabase / TypeScript / AI Pipeline Engineer

UPWORK POST — Senior Supabase / TypeScript / AI Pipeline Engineer Needed to Fix Launch-Blocking Data Extraction Issue We are looking for a senior software engineer to help resolve a launch-blocking issue in a consumer-facing web platform that analyzes public online source material and turns it into structured, user-facing intelligence. This is not a simple website styling job. We need someone who can debug a real backend/data pipeline issue involving source retrieval, classification/entity matching, Supabase Edge Functions, TypeScript, OpenAI API calls, structured JSON extraction, database writes, and frontend presentation. The platform is already built and close to launch, but we are stuck on a specific quality/density problem in the backend pipeline. The current bottleneck: The system retrieves public source material, classifies/matches the user’s search entity, filters sources, sends evidence into an AI extraction step, and writes structured outcomes to Supabase. The problem is that valid, specific signals exist in the raw source data, but too many of those signals are getting lost, compressed, merged, or weakened before they appear in the final structured output. We need an engineer who can trace the full path: raw source data → entity/classification matching → source filtering → buyer/user signal validation → AI extraction payload → AI JSON response → post-processing → Supabase insert → frontend display The engineer must determine exactly where the data loss/compression is happening and implement a durable fix, not a temporary prompt Band-Aid. Required skills: * Strong TypeScript * Supabase * Supabase Edge Functions * PostgreSQL / SQL * Deno or serverless TypeScript runtime experience * OpenAI API / structured JSON extraction experience * Debugging AI-assisted data pipelines * Prompt-to-schema extraction workflows * Source filtering / entity matching / classification logic * React frontend familiarity * Ability to work carefully in an existing production-adjacent codebase * Ability to diagnose without breaking existing functionality Strongly preferred: * Experience with retrieval + classification + extraction pipelines * Experience with schema-constrained AI outputs * Experience debugging cases where AI output summarizes instead of preserving detailed source-level evidence * Experience with Supabase logs, SQL validation, Edge Function testing, and structured diagnostics * Experience building mobile-friendly web apps or Progressive Web Apps Mobile requirement: This is a website, but most users need to use it easily from their phones. We do not want to build a full native iOS/Android app that must go through the Apple App Store or Google Play Store. We need guidance and implementation support for a mobile-first web experience, likely including responsive design and/or Progressive Web App behavior, so users can access the platform from their phones without typing the website address every time. Important working requirement: We need this solved in no more than one week. Please do not apply if your approach is only “rewrite the prompt” or “add another AI instruction.” We need someone who can inspect the actual data path and prove where the loss occurs. What we will provide: * Existing Supabase project structure * Edge Function code * Relevant tables * Example test case * Current diagnostics/logs * Known failure pattern * Step-by-step reproduction process * Access as appropriate after NDA or confidentiality agreement Ideal deliverables: 1. Confirm the exact root cause of the density/compression issue. 2. Show evidence of where source-level data is being lost or merged. 3. Implement a durable fix. 4. Validate the fix with controlled test cases. 5. Preserve source quality while improving output density. 6. Avoid product-specific hardcoding. 7. Document what changed and why. 8. Advise on mobile-first/PWA deployment path. Please include in your response: * Your experience with Supabase Edge Functions and TypeScript. * Your experience with OpenAI structured JSON extraction. * A brief explanation of how you would debug this pipeline. * Whether you have built or improved a mobile-first web/PWA experience. * Your availability this week. * Whether you can commit to solving or clearly diagnosing the issue within 7 days. We are looking for someone careful, senior, and practical. This project needs root-cause debugging, not guesswork.