Python Developer for Financial Automation

Posted 2 weeks ago

Worldwide

Summary

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

  • Less than 30 hrs/week
    Hourly
  • 6+ months
    Duration
  • Intermediate
    Experience Level
  • $15.00

    -

    $30.00

    Hourly
  • Remote Job
  • Complex project
    Project Type
Skills and Expertise
Mandatory skills
Python
Google Sheets Automation
Activity on this job
  • Proposals:10 to 15
  • Last viewed by client:yesterday
  • Interviewing:
    4
  • Invites sent:
    19
  • Unanswered invites:
    7
About the client
Member since Nov 8, 2021
  • United States
    New York5:32 AM
  • $491 total spent
    1 hire, 1 active
  • 8 hours

Explore similar jobs on Upwork

Job Aggregation and Dashboard CreationHourly‐ Posted 8 months ago
Automation
Data Scraping
Data Extraction
API
UI/UX Prototyping
Web Scraping
AI UGC Video Generator - n8n WorkflowHourly‐ Posted 7 months ago
Automation
AI Agent Development
CRM Automation
Artificial Intelligence
Business Services
AI Content Creation
Make.com
n8n
OpenAI API
Business Process Automation
Lead Generation
Google Ads
Email Automation
Social Media Marketing Automation
Omnichannel Automation

How it works

  • Post a job icon
    Create your free profile
    Highlight your skills and experience, show your portfolio, and set your ideal pay rate.
  • Talent comes to you icon
    Work the way you want
    Apply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
  • Payment simplified icon
    Get paid securely
    From contract to payment, we help you work safely and get paid securely.
Want to get started? Create a profile

About Upwork

  • Rating is 4.9 out of 5.
    4.9/5
    (Average rating of clients by professionals)
  • G2 2021
    #1 freelance platform
  • 49,000+
    Signed contract every week
  • $2.3B
    Freelancers earned on Upwork in 2020

Find the best freelance jobs

Growing your career is as easy as creating a free profile and finding work like this that fits your skills.

Trusted by

  • Microsoft Logo
  • Airbnb Logo
  • Bissell Logo
  • GoDaddy Logo