Contract Software Developer

The Warren Group is seeking an experienced contract software developer to design, build, and deliver a production-ready, client-facing API platform built on Supabase. This is a project-based engagement with a defined scope and an 8–12 week timeline.

The successful candidate will take an existing Supabase foundation — with production data loaded and a working authentication layer — and complete it into a fully operational API product that external customers can use to programmatically query TWG's real estate datasets. The platform must be secure, performant, well-documented, and maintainable by TWG's internal team after the engagement ends.



Responsibilities:

Review existing codebase, database schema, and technical documentation to understand the current state of the platform

Enable and configure Row Level Security (RLS) across all Supabase database tables

Enable PostGIS extension and implement geospatial indexing to support radius and bounding box search queries

Design and deploy versioned REST API routing (/v1/) with a structured response envelope including status, paging, and total counts

Build GraphQL endpoints for primary data tables with support for custom column selection and filtering

Develop an admin API supporting customer onboarding, API key creation, rotation, and revocation

Implement a self-service trial key signup flow with automated 14-day / 100-call expiration via pg_cron

Build internal reporting views for billing, usage summaries, near-limit alerts, and contract expiry tracking

Migrate the existing GCP VM-based data loader to Cloud Run for automated, serverless pipeline execution

Create and maintain separate test and production Supabase environments with version-controlled deployment

Write complete operational documentation and a staff runbook covering all routine administrative tasks

Conduct end-to-end testing and performance validation against production-scale data

Deliver a structured handoff including a walkthrough period with TWG staff before the engagement closes



Required Qualifications

Education

Bachelor's degree in Computer Science, Software Engineering, Information Systems, or equivalent practical experience



Experience

3+ years of professional software development experience in a backend or full-stack role

Demonstrated production experience with Supabase — including PostgreSQL schema design, Edge Functions, and RLS configuration

Proven experience designing and delivering REST APIs that are consumed by external clients or partners

Experience working with large relational datasets (50M+ rows) including query optimization and indexing strategy

Prior experience on a contract or project-based engagement with a formal deliverable and handoff


Technical Skills

PostgreSQL — schema design, migrations, views, stored procedures, RLS policies, pg_cron

Supabase — Edge Functions (TypeScript / Deno), PostgREST, database migrations, project management

TypeScript — production-quality code with inline documentation

REST API design — versioning, authentication patterns, error handling, response envelopes

GraphQL — endpoint design and implementation

PostGIS or earthdistance — geospatial query design and spatial indexing

API key authentication — hashed storage, lifecycle management, trial key automation

GCP — Cloud Run, Cloud Storage, scheduled jobs (or equivalent serverless container experience)

Git — version control, branch management, protected production branches



Preferred Qualifications

Experience building developer-facing APIs as commercial or monetized products

Familiarity with real estate, property records, mortgage, or financial data

Experience with FTP-to-cloud data ingestion pipelines

Exposure to billing integration, usage metering, or quota enforcement systems

Prior experience writing documentation and runbooks for non-technical or semi-technical operations teams

Familiarity with MCP (Model Context Protocol) server architecture



Key Competencies



Ability to work independently with minimal day-to-day supervision against a defined scope and timeline

Strong written communication — able to explain technical decisions clearly to non-technical stakeholders

Detail-oriented — the platform will handle sensitive commercial data and billing; precision matters

Proactive — surfaces blockers and ambiguities early rather than discovering them at deadline

Commitment to handoff quality — takes responsibility for the maintainability of what they build, not just whether it runs



What You Will Receive

Complete technical documentation package at project start: API Requirements Specification, Feasibility Assessment, Data Structures workbook, and Project Discovery document

Direct access to TWG's Project Lead and CEO for timely decisions and approvals

Access to the live Supabase project with production data already loaded

A well-defined scope with clear deliverables — not an open-ended or shifting engagement

Competitive project-based compensation commensurate with experience