Overview We need a backend engineer to build the core execution and tracking layer for an internal automation platform. The system must: Track workflow runs and status Maintain immutable audit logs Enforce safe execution transitions Store and retrieve workflow data reliably The goal is a stable, production-grade backend foundation. ⸻ Scope of Work 1. Database schema (Postgres) Create tables for: workflow runs audit logs approvals system flags execution events Include: UUID primary keys timestamps status fields indexes for performance ⸻ 2. Workflow state tracking Implement status lifecycle such as: created validated approved executing completed blocked Prevent invalid transitions. ⸻ 3. Audit logging system Every workflow action must be logged with: timestamp workflow ID event type status Logs must not be editable. ⸻ 4. Internal API layer Create basic endpoints to: create workflow run update workflow status retrieve workflow data log execution events Node.js or TypeScript preferred. ⸻ 5. System control flags Implement global system flags (example: pause execution). ⸻ Stack Postgres Node.js or TypeScript Bonus: Supabase automation platforms workflow engines ⸻ Deliverables Working Postgres schema API endpoints State tracking system Audit logging Clean, documented code. To Apply, Answer 1. Have you built a workflow or job processing system before? 2. What stack did you use? 3. How would you ensure audit logs cannot be altered?