Senior Excel VBA Developer (Contract-To-Hire)

Orcapod Consulting Services; Hyderabad, Pune District; Hybrid; INR 1,200,000 - 1,800,000; Full time

Job summary

Orcapod Consulting Services is seeking a Senior Excel VBA Developer to design, develop, and maintain large macro-enabled Excel applications. The role focuses on automating processes, building robust data models, and delivering production-ready solutions for Pune and Hyderabad clients.

The ideal candidate has 5+ years of VBA experience, strong Excel object model expertise, and familiarity with UserForms. Japanese bilingual proficiency is a strong plus for stakeholder communications.

Qualifications

• 5+ years of hands-on VBA development for large, production-grade Excel applications.
• Strong VBA expertise including modules, classes, collections, dictionaries, error handling, and conditional compilation.
• Experience developing UserForms/MSForms with event-driven logic and validation.
• Advanced knowledge of the Excel Object Model (Workbook, Worksheet, Range, FileDialog, printing, and calculation management).
• Ability to optimize workbook performance using efficient calculation, event, and data-processing techniques.
• Advanced Excel skills including formulas, lookups, conditional formatting, data validation, and named ranges.

Responsibilities

• Develop, enhance, and maintain VBA code across large, macro-enabled Excel workbooks.
• Implement product launches, product variants, and repricing updates for multiple distribution channels.
• Troubleshoot and resolve production issues related to calculations, validations, and reporting outputs.
• Standardize Excel design templates and improve solution maintainability.
• Perform impact analysis, maintain technical documentation, and ensure traceability to work items.
• Execute regression testing and support User Acceptance Testing (UAT) with business stakeholders.
• Support release management activities and version control processes.
• Contribute to modernization initiatives and evaluation of migration paths from VBA-based solutions to modern platforms.

Skills

VBA development

Excel automation

UserForms/MSForms

Excel Object Model

Performance optimization

Formulas & Lookups

Tools

Git

Job description

Senior Excel VBA Developer

NP Immediate

• Pune & Hyderabad only
• Japanese bilingual resources will be first priority.

Responsibilities**

• Develop, enhance, and maintain VBA code across large, macro-enabled Excel workbooks.
• Implement product launches, product variants, and repricing updates for multiple distribution channels.
• Troubleshoot and resolve production issues related to calculations, validations, and reporting outputs.
• Standardize Excel design templates and improve solution maintainability.
• Perform impact analysis, maintain technical documentation, and ensure traceability to work items.
• Execute regression testing and support User Acceptance Testing (UAT) with business stakeholders.
• Support release management activities and version control processes.
• Contribute to modernization initiatives and evaluation of migration paths from VBA-based solutions to modern platforms.

**Required Skills**

**Core VBA / Excel**

• 5+ years of hands-on VBA development for large, production-grade Excel applications.
• Strong VBA expertise including modules, classes, collections, dictionaries, error handling, and conditional compilation.
• Experience developing UserForms/MSForms with event-driven logic and validation.
• Advanced knowledge of the Excel Object Model (Workbook, Worksheet, Range, FileDialog, printing, and calculation management).
• Ability to optimize workbook performance using efficient calculation, event, and data-processing techniques.
• Advanced Excel skills including formulas, lookups, conditional formatting, data validation, and named ranges.

**Preferred Skills**

• Experience in insurance/financial services.
• Japanese language proficiency (reading and understanding technical specifications, business documents, and stakeholder communications) is a strong plus.
• Familiarity with Git-based source control and release management.