VBA Automation Specialist to design, build, and maintain high‑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‑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
Bachelor’s degree with over 10 years of
experience in developing macros, automation usecases
Excel VBA (UserForms, Class Modules, Add‑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‑to‑end
delivery ownership.
Experience with managing end-to-end execution of programs that span




across multiple teams and time zones.
Detailed oriented, solid analytical skills, and agility to
multi-task in a quick-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‑case handling,
and explicit documentation of data flows.
Reverse‑engineer, 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‑functional teams
(Ops/Finance/Supply Chain/IT) and participate in ticketing/Agile routines.

📌 Vba Automation Developer Bengaluru
🏢 Important Company of the Sector
📍 Bengaluru