VBA Developer - IT Automation

About the Role :

We are looking for a skilled Excel VBA Developer to design and develop a robust Excel-based prototype for financial planning and simulation. The role involves close collaboration with business stakeholders to translate complex financial requirements into automated, user-friendly Excel models. You will leverage your VBA expertise to build scalable, efficient, and interactive tools that support financial analysis and decision-making.

Key Responsibilities :

• Design, develop, and maintain a comprehensive Excel-based financial planning prototype incorporating complex financial logic, simulations, and scenario analysis.
• Develop and automate workflows using VBA macros, including UI components such as forms, buttons, and custom menus to enhance user interaction.
• Collaborate with finance and business stakeholders to gather detailed functional and technical requirements.
• Translate business needs into scalable Excel models with a focus on accuracy, usability, and maintainability.
• Implement advanced Excel features such as dynamic dashboards, pivot tables, Power Query integration, and data visualization to enhance reporting capabilities.
• Ensure the prototype allows for iterative development and rapid adjustments based on feedback.
• Optimize VBA code for performance improvements and error handling.
• Document the design, logic, and code for future reference and ease of maintenance.
• Provide training and support to end-users to ensure effective use of the financial planning tools.
• Work independently and manage time effectively to meet project deadlines.

Required Skills and Qualifications :

(ref : hirist.tech)