JOB DESCRIPTION
Python Developer (Sales Automation tooling)
Mission
Own and evolve our existing Python-based Vendor-Specific tools that support quoting, pricing and renewals. Keep them running reliably, adapt to vendor/API changes, and extend them so a single solution works across countries.
Scope of the current codebase (for handover)
- Vendor API client with token management (OAuth endpoints, token file persistence, refresh, error handling).
- GUI apps (CustomTkinter/Tkinter) for SKU extraction and operator workflows, incl. streaming to a local LLM service, SKU table, progress bars, and status messages.
- Pricelist tool: reads/caches Excel (openpyxl/pandas), manages config and auto-updates, resolves Product SKU variants (-EU/-B2B), and prepares outputs for downstream processes.
- Configuration & updates: JSON config with versioning, LLM URL, update paths (SharePoint-synced folder to local), Excel source/target, plus credentials placeholders for Product API.
- Token cache file for API auth (access/refresh/expiry).
Key responsibilities
- Maintenance & reliability
- Keep the Product API client working (auth flows, token refresh, error handling, timeouts/retries).
- Ensure GUI apps run smoothly on Windows (packaging, icons, paths, file permissions).
- Maintain pricelist ingestion (Excel schema changes, caching, performance).
- Adaptation to vendor changes
- Track Product API or data model changes and update request/response handling accordingly.
- Adjust SKU logic for new suffix/category rules.
- Enhancements (if required)
- E.g.: Extend SKU extraction and validation logic; refine LLM integration (connection checks, streaming fallback).
- Transition from the Python solution to the core IT integration
- Midterm: we will integrate the solution into our core IT landscape, and this requires input about the processes inside the solution.
Tech stack (must be comfortable with)
- Python 3.10+; requests, pandas, openpyxl, Tkinter/CustomTkinter, threading, json, pickle.
- REST APIs & OAuth
- Windows environment (paths, file permissions).
Relevant:
- Experience with Excel/PDF/email parsing at scale and performance tuning.
- Familiarity with NAV/Business Central data needs for quoting/renewals (to shape outputs).
- Basic LLM client integration experience (HTTP streaming, resilience).