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

**Company**: Agoda
**Location**: Gurgaon
**Experience**: senior
**Job type**: contract
**Category**: Finance
**Industry**: Technology

**Apply**: https://job-boards.greenhouse.io/agoda/jobs/7906682?utm_source=yubhub.co&utm_medium=jobs_feed&utm_campaign=apply
**Canonical**: https://yubhub.co/jobs/job_f73946ad-fe7

## Description

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.

The Opportunity: We are seeking a VBA Automation Specialist to serve as a hands-on technical expert focused on designing, developing, and maintaining automation solutions for finance operations.

Key Responsibilities:

- 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.

- 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.

- 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.

- Support stronger controls and transparency across finance operations.

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

- 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:

- 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.

Qualifications:

- 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 is required (VBA and Power Automate are required).

- Experience in a tech or e-commerce environment is an advantage.

- Professional certifications or training in automation, analytics, systems development, or process improvement are a plus.

## Skills

### Required
- Excel
- Macro/VBA
- MS Access
- SQL
- Power Automate
- FloQast
- Power Apps

### Nice to have
- Python
- Tableau
- Power BI
- ERP scripting

---

Source: [Apply at job-boards.greenhouse.io](https://job-boards.greenhouse.io/agoda/jobs/7906682?utm_source=yubhub.co&utm_medium=jobs_feed&utm_campaign=apply)