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 :

 Qualifications

• Bachelors / 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.

Remote Work :

No

Employment Type :

Full-time