Python Developer

Mindlance - Washington, DC

Full-time

Washington, DC

Professional, Scientific, and Technical Services

About the position

The Python Developer will be responsible for converting existing Excel-based calculations into Python code, ensuring accuracy, performance, and scalability. This role involves requirement analysis, code conversion, documentation, testing, and optimization, with a focus on best practices in coding and project management.

Responsibilities

• Review and understand the existing Excel-based calculations.
• Identify the key functionalities and logic implemented in the Excel sheets.
• Collaborate with stakeholders to gather additional requirements and clarify any ambiguities.
• Convert the Excel-based calculations to Python code, ensuring accuracy and consistency.
• Optimize the Python code for performance and scalability.
• Implement error handling and validation to ensure robustness.
• Document the existing Excel-based calculations, including formulas, macros, and data flows.
• Create comprehensive documentation for the Python code, including code comments, user guides, and technical specifications.
• Maintain an organized repository of all project documentation.
• Develop and execute test cases to validate the accuracy and performance of the Python code.
• Compare the results of the Python code with the original Excel calculations to ensure consistency.
• Address any discrepancies and refine the code as needed.
• Identify and implement the most efficient methods for migrating calculations from Excel to Python.
• Follow best practices for coding, documentation, and version control.
• Provide recommendations for further improvements and optimizations.

Requirements

• Proficiency in Python programming language.
• Experience with Excel-based calculations and data analysis.
• Strong understanding of coding best practices and optimization techniques.
• Ability to document code and processes clearly and comprehensively.
• Experience in testing and validating code accuracy and performance.

Nice-to-haves

• Familiarity with version control systems such as Git.
• Experience with data visualization tools.
• Knowledge of software development methodologies.

Benefits

• Equal Opportunity Employer
• Access to artificial intelligence language tools for job enhancement