Assistant Manager

Coforge; Pune District, Greater Noida; On-site; INR 600,000 - 900,000; Full time

Job summary

Coforge is seeking a highly skilled Excel VBA Macro Expert to design and maintain automation solutions within Microsoft Excel. The candidate will develop and optimize VBA macros to streamline tasks and enhance productivity.

With strong proficiency in Excel functions and advanced automation techniques, the ideal applicant will work closely with stakeholders to analyze requirements and provide effective technical solutions.

This is a full-time position located in Pune, Maharashtra.

Qualifications

• Proven hands-on experience in Excel VBA Macro development.
• Strong command over Excel functions, formulas, and Pivot Tables.

Responsibilities

• Design, build, and optimize Excel VBA macros to automate tasks.
• Gather and analyze user requirements to develop technical VBA solutions.

Skills

Excel VBA Macro Development

Excel Functions

Analytical Skills

Problem Solving

Education

Bachelor's degree in Computer Science, IT, Engineering, Finance, or relevant field

Tools

Power BI

SQL

Job description

Job Description

Role Overview:

We are seeking a highly skilled Excel VBA Macro Expert to design, develop, optimize, and maintain automation solutions within Microsoft Excel. The ideal candidate will demonstrate strong proficiency in VBA macro development, advanced Excel functions, and building robust, scalable automation workflows.

Key Responsibilities

VBA Development & Automation (Primary Focus)

• Design, build, and optimize Excel VBA macros to automate manual and repetitive tasks.
• Develop, enhance, and maintain Excel based applications, user forms, and automation tools.
• Write clean, efficient, and well structured VBA code with proper documentation.
• Troubleshoot and debug existing macros to ensure performance and reliability.

Excel Based Data Processing

• Build templates, analytical models, dashboards, and reporting tools using Excel and VBA.
• Ensure data accuracy and integrity across automated solutions.

Stakeholder Collaboration

• Gather and analyze user requirements; translate them into technical VBA solutions.
• Provide end user support, training, and documentation for developed tools.

Optimization & Best Practices

• Evaluate existing Excel processes and recommend improvements and automation opportunities.
• Ensure workbook performance optimization through modular VBA design and efficient coding practices.

Required Qualifications

• Bachelors degree in Computer Science, IT, Engineering, Finance, or relevant field.
• Proven hands on experience in Excel VBA Macro development.

Required Skill Set (Primary Focus on VBA)

Core Skills

• Expert level proficiency in Excel VBA, Macros, and Automation.
• Strong command over Excel functions, formulas, Pivot Tables, charts, and named ranges.
• Ability to create modular, reusable VBA components and automation routines.

Additional Technical Preferences (Nice to Have)

• Exposure to SQL for data connectivity or querying.
• Familiarity with Power Query / Power Pivot / Power BI.
• Experience integrating Excel with other MS Office applications.

Soft Skills

• Strong analytical and problem solving abilities.
• Effective communication and documentation skills.
• Ability to work independently and manage multiple tasks.

Experience Range

• Suitable for 3-5+ years

Job Classification

Industry: BPM / BPOFunctional Area / Department: Quality AssuranceRole Category: Business Process QualityRole: Business Process Quality - OtherEmployement Type: Full time

Contact Details:

Company: CoforgeLocation(s): Pune