Analyst - Accounts Payable & VBA Developer

Company Description

Metro Global Solution Center (MGSC) is internal solution partner for METRO, a €29.8 Billion international wholesaler with operations in 31 countries through 661 stores & a team of 93,000 people globally. Metro operates in a further 10 countries with its Food Service Distribution (FSD) business and it is thus active in a total of 34 countries.

MGSC, location wise is present in Pune (India), Düsseldorf (Germany) and Szczecin (Poland). We provide IT & Business operations support to 31 countries, speak 24+ languages and process over 18,000 transactions a day. We are setting tomorrow’s standards for customer focus, digital solutions, and sustainable business models. For over 10 years, we have been providing services and solutions from our two locations in Pune and Szczecin. This has allowed us to gain extensive experience in how we can best serve our internal customers with high quality and passion. We believe that we can add value, drive efficiency, and satisfy our customers.

Website: https://www.metro-gsc.in

Company Size: 600-650

Headquarters: Pune, Maharashtra, India

Type: Privately Held

Inception: 2011

Job Description

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

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.