Python Developer

Job Description

Job Title: Junior Python Developer

Location: Washington, DC 20433 (Hybrid-4 days per week onsite from Day 1)

Job Type: Contract (8 Months – Long-Term)

Experience Required: 2-4 Years

About the Role

We are seeking a Junior Python Developer with 3–5 years of professional experience for a contract opportunity in Washington, DC. The ideal candidate will support the modernization of legacy systems by analyzing existing Excel-based calculations, formulas, macros, and business logic and converting them into reliable, efficient Python code.

This role is best suited for an early-career Python developer with hands-on experience in backend development, data manipulation, code conversion, and testing. Candidates should be comfortable working with existing spreadsheet models, validating results, troubleshooting discrepancies, and documenting their work.

Primary Responsibilities

1. Excel Analysis and Requirement Understanding

• Analyze existing Excel spreadsheets, including complex formulas, macros, calculations, and data flows.
• Understand and document business logic embedded in spreadsheet models.
• Collaborate with team members and stakeholders to clarify requirements and resolve ambiguities.

2. Python Development and Code Conversion

• Translate Excel-based calculations and business logic into clean, maintainable Python code.
• Develop Python scripts for data processing, calculations, and backend functionality.
• Implement appropriate error handling, input validation, and basic performance optimization.

3. Testing and Validation

• Develop and execute test cases to validate Python scripts and calculations.
• Compare Python outputs against the original Excel results to ensure accuracy and consistency.
• Identify, troubleshoot, and resolve discrepancies between existing and converted calculations.

4. Documentation and Coding Standards

• Document existing Excel logic and newly developed Python scripts.
• Maintain clear technical documentation, inline comments, and basic user instructions.
• Follow coding standards, version control practices, and maintain an organized code repository.

Required Skills and Qualifications

• 3–5 years of professional Python development experience.
• Strong fundamentals in Python programming, data manipulation, and backend development.
• Hands-on experience with Excel formulas, complex calculations, macros, or spreadsheet-based business logic.
• Ability to translate spreadsheet calculations into Python code.
• Experience with testing, debugging, data validation, and error handling.
• Familiarity with version control tools such as Git.
• Strong analytical, problem-solving, documentation, and communication skills.

Candidate Eligibility Criteria

• Experience level: Junior candidates with 3-5 years of relevant experience only.
• Technical focus: Python development, Excel-to-Python conversion, data processing, and testing.
• Seniority restriction: Senior developers and candidates exceeding the specified experience range will not be reviewed.
• Location: Must be able to meet the position's onsite requirements in Washington, DC 20433.

Please apply only if your experience aligns with the specified junior-level requirements.

“Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of – Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans. ”