Python Developer – Data Automation

Horizon Tech is seeking a highly analytical and detail-oriented Python Developer – Data Automation to design, develop, and deploy Windows-based automation solutions for complex business processes.The ideal candidate will have strong expertise in Python programming, advanced Microsoft Excel, Power BI/Tableau, and data analysis, with the ability to transform large datasets into automated workflows and user-friendly desktop applications.

The role involves working with large healthcare, financial, and operational datasets to automate repetitive tasks, improve data accuracy, generate reports, and streamline business operations. Each project will be delivered as a standalone Windows application that can be used by non-technical staff.

Key Responsibilities:

• Design and develop Python-based automation solutions for business operations.
• Write clean, efficient, and well-documented Python code.
• Develop Windows desktop executables for end users without requiring Python installation.
• Package applications with desktop shortcuts/icons for easy daily use.
• Automate data cleansing, validation, reconciliation, and transformation.
• Process large Excel, CSV, and other structured datasets.
• Analyze business data and generate actionable insights.
• Build reusable automation tools for recurring operational tasks.
• Develop dashboards and reports using Power BI / Tableau and Microsoft Excel.
• Create configuration files where required to support application flexibility.
• Implement robust error handling and logging mechanisms.
• Prepare sample test files for validation and user acceptance testing.
• Produce comprehensive technical and user documentation for each project.
• Work closely with business stakeholders to understand workflow requirements and translate them into automation solutions.
• Optimize application performance and maintain existing automation tools.

1. Project Workflow: 

The successful candidate will work within the following project lifecycle:

• Review sample datasets provided by stakeholders.
• Understand business logic, workflow, and decision criteria.
• Design and develop the required automation solution.
• Support testing and validation of results.
• Implement revisions based on user feedback.
• Deliver the final Windows application along with all required documentation.

2.    Deliverables for Every Project:

 Each completed project must include:

• Fully documented Python source code.
• Windows executable application (.exe).
• Desktop shortcut/icon for end users.
• User Guide / User Manual.
• Configuration file (where applicable).
• Error logging mechanism.
• Sample test files.
• Technical documentation.

Technical Requirements:

1. Programming:

• Python (Advanced)
• Object-Oriented Programming
• File Processing
• Automation Scripting

2.   Python Libraries:

• Pandas
• NumPy
• OpenPyXL
• Regular Expressions (Regex)
• Logging
• PyInstaller (or similar packaging tools)
• Tkinter, PyQt, or other desktop GUI frameworks (preferred)

3.   Data & Analytics:

• Data cleansing and preprocessing
• Data validation
• Data reconciliation
  
• Business data analysis
• Report automation
• Statistical analysis

4.   Tools / Technologies: 

• Advanced Microsoft Excel
• Power Query
  
• Pivot Tables
• Power Pivot
• XLOOKUP
• INDEX/MATCH
• VBA (preferred)
• Power BI / Tableau (required)

Experience:

• 1.5 to 2 years of professional Python development experience.
• Bachelor's degree in Computer Science, Software Engineering, Information Technology, Data Science, or a related field.
• Experience in data analysis for business intelligence purposes.
• Experience building automation tools for business operations.
• Experience working with large datasets and advanced Excel.
• Experience with healthcare or financial data is highly preferred.

Additional Skills:

• SQL (preferred).
• Version Control (Git).
  
• JSON, CSV, XML processing.
• Windows application deployment.

Other Details

• Job Type: Full-Time
• Location: Onsite
• Working Hours: 9:00 AM – 6:00 PM CST (7:00 PM – 4:00 AM PKT)
• Office Location: Shaheed-e-Millat Road, off Shahrah-e-Faisal, Karachi