Python Developer for Financial Automation
Бюджет: $15.0 - $30.0
HOURLY / PART_TIME
⭐ 0.00 (0)
United States
python, automation, api-integration, pandas
We're a Brazilian B2B healthtech (laboratory services for hemodialysis clinics) looking for a part-time Python developer to build and maintain financial automation tools.
What you'll build:
1. Billing automation: scripts that read lab production data (CSV exports), cross-reference with contract pricing tables, and generate formatted Excel billing reports (openpyxl) for different clients, each with specific templates
2. Invoice integration: connect with our electronic invoice system (Focus NF API) and banking platform (BTG Pactual / CNAB format) to automate invoice issuance and bank slip generation
3. Email monitoring workflows: set up n8n or Make.com to detect incoming purchase orders from clients, extract key data (PO numbers, amounts), and update tracking spreadsheets automatically
4. Accounts receivable dashboard: build a live dashboard (Google Sheets API or Streamlit) showing aging reports, collection status, and cash flow projections
5. Bank reconciliation: parse OFX/CSV bank statements and auto-match payments with issued invoices
6. AI-powered collection emails: integrate with Claude/GPT APIs to generate personalized collection emails based on invoice status and payment history
Requirements:
- Python 3+ years (strong fundamentals, clean code)
- openpyxl and/or pandas for Excel manipulation
- REST API experience (consuming and building)
- Google Sheets API or similar
- Native Portuguese speaker (all business context is in Brazilian Portuguese)
Nice to have:
- Experience with NFS-e (Brazilian electronic service invoices) or CNAB banking files
- n8n, Make.com, or Zapier
- Anthropic/OpenAI API integration
- Understanding of billing/invoicing/AR processes
- smtplib / email automation
Project details:
- 20-30 hours/month, ongoing
- Fully remote
- Start: immediate
- Communication in Portuguese
- We use Claude AI heavily in our workflow, so comfort with AI-assisted development is a plus
To apply, please:
1. Share 1-2 relevant past projects (financial automation, Excel generation, or API integrations)
2. Briefly describe your experience with openpyxl or pandas
3. Your hourly rate and weekly availability
Відкрити на Upwork