Responsibilities
- Build and ship features across the stack: Next.js dashboards, FastAPI endpoints, and the Cloud SQL (PostgreSQL) data layer behind them.
- Work with Amazon data integrations: SP-API and Advertising API report requests, polling lifecycles, token refresh, rate-limit handling, and mapping responses into our schemas.
- Maintain and extend the reporting pipeline: scheduled report generation, batch processing through Cloud Tasks, and the running, queued, completed, and failed states around long-running jobs.
- Optimise data-heavy frontend views (schedule lists, vendor, seller, and catalogue tables): list virtualisation, pagination, code-splitting, render performance, and TanStack React Query cache tuning.
- Tune the serving platform: Cloud Run cold starts, concurrency, and minimum instances, hosting and content delivery network (CDN), and the trade-off between latency and cost.
- Optimise the read path in Structured Query Language (SQL) across BigQuery and PostgreSQL, and help evolve the schema as we migrate workloads.
- Establish performance measurement (Core Web Vitals, application programming interface (API) latency, Cloud Run metrics) and act on the real bottlenecks rather than assumptions.
- Write clean, well-tested code: unit tests on service logic, integration tests on endpoints.
Requirements
- Solid working Python
- Experience with backend development using FastAPI (Python)
- Experience with frontend development using Next.js, React, and TypeScript
- Familiarity with Google Cloud Platform (Cloud Run, Cloud Tasks, Cloud Scheduler)
- Experience with SQL across BigQuery and PostgreSQL
- Ability to write clean, well-tested code including unit and integration tests
Nice to Have
- Experience using artificial intelligence (AI) tools such as Claude Code to increase development speed
Additional Information
- Role is on day shift
- Remote work based in the Philippines
- Candidates are encouraged to use AI tools like Claude Code to move faster
