Experienced Backend Python Engineer – Data Driven Workflow Automation with PostgreSQL & Intelligent
UpworkPKNot specifiedexpertScore: 32
Python
I'm seeking an experienced Python developer to build a backend engine that performs intelligent selection and state handling over continuously changing data. The focus is on writing efficient algorithms, managing workflow state, and ensuring reliable processing.
Key Responsibilities
Periodically pull the latest work items from PostgreSQL.
Apply a constraint-based selection algorithm (e.g., matching, set packing, greedy + heuristics).
Ensure selected groups do not violate defined constraints (such as shared resources/nodes).
Store decisions back into the database with proper locking, status transitions, and auditability.
Implement TTL/expiry handling, rollback logic, and safe reprocessing.
Build clear logging, traceability, and debugging support.
Design reliable scheduled workers or event-driven processes.
Required Skills
Strong Python development with clean, testable, maintainable code.
Solid understanding of algorithms, optimization techniques, and data structures.
Experience with constraint-solving approaches and heuristic decision systems.
Stateful workflow design (state machines, idempotency, retry safety).
Advanced PostgreSQL knowledge: indexing, query optimization, transactions, and concurrency control.
Background in background workers, polling systems, or queue-based processing.
Familiarity with race-condition handling and data consistency guarantees.
Preferred / Nice to Have
FastAPI for lightweight service layers or APIs.
Docker for containerized deployment.
Experience with high-throughput or real-time systems.
Knowledge of distributed processing patterns and observability tooling.
Tech Keywords (for searchability)
Python, PostgreSQL, SQL Optimization, Algorithm Design, Constraint Optimization, Scheduling Systems, State Machines, Idempotent Workflows, Heuristics, Data Processing Pipelines, Background Workers, Transaction Management, Concurrency Control, FastAPI, Docker, Backend Architecture, System Design, Logging & Observability.
This role is ideal for someone who enjoys solving complex selection problems, designing reliable processing flows, and building robust backend logic rather than UI-heavy applications.
Unlock AI Intelligence, score breakdowns, and real-time alerts
Upgrade to Pro — $29.99/mo