Experienced Software Architect and Full-Stack Engineer

Summary
We have an MVP for a Personal & Business Finance Platform built with Lovable.dev (Next.js + Node). We need a senior full-stack engineer to review, refactor, and upgrade the MVP, implement a full Supabase backend, and add critical integrations (Stripe, Plaid, Resend, Storage, Square, QuickBooks, credit bureaus, OpenAI, PDF/Excel exports, etc).

You will own the technical foundation that prepares the product for launch while coordinating with a product designer and SEO & marketing personnel to deliver the company's vision.

???? Responsibilities
1. Supabase Database Schema (Required First Phase)
- Design and build Supabase tables for:
- Transactions
- Budgets
- Accounts (bank, investment, real estate)
- Business data (P&L, inventory, invoices, etc.)
- User preferences

Include:
Row-level security (RLS)
Role-based access control tied to org/user IDs
Foreign keys & relationships
Sample data & migration scripts

2. Integrations
Plaid API (Bank Sync) — Optional but Recommended
Connect bank accounts, sync transactions, balances, and webhooks.
Map Plaid data to Supabase tables.
Deduplicate & categorize transactions.

• Stripe (Subscriptions & Marketplace Payment)
• Implement subscription plans using Stripe Billing.
• Add one-time payments for templates/marketplace.
• Set up webhooks (payment success, subscription updated, failed renewal)
• Sync billing status with user accounts.

Resend API (Email Notifications)
• Implement reminders for bills, schedules, and goals.
• Template-based system (HTML + text).
• Use free tier (100 emails/day).

Supabase Storage
• Create file storage buckets for user documents:
• Implement secure upload/download/delete endpoints.
• Add proper ACL & signed URLs.

Credit Bureau Integration (Optional)
• Connect to Equifax, Experian, or TransUnion APIs.
• Display credit score & history.
• Must handle enterprise-level API security.

3. Report Generation (PDF & Excel)
Backend functions to generate various personal and business reports in various formats (csv, Excel, PDF, etc.)

4. Codebase Review & Refactoring
Review the Lovable.dev-generated code for:
Performance
Security
Folder structure
API stability

Fix bugs and stability issues.
Implement best-practice patterns for Next.js APIs and Supabase queries.

5. Frontend Enhancements
Integrate new UI designs from the product designer.
Improve dashboard load speed and data-fetch patterns.
Implement charts and data visualizations from Supabase data.

???? Requirements
5+ years full-stack engineering experience.
Expert in Next.js, React, TypeScript, Node.js.
Strong experience with Supabase / PostgreSQL schema design.
Proven experience integrating:
• Stripe
• Plaid
• Resend
• Storage systems
• Credit Bureau APIs

Strong understanding of security, JWT auth, RLS, RBAC, and API design.
Experience with financial applications is a major advantage.
Must be able to work under tight deadlines.

???? Nice to Have
Prior work with Lovable.dev or AI-generated codebases.
Backend scaling experience (queues, workers, caching).
Familiarity with data visualization libraries.

Deliverables
Supabase schema implemented + documented.
Stripe, Plaid, Resend, Storage integrations.
Working PDF/Excel reporting engine.
Refactored MVP codebase.
Production-ready deployment guide + technical documentation.