Python Developer for Financial Automation

Posted 5 days 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:2 days ago
  • Interviewing:
    4
  • Invites sent:
    19
  • Unanswered invites:
    8
About the client
Member since Nov 8, 2021
  • United States
    New York12:19 PM
  • $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
Install and Integrate UTM Grabber PluginFixed-price‐ Posted 3 weeks ago
WordPress

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