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

Overview

Senior Analyst, VBA Automation on a 12-month contract (extension possible based on performance) within Agoda's Finance Operations Excellence team, acting as a hands-on technical expert designing, developing and maintaining automation solutions for finance operations.

What you'll do

• Design, develop, test, deploy and maintain automation solutions using Advanced Excel, Macro/VBA, MS Access, SQL, Power Automate, FloQast and Power Apps.
• Partner with Finance operations teams to understand process requirements, identify technical solution options and engineer automations for high-volume and control-sensitive workflows such as reconciliations, reporting, validation, close activities and operational tracking.
• 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.
• Build and enhance workflow-based solutions using Power Automate, FloQast and Power Apps to reduce manual handoffs, improve process standardization and support stronger controls and transparency.
• Create and maintain technical documentation including solution design notes, process logic, code commenting, SOPs, testing evidence, version histories and user guidance.
• Troubleshoot defects, resolve production issues and support enhancement requests.
• Proactively identify opportunities to refactor or upgrade existing automations and contribute to development standards, documentation quality and reusability of automation components.

What you'll need

• Advanced proficiency in Excel, including complex formulas, structured models, large-volume data handling and spreadsheet-based solution design.
• Strong hands-on expertise in Macro/VBA automation coding, including development of modular, maintainable and well-documented solutions.
• Strong experience with MS Access and SQL for data storage, query development, data transformation and reporting support.
• Hands-on experience in workflow automation tools such as Power Automate, FloQast and Power Apps.
• Strong ability to convert business requirements into structured, reliable and supportable automation solutions.
• Good understanding of process controls, exception handling, validation design and documentation practices in an operations environment.
• Structured problem-solving skills with the ability to diagnose issues logically and design practical technical solutions.
• Strong attention to detail, especially in code structure, testing, versioning and documentation.
• Strong communication skills with the ability to work directly with Finance operations end-users to gather requirements, explain solutions and support adoption.
• Self-starter with a hands-on engineering mindset who can independently manage technical deliverables in a fast-paced environment.
• Adaptable, dependable and comfortable balancing delivery speed with control and quality.
• Bachelor's degree in a technical field such as Computer Science, Information Systems, Engineering, Data Analytics or a related discipline.
• 5+ years of relevant experience in automation development (VBA and Power Automate are required).

Nice to have

• Experience developing automation solutions in Finance operations environments.
• Python-based automation, Tableau/Power BI and ERP scripting experience.
• SQL, Tableau and Power BI experience.
• Experience in a tech or e-commerce environment.
• Professional certifications or training in automation, analytics, systems development or process improvement.

Details

• Employment type: 12-month contract, India based; contract extension possible based on performance, with a performance bonus and medical insurance.
• Location: Gurgaon / Pune, India.