Job Description
Supabase / PostgreSQL Free-Text Search Engineer (High-Precision, Ranked)
Budget: Fixed (senior engineers only)
Database size: ~250,000 records
Platform: Supabase (PostgreSQL), Node js/python
Objective
Users will enter free-text search queries (keywords, phrases, or natural language).
Your responsibility is to return only the businesses that truly match the query, ranked from most relevant to least relevant.
Precision is mandatory.
False positives are not acceptable.
If a business does not genuinely satisfy the query intent, it must not appear in results.
Final Outcome (Read Carefully)
The final deliverable is:
ONE search API / RPC function that:
Inputs
query_text (required, free text)
latitude (optional)
longitude (optional)
limit (default 20, max 50)
offset or cursor
Behavior
If latitude and longitude are provided:
Prefer nearby matching businesses
Distance should influence ranking, not act as a hard filter
If locati...
Budget: Fixed (senior engineers only)
Database size: ~250,000 records
Platform: Supabase (PostgreSQL), Node js/python
Objective
Users will enter free-text search queries (keywords, phrases, or natural language).
Your responsibility is to return only the businesses that truly match the query, ranked from most relevant to least relevant.
Precision is mandatory.
False positives are not acceptable.
If a business does not genuinely satisfy the query intent, it must not appear in results.
Final Outcome (Read Carefully)
The final deliverable is:
ONE search API / RPC function that:
Inputs
query_text (required, free text)
latitude (optional)
longitude (optional)
limit (default 20, max 50)
offset or cursor
Behavior
If latitude and longitude are provided:
Prefer nearby matching businesses
Distance should influence ranking, not act as a hard filter
If locati...
Apply for this Position
Ready to join Confidential? Click the button below to submit your application.
Submit Application