Python Developer (Business Automation)

Job Overview: We are seeking a highly skilled and motivated Python Developer specializing in business automation. The ideal candidate will have extensive experience in Python programming and a proven track record of developing automated solutions to streamline business processes. Initially, you will work under the direction of the US-based development lead. Once you are ramped up, you will be expected to take full ownership of all scripts and automation programs related to our Marketplace Expansion Program (MEP) division, which is a key revenue-generating center for our business. This includes responsibility for maintenance, updates, troubleshooting, and ensuring the solutions align with strategic business goals. You will work closely with non-technical stakeholders to translate their requirements into functional, efficient, and scalable solutions, with minimal support from the development lead. We use modern Python (version 3.12) to build robust, maintainable, and high-performance solutions.

Key Responsibilities:

• Design and implement automation scripts and tools using Python to process Excel, CSV, and text files.
• Integrate and interact with external REST APIs, GraphQL APIs, and FTP servers to facilitate seamless data exchange.
• Develop REST APIs from scratch using FastAPI to support internal and external workflows.
• Handle deployment and maintenance of automation scripts to remote Linux servers.
• Create, manage, and optimize database schemas and write efficient SQL queries to support business needs.
• Utilize Python libraries such as Pandas, SQLAlchemy, Alembic, FastAPI, Pydantic, and asyncio to deliver robust and scalable solutions.
• Collaborate with stakeholders to gather requirements and deliver complete business automation solutions.

Required Skills and Qualifications:

• Python Expertise: Strong experience in Python programming, particularly for automation tasks.
• Modern Python: Familiarity with Python 3.12 and its advanced features.
• Task Automation: Proficiency in automating processes involving Excel, CSV, and text file manipulation.
• API Integration: Extensive experience with external REST APIs, GraphQL APIs, and FTP server interactions.
• Python Libraries: In-depth knowledge of Pandas, SQLAlchemy, Alembic, FastAPI, Pydantic, and asyncio.
• Debugging and Testing: Experience with using a debugger (not print statements) to pinpoint issues in code. You should also know how to write tests to validate code correctness.
• REST API Development: Ability to design and implement REST APIs from scratch using FastAPI.
• Database Skills: Experience with relational databases, including designing schemas and writing optimized SQL queries.
• Dependency Management: Expertise in Python dependency management, preferably with Poetry.
• Linux Skills: Proficiency with Linux command line and basic system administration tasks. The ideal candidate should be able to independently work on a remote Ubuntu server, including cloning Git repositories, setting up SSH keys, configuring and running scripts, and creating cron jobs for automation, without requiring additional guidance.
• Git Expertise: Expertise using Git from the command line, including experience with code reviews, pull requests, and collaboration via platforms such as GitHub or GitLab.
• English Proficiency: Must be able to read, write, and speak English proficiently

Preferred Skills:

• Experience with NoSQL databases such as MongoDB.
• Experience with writing generative AI prompts and OpenAI API.
• Experience with Beautiful Soup for HTML parsing / web scraping.
• Proficiency with Google Sheets, Microsoft Excel, and/or LibreOffice Calc
• Familiarity and/or ability to learn Java and Golang to maintain existing projects in those languages.

Computer/Technology Requirements:

• You must supply and work from your own computer with Windows 10 or 11, or macOS 13+, or a virtual machine running one of these operating systems.
• You must supply your own internet connection with sufficient bandwidth for video calls.
• You will use or create your own email address for work-related emails.
• You will supply your own smart phone with a valid phone number for communication via WhatsApp, as well as 2FA via Google/Apple Authenticator or similar.
• You must install ActivTrak software on your computer during onboarding. Using a virtual machine for work and installation of ActivTrak is acceptable. If working from macOS, we will supply a license key for Parallels Desktop to run a virtual machine upon request.
• System must be able to run the latest versions of the following softwares: Visual Studio Code, Google Chrome, Postman or Insomnia, DBeaver, FileZilla, LibreOffice Calc.
• System must be capable of connecting via SSH tunnel through the shell (Bash, Zsh, or Powershell) and Visual Studio Code Remote Explorer to a remote Ubuntu server for development.

Working Hours:

• We are based in the Eastern United States. As such, you are required to be available between the hours of 8:00AM through 4:00PM EST/EDT
• Standard working days are Monday through Friday
• November through February: 6:30PM through 2:30AM IST
• March through October: 7:30PM through 3:30AM IST

Personal Attributes:

• Strong problem-solving skills and attention to detail.
• Excellent communication and ability to collaborate with non-technical stakeholders.
• Self-starter with the ability to manage multiple tasks and priorities in a fast-paced environment.

What We Offer:

• Top pay and advancement opportunities for the right, high performing individual!
• Convenience of remote work
• Opportunities for personal and professional growth.
• Join our team and be part of a dynamic agency where your skills and expertise will make a real impact on our clients' success!