VBA Automation Developer

10 - 15 years

35 - 40 Lacs

Posted:12 hours ago| Platform: Naukri logo

Apply

Work Mode

Work from Office

Job Type

Full Time

Job Description

[{"Remote_Job":false , "Posting_Title":"VBA Automation Developer" , "Is_Locked":false , "City":"Bangalore" , "Experience_Required":"10 Years +" , "Industry":"Technology" , "Job_Description":"

  • VBA Automation Specialist to design, build, and maintain high \u2011 performance Excel/VBA solutions, streamline manual processes, and integrate data from multiple sources (SharePoint, SAP extracts, CSV/SQL, Power BI). The role requires deep expertise in optimizing legacy macros, creating user-friendly tools (UserForms, add \u2011 ins, Advanced concepts like dictionaries), robust error handling, and clear documentation. The ideal candidate can translate ambiguous business requests into reliable technical solutions, collaborate directly with stakeholders, and provide ongoing support and enhancements.
    Qualifications
    • Bachelordegree with over 10 years of experience in developing macros, automation usecases
    • Excel VBA (UserForms, Class Modules, Add \u2011 ins, Arrays/Dictionaries, optimization), Excel Object Model & Power Query, SQL (SELECT/JOIN via ADO/ODBC), SharePoint/OneDrive automation & version control, Power BI (dashboards/DAX/refresh), robust error handling/logging & data validation, requirement gathering & customer interaction, end \u2011 to \u2011 end delivery ownership.
    • Experience with managing end-to-end execution of programs that span across multiple teams and time zones.
    • Detailed oriented, strong analytical skills, and agility to multi-task in a fast-paced environment.
    • Automate manual workflows (data import/merge, cleansing, transformation, reporting) across multiple files and sources.
    • Integrate Excel solutions with SharePoint/OneDrive for file I/O, versioning, and automated distribution/updates.
    • Build and support dashboards/reports (Excel/Power BI) and set up automated refresh processes.
    • Ensure data integrity through validation rules, edge\u2011case handling, and clear documentation of data flows.
    • Reverse\u2011engineer, understand, and refactor existing VBA codebases and Excel dashboards quickly and accurately.
    • Gather and clarify requirements directly from business users; translate ambiguous asks into solid technical solutions.
      Conduct demos, trainings, and handovers; create user guides/SOPs and provide ongoing L2/L3 support.
    • Collaborate with cross\u2011functional teams (Ops/Finance/Supply Chain/IT) and participate in ticketing/Agile routines.

      ","Job_Type":"Full time","Job_Opening_Name":"VBA Automation Developer" , "State":"Karnataka" , "Country":"India" , "Zip_Code":"560001" , "id":"153957000004675432" , "Publish":true , "Date_Opened":"2025-08-29" , "Keep_on_Career_Site":false}]

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now

RecommendedJobs for You