Senior Analyst, VBA Automation (12 months Contract, India Based) : Contract extension possible based on performance

*Contract extension possible based on performance, with additional benefits including a performance bonus and medical insurance*

The Opportunity:

Are you passionate about engineering automation solutions that improve efficiency, accuracy, and control at scale? Do you thrive in a fast-paced, data-driven environment? Agoda’s Finance Operations Excellence is seeking a VBA Automation Specialist to serve as a hands-on technical expert focused on designing, developing, and maintaining automation solutions for finance operations. You will play a key role in building robust tools and workflow automations, modernizing manual processes, and enabling a more scalable and controlled operating model across Finance.

Key Responsibilities:

Automation Architecture & Development:

• Design, develop, test, deploy, and maintain automation solutions using Advanced Excel, Macro/VBA, MS Access, SQL, Power Automate, FloQast, and Power Apps.
• Build reliable, scalable, and well-structured solutions with a strong focus on maintainability, performance, control, and user usability.

Finance Operations Solution Engineering:

• Partner with Finance operations teams to understand process requirements, identify technical solution options
• Engineer automations for high-volume and control-sensitive workflows across areas such as reconciliations, reporting, validation, close activities, and operational tracking.

Data Processing & Logic Design:

• Develop data models, query logic, input/output structures, and exception-handling routines using Excel, Access, and SQL.
• Optimize existing tools by improving logic design, reducing processing time, strengthening validation layers, and enhancing auditability.

Workflow Automation & Systems Enablement:

• Build and enhance workflow-based solutions using Power Automate, FloQast, and Power Apps to reduce manual handoffs, improve process standardization,
• Support stronger controls and transparency across finance operations.

Technical Documentation & Change Control:

Create and maintain high-quality technical documentation including solution design notes, process logic, code commenting, SOPs, testing evidence, version histories, and user guidance to ensure sustainable ownership and supportability.

Issue Resolution & Continuous Improvement:

• Troubleshoot defects, resolve production issues, support enhancement requests
• Proactively identify opportunities to refactor or upgrade existing automations.
• Contribute to improving development standards, documentation quality, and reusability of automation components.

What You’ll Need to Succeed:

Technical & Functional Skills

• Advanced p