VBA Automation Developer

• 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.