Excel Macro Developer

20 hours ago

Kolhapur Mumbai Pune, India Simdaa Technologies Full time ₹ 5,00,000 - ₹ 15,00,000 per year

Job Summary

We are seeking a detail-oriented and technically proficient Excel Macro Developer to automate data workflows using VBA (Visual Basic for Applications). The role involves integrating multiple Excel files, performing complex calculations to derive key performance indicators (KPIs), and generating structured datasets for dashboard creation. The ideal candidate will have a strong grasp of Excel automation, data transformation, and visualization principles.

Key Responsibilities

  • Develop and maintain Excel Macros using VBA to automate repetitive tasks and streamline data processing.
  • Design scripts to join and merge data from multiple Excel workbooks/sheets.
  • Implement logic to calculate KPIs and metrics based on business rules and formulas.
  • Generate clean, structured result datasets suitable for dashboard consumption.
  • Collaborate with stakeholders to understand reporting requirements and translate them into automated solutions.
  • Build dynamic, user-friendly dashboards within Excel using pivot tables, charts, slicers, and conditional formatting.
  • Ensure error handling, logging, and performance optimization in macro scripts.
  • Document macro logic, usage instructions, and maintenance guidelines.

Required Skills & Qualifications

  • Proven experience in Excel VBA / Macro development.
  • Strong understanding of Excel functions, formulas, and data manipulation techniques.
  • Experience in joining datasets using lookup functions, scripting, or Power Query.
  • Ability to design and calculate KPIs from raw data.
  • Familiarity with dashboarding techniques in Excel (pivot tables, charts, slicers).
  • Attention to detail and commitment to clean, scalable code.
  • Good communication skills to interact with business users and gather requirements.

Preferred Qualifications

  • 2 years Experience with Excel Power Query or Power Pivot.
  • Worked on at least 3 Major Excel Automation Projects with Similar Capacity
  • Exposure to integrating Excel with external data sources is added advantage (e.g., SQL Server, SharePoint).
  • Exposure to Power BI development is added advantage
  • Knowledge of version control and macro security best practices.
  • Understanding of business operations and performance metrics.

  • Excel Macros

    2 weeks ago

    Pune, India Jade Global Full time

    ID: 5257 | 5 - 8 yrs | Pune | careers - 4-5 years of experience in Excel Macros (Visual Basic) - Must Have skills: - Hands on experience in creating new or modifying existing Excel Macros - Hands on SQL queries - Able to connect to DB from Excel and populate Excel table based on business rules/conditions - Should be able to train and mentor juniors -...

  • VBA-Excel Macro

    4 days ago

    Mumbai, Maharashtra, India Basiz Fund Service Pvt Ltd. Full time ₹ 30,000 - ₹ 10,00,000 per year

    The preferred candidate must have experience in coding VBA macros in Excel, especially in accounting and finance. Previous experience of 2 to 3 years is preferred.A lively, engaging work atmosphere in an iconic environment is assured.Job Type: Full-timePay: ₹300, ₹1,000,000.00 per yearBenefits:Health insuranceLeave encashmentPaid sick timePaid time...

  • Executive - Automation (VBA Macro Developer/ Excel)

    2 weeks ago

    Pune, Maharashtra, India Capita Full time ₹ 6,00,000 - ₹ 12,00,000 per year

    Greetings from CapitaWe are hiring for Executive - Automation (Excel and VBA)Education: Any GraduateExperience Required: Minimum 1 year of experience in VBASkillsets and Knowledge:Should have good VBA knowledge.Good hands on experience to develop Macros, coding and debuggingGood Communication SkillShould be ok for Invoice Processing and BillingKindly share...

  • Vba Macro

    1 week ago

    Pune, India Quess IT Staffing Full time

    **About Us** “Magna Infotech, now Quess IT Staffing, is India’s largest IT staffing company with over 20 years of experience in staffing IT professionals in 300+ companies across levels and skillsets. Our 10,000+ associates deployed in 80+ cities and towns are proficient in over 500 technological skills. Our associates help enable cutting edge solutions...

  • Excel - Expert (Saturday & Sunday Only)

    2 weeks ago

    Mumbai, India Gem Excel Full time

    We need an expert in EXCEL basic knowledge of macros and VBA is an advantage We need you to work ONLY on Saturday & Sunday 6 - 8 hours **Job Type**: Freelance **Salary**: ₹5,000.00 - ₹10,000.00 per month Schedule: - Weekend availability Ability to commute/relocate: - Mumbai, Maharashtra: Reliably commute or planning to relocate before starting...

  • Mis Executive-macros

    2 weeks ago

    Mumbai, India Solitaire Overseas Full time

    URGENT OPENING: - SkillSet: Mis analyst, mis lead, macros, VBA, Data analaysis. MIS Analyst With MIS Skillset with Macros and VBA Proficiency in MS Excel, MS Access and other MS Office components. Excellent knowledge on automation (Scripting and Macros) Exp - min 1-2 yrs Salary -25K-30K Location - Grant Road(Lamington Road) **Salary**: ₹25,000.00 -...

  • Mis Executive

    2 weeks ago

    Mumbai, India RiverForest Connections Private Limited Full time

    **Roles and Responsibilities** Immediate hiring for a leading MNC company Designation - Finance MIS Executive Job location - Mumbai, Andheri East Experience - 3 to 4 Years Expert in MS advanced excel with Macros Good communication skills Budget - 4 to 5 LPA 5 days of working Day shift Hybrid Work from Office / Home If interested, contact me at the...

  • Faculty for Adv. Excel and Vba Macros

    20 hours ago

    Mumbai, Maharashtra, India CMIT Computer Education Full time

    **CMIT Computer Education**, Bhandup Branch, require **Faculties** for teaching **Adv. Excel and VBA Macros** on Visiting Basis, Freelancing, Part Time, Weekend Basic. **9821160670 / 9867312123** **CMIT Computer Education** **B-78, Ground Floor,** **Station Plaza, Station Road,** **Near Bhandup West Railway Station,** **Bhandup (West),** **Mumbai -...

  • Zoho CRM

    20 hours ago

    Bavdhan, Pune, Maharashtra, India Fore Excel Private Limited Full time

    We are seeking a highly skilled and detail-oriented individual with hands-on experience in - **Zoho CRM and advanced Excel.** Key Responsibilities: - Daily management and maintenance of Zoho CRM platform. - Monitor, clean, and update sales data to ensure accuracy and timeliness. - Create dashboards, reports, and automation workflows within Zoho CRM. -...

  • Metrology Process Analyst And Macro Developer

    1 week ago

    Pune, India Whatjobs IN C2 Full time

    You are curious, resourceful, and known for being a team player? That’s great, because these are the qualities we’re looking for in our next colleague! PolyWorks India is looking for a Metrology Process Analyst and Macro Developer who will be responsible for analyzing our clients’ manufacturing processes and optimizing them by customizing our...