Senior Python Backend Engineer – PostgreSQL + IoT + Home Assistant IntegrationFreelanceJobs • Canada
This job offer is no longer available
Senior Python Backend Engineer – PostgreSQL + IoT + Home Assistant Integration
FreelanceJobs
- Canada
- Canada
About
We are building a local-first vessel management platform for a motor yacht. The system combines:
PostgreSQL (schema designed in ER/Studio)
Python backend (API + data layer)
Home Assistant integration (voice + automations)
Mobile/web UI (later phase)
This is not a typical website or e-commerce project.
We need a strong backend engineer who can architect and implement a clean, reliable service layer that integrates with IoT systems.
Current Architecture
PostgreSQL database (DDL exported from ER/Studio – source of truth)
Python service layer (FastAPI preferred)
Local deployment (Docker on LAN hardware)
Home Assistant for voice input, automation, and device orchestration
REST endpoints for maintenance logs, queries, inventory, etc.
Responsibilities
Design and implement a clean Python backend architecture
Implement database migrations (Alembic or equivalent)
Build REST API endpoints for:
Maintenance logging
Querying next service intervals
Inventory/spares lookup
Integrate backend with Home Assistant (webhooks / REST services)
Ensure transactional integrity and idempotency
Implement logging, error handling, and backup strategy
Provide clean documentation
Required Skills
5+ years professional backend development
Strong Python (FastAPI, SQLAlchemy, or similar)
PostgreSQL schema design & performance optimization
Database migrations (Alembic or similar)
Docker deployment
REST API design
Experience with IoT systems or Home Assistant preferred
Nice to Have
Experience with local LLM integrations
Experience with MQTT
Knowledge of offline-first or edge deployments
Experience working with hardware integrations
What This Is NOT
Not a Shopify / WordPress / e-commerce build
Not a frontend-only role
Not a "quick script" project
Engagement Model
Start with a small paid technical spike:
Stand up Postgres via Docker
Apply provided DDL
Implement two API endpoints
Provide structured logging + README
If successful, this becomes a long-term engagement
To Apply
Please include:
A GitHub repo or code sample of a backend system you built.
Brief description of a database-backed API you designed.
Your experience with PostgreSQL migrations.
Your time zone and weekly availability.
Contract duration of 3 to 6 months. with 30 hours per week.
Mandatory skills: Python, PostgreSQL, Docker, RESTful Architecture, API, Software Architecture & Design, API Integration
Languages
- English
Notice for Users
This job was posted by one of our partners. You can view the original job source here.