Senior Analyst, VBA Automation (12 months Contract, India Based)

About the role

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.

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, and 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, and 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, and 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 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 technical 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.
• Experience developing automation solutions in Finance operations environments is preferred.
• Python-based automation, Tableau/Power BI, and ERP scripting experience are not a must but good to have.
• Behavioral Attributes
• Strong structured problem-solving skills with the ability to diagnose issues logically and design practical technical solutions.
• Well organized with 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.
• Strong documentation discipline and a high standard for supportability, clarity, and technical quality.
• Self-starter with a hands-on engineering mindset and the ability to independently manage technical deliverables in a fast-paced environment.
• Adaptable, dependable, and comfortable balancing delivery speed with control

Additional Information

About Agoda At Agoda, we bridge the world through travel. Our story began in 2005, when two lifelong friends and entrepreneurs, driven by their passion for travel, launched Agoda to make it easier for everyone to explore the world. Today, we are part of Booking Holdings [NASDAQ: BKNG], with a diverse team of over 7,000 people from 90 countries, working together in offices around the globe. Every day, we connect people to destinations and experiences, with our great deals across our millions of hotels and holiday properties, flights, and experiences worldwide. No two days are the same at Agoda. Data and technology are at the heart of our culture, fueling our curiosity and innovation. If you're ready to begin your best journey and help build travel for the world, join us.

Your Match

How well this role fits your profile.

Company Intel

What employees say

Worked at agoda? Share your experience