Experience
5 - 10 yrs
Job Location
Mumbai, India
Vacancy
1
Designation
Senior Data Analyst
Job Type
ONSITE
Job Description
The Opportunity
Are you passionate about engineering automation solutions that improve efficiency, accuracy, and control at scaleDo you thrive in a fast-paced, data-driven environmentAgoda'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, 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 and quality.
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, VBA/Excel-based engineering, or related technical development roles.
- Experience in developing automations for Finance operations is preferred.
- 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.
#India
Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.No Referrers Available
There are currently no referrers available for this job. You can still apply, will let you know once there is any referrer available.