Analyst - Accounts Payable & VBA Developer

🔹 Job Summary

We are looking for a detail-oriented Accounts Payable (AP) Analyst with VBA skills to support invoice processing and drive efficiency through automation. The role involves handling AP operations alongside developing solutions using Excel VBA to improve operational excellence.

🔹 Key Responsibilities

✅ Accounts Payable Operations

• Capture and verify details from scanned invoices accurately and within defined timelines
• Process PO / Non-PO invoices with correct accounting and approval checks
• Work efficiently on SAP or ERP systems for invoice posting and validation
• Ensure adherence to SLA, TAT, and quality metrics (accuracy & productivity)
• Handle all vendor queries and invoice discrepancies end-to-end.
• Perform repetitive AP tasks with high accuracy and consistency
• Maintain proper documentation and support audit requirements

✅ VBA / Automation Responsibilities

• Develop, test and maintain Excel VBA macros to automate repetitive tasks, activities, reports with the use of Excel, Access, and other MS Office Tools.
• Create trackers, dashboards, and reports for AP operations
• Identify opportunities to improve process efficiency through automation / Macros.
• Support troubleshooting and enhancement of existing VBA tools/macros.
• Document automation processes and support end-users
• Support standardization and process optimization.
• Analyzing operational opportunities and recommend process improvements.
• Provide training and support to end-users on VBA-based tools and applications.
• Stay updated on the latest VBA and MS Office trends and best practices.

🔹 Required Skills

• Basic understanding of Accounts Payable / P2P process.  
• Strong requirement gathering expertise of developing VBA Macros. Collaborate with business users to gather requirements and translate them into technical solutions.
• Knowledge of: Invoice processing, basics of vendor management and accounting fundamentals.
• Working knowledge of MS Excel (formulas, pivot tables), MS Office Tools & VBA Macro.
• Exposure to SAP or ERP systems (Preferred SAP)
• Familiarity with other programming or scripting languages (e.g., SQL, Python, Power Query, Power BI, or Microsoft Power Automate) is a bonus.

 Qualifications

• Bachelor’s / Post Graduate degree in Commerce, Finance, or related field
• VBA Certification / Proven experience in VBA programming and automation. (Included Experience with MS Access VBA development)
• Familiarity with other programming or RPA or scripting languages (e.g., SQL, Python) is a bonus.
• Experience in financial modeling, data analysis, or process automation projects.
• Strong expertise in Excel VBA, including advanced formulas, pivot tables, and charting and Knowledge of other automation tools like Power Query, Power BI, or Microsoft Power Automate.
• Exposure to VBA / automation projects (academic & practical) & Ability to write clean, efficient, and well-documented code.
• Good communication skills to work with cross-functional teams and business users.