Job Description

Job Information

Date Opened


08/29/2025
Job Type


Full time
Industry


Technology
State/Province


Karnataka
Zip/Postal Code


560001
City


Bangalore
Country


India

About Us

At Innover, we endeavor to see our clients become connected, insight-driven businesses. Our integrated Digital Experiences, Data & Insights and Digital Operations studios help clients embrace digital transformation and drive unique outstanding experiences that apply to the entire customer lifecycle. Our connected studios work in tandem to reimagine the convergence of innovation, technology, people, and business agility to deliver impressive returns on investments. We help organizations capitalize on current trends and game-changing technologies molding them into future-ready enterprises.



Take a look at how each of our studios represents deep pockets of expertise and delivers on the promise of data-driven, connected enterprises.

Experience Required

10 Years +

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, 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?case handling, and clear 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.