About

🔧 Senior Python/FastAPI Engineer Needed — Build a Robust Job-Ingestion Service (Simpro API Integration) Long-term Work Available | Strong Backend & API Engineering Required I’m looking for an experienced Python backend engineer (FastAPI preferred) to build a production-ready service that integrates with Simpro (and later other job-management platforms) to securely ingest, sync, and write back job data into my application. This is not just a simple API wrapper — I need someone with serious engineering experience to design a safe, durable, idempotent ingestion pipeline that prevents duplication, race conditions, and inconsistent database states. ⸻ 🔥 What You’ll Be Building A standalone FastAPI microservice that can: 1. Ingest Job Data from Simpro (via their public API) • Pull job records and associated entities • Handle pagination, rate limits, retries • Normalise & map to internal schemas • Support incremental syncs and scheduled polling 2. Guarantee Idempotency & Data Integrity Your ingestion pipeline must: • Ensure no duplicate records • Prevent race conditions • Handle partial updates safely • Implement idempotent upsert logic • Use safe database transactions & locking patterns • Support “last updated” or delta-based syncs 3. Handle Bi-Directional Syncing • Push updates back to the Simpro API • Full CRUD support (create/update delete) • Keep track of external IDs vs internal IDs • Conflict resolution strategy 4. Logging & Error Handling • Structured logging • Retry & backoff logic • Dead-letter queue pattern (preferred but optional) • Detect & surface API failures gracefully ⸻ 🧰 Tech Requirements You MUST be highly proficient in: • Python 3.10+ • FastAPI • Async programming (async/await, aiohttp/httpx) • PostgreSQL • SQLAlchemy ORM • Idempotent pipelines & concurrency-safe patterns • Familiar with Simpro API (preferred but not essential if strong API skills) Bonus skills: • Celery / RQ task queues • Redis • Experience designing webhook receivers • Multi-tenant SaaS architecture ⸻ 🔍 What I’m Looking For Please apply only if you can: • Architect a clean, maintainable service • Think about edge cases (duplicates, retries, partial updates) • Write excellent documentation • Produce clean, modular, testable code • Communicate clearly This is not for junior developers or “API hobbyists.” I need someone who has built robust backend services before. ⸻ 📦 Deliverables • FastAPI service with all endpoints • Database models + migrations • Ingestion scheduler • CRUD back to Simpro • Idempotent pipeline • Full README • Unit tests for key functions ⸻ 🚀 To Apply, Include: 1. A short summary of similar systems you’ve built 2. A description of how you would implement idempotency and race-condition protection 3. Your GitHub or code samples 4. Estimated timeframe ⸻ If this goes well, you will become my ongoing backend engineering partner across multiple microservices.