Senior Technical Architect / SaaS Consultant (Multi-Platform, Supabase/Postgres, API Leadership)

Senior Technical Architect / SaaS Consultant (Multi-Platform, Supabase/Postgres, API Leadership)

Senior Technical Architect / SaaS Consultant (Multi-Platform, Supabase/Postgres, API Leadership)

Upwork

Upwork

Remoto

3 weeks ago

No application

About

Job Title: Senior Technical Architect / SaaS Consultant (Multi-Platform, Supabase/Postgres, API Leadership) Project Overview We are building three interconnected SaaS platforms for the automotive industry: 1. Multi-Vendor Vehicle Auction Platform 2. Vehicle Appraisal Platform 3. Retail Car Dealer Website Platform (White-Label) Each platform has its own frontend and backend developers (freelancers), but all platforms must share a single core vehicle database, a unified data model, and a consistent API architecture. We are looking for a Senior Technical Architect / Consultant who can design the core technical foundations, manage data consistency, guide the freelancers, and ensure all three platforms work seamlessly together. This is a high-impact strategic role. ________________________________________ Responsibilities 1. Architecture & System Design • Design the overall technical architecture for all three platforms. • Define how Appraisal, Auction, and Dealer Retail modules interact. • Architect a single shared multi-tenant database (Supabase/PostgreSQL). • Create a unified domain model (Vehicles, Listings, Appraisals, Media, Tenants, Users, etc.). • Design scalable backend module structure (modular monolith or microservice-ready). • Decide standards for: o API design o Versioning o Authentication & authorization o Database migrations o Multi-tenant data isolation 2. Database Architecture • Design DB schema, tables, relations, and data flows. • Implement or supervise DB migrations. • Define long-term schema evolution strategy (adding fields without breaking clients). • Set rules to prevent data duplication across platforms. • Review all DB changes from freelancers and approve/reject as needed. 3. Technical Project Leadership • Oversee and coordinate the work of: o Auction platform freelancer o Appraisal platform freelancer o Dealer website platform freelancer • Ensure developers follow the same architecture, naming conventions, and API contracts. • Review code related to core backend, database, and API changes. • Provide guidance, documentation, and technical direction. 4. API Governance • Design the shared Vehicle API, Appraisal API, Auction API, Retail API. • Maintain documentation (OpenAPI/Swagger). • Ensure backward compatibility when adding fields/features. • Prevent breaking changes across modules. 5. Strategic Advisory • Advise on infrastructure choices (Supabase, backend framework, storage, hosting). • Identify technical risks and propose scalable solutions. • Set up CI/CD and environment structures (dev, staging, production). ________________________________________ Requirements (Must-Have) • 5+ years’ experience as Technical Architect / Lead Backend Engineer / SaaS Consultant. • Strong knowledge of PostgreSQL or Supabase data modeling. • Proven experience building multi-tenant SaaS platforms. • Expertise in designing API architectures (REST or GraphQL). • Strong experience with backend frameworks (Node.js/NestJS, Laravel, Django, or similar). • Experience guiding multiple developers or managing distributed teams. • Ability to create clear documentation and enforce technical standards. • Experience with database migrations, schema versioning, and evolving APIs. • Excellent communication skills and ability to translate business requirements into technical solutions. ________________________________________ Nice-to-Have • Automotive tech experience (dealer software, auction software, or inventory platforms). • Experience with Supabase RLS (Row Level Security). • Experience with white-label SaaS systems. • Experience with scalable cloud architecture (AWS/Google Cloud). ________________________________________ Deliverables 1. Central technical architecture document (PDF/Notion). 2. Unified data schema for Vehicles, Appraisals, Auctions, Retail Listings. 3. API structure + naming conventions + documentation. 4. Deployment and environment plan (dev/staging/production). 5. Weekly technical oversight of freelancers. 6. Reviews and approval of all DB and API-related work. 7. Ongoing consultation for scaling and technical decisions. ________________________________________ Work Style & Commitment • Flexible hours, part-time but ongoing. • Must be available for: o Weekly review calls o Architecture planning o Technical decision-making • Medium-term relationship preferred (1–3 months). ________________________________________ How to Apply Please include: 1. A brief description of similar multi-platform systems you’ve architected. 2. Experience with multi-tenant SaaS or shared-database architectures. 3. Your preferred tech stack. 4. Examples of API/documentation work (if available). 5. Your hourly rate and weekly availability.