Senior Automation Engineer (n8n, Supabase, PostgreSQL, Claude API)

Senior Automation Engineer (n8n, Supabase, PostgreSQL, Claude API) We are a licensed Kuwaiti media company building a production-grade market intelligence platform for the Gulf fashion and beauty industry. This is not a discovery, consulting, or architecture project. The platform has already been fully designed. The database schema, workflows, API contracts, business rules, and implementation specifications are complete. Your role is to implement the supplied specification with production-quality engineering. ⸻ What You’ll Receive After signing an NDA, you’ll receive: * Production-ready PostgreSQL / Supabase schema * Production-ready LLM prompts * Detailed workflow specifications * API contracts * Specifications for approximately 12 official source adapters * Acceptance-test documentation * Deployment guidelines No product design or system architecture work is required. ⸻ Required Stack * n8n (Self-hosted) * PostgreSQL * Supabase * pgvector * Claude API * Docker Compose * faster-whisper * changedetection.io * ffmpeg * Linux VPS Strong SQL and PostgreSQL experience is required. ⸻ Project Structure The project is divided into three implementation milestones. M1 * Infrastructure * Database * Source adapters * Ingestion pipeline M2 * Cross-source reconciliation * Intelligence workflows * Ranking pipeline M3 * Dashboard integration * Upload/transcription workflow * Human review gates * Final production handover ⸻ Payment This is a Fixed Price project. Please submit: * Fixed price for Milestone 1 * Fixed price for Milestone 2 * Fixed price for Milestone 3 * Total project price * Short justification for your pricing Hourly proposals will not be considered. Each milestone is funded separately and payment is released only after all acceptance tests pass. ⸻ Engineering Requirements * Follow the supplied specification exactly. * No schema or workflow modifications without written approval. * Official APIs and RSS only. * No Instagram, TikTok, Snapchat or LinkedIn scraping. * All database writes must pass through the provided ingestion interface. * Credentials must never be stored in source code. * AI-assisted coding is acceptable, but every submitted implementation must be fully reviewed and understood by the developer. * Production-quality code, documentation and deployment configuration are required. ⸻ Required Experience You should have strong experience with: * n8n * PostgreSQL * Supabase * Docker * REST APIs * Workflow Automation * Backend Engineering * SQL Performance * Production Deployments Experience with AI workflow orchestration is a significant advantage. ⸻ Required Questions Please answer both questions. Q1 In a system where every business record must always be traceable to its origin, how would you guarantee that invariant even if application code contains bugs? Q2 Two text embeddings produce a cosine similarity score of 0.84—below your automatic match threshold but above noise. How should the pipeline handle that pair? Applications without both answers will not be considered. ⸻ Selection Process 1. Application review 2. Technical shortlist 3. 30-minute technical interview 4. Paid technical micro-task (USD $100) The micro-task consists of implementing one news-feed adapter in n8n that writes to a test Supabase environment through the provided ingestion interface. The strongest implementation will receive the full contract. ⸻ Long-Term Opportunity Successful delivery may lead to a separate long-term maintenance agreement.