What Is an Excel VBA Developer and How to Become One

By ZipRecruiter Marketplace Research Team

An Excel VBA Developer works with the Microsoft event-driven macro programming language, Visual Basic for Applications. You create user-defined functions and automation processes by using code to build a script based on your company’s needs. Your duties include presetting the software with user preferences and performing routine analysis, including data mapping and updating the database. Other responsibilities include working with trading desk personnel to develop processes to enhance workflow efficiency. You handle any of the company’s ad hoc requests to generate data files. You also maintain existing scripts and processes.

You must have several qualifications to be an Excel VBA Developer. Regarding education, you need a bachelor’s degree in engineering, computer sciences, MIS, or another related field. You need excellent technological skills, including strong C# and Python skills. You should also be proficient with Excel and VBA. You need good MS SQL or Sybase SQL skills as well. Employers typically seek Excel VBA developers who have professional experience and have previously conducted full cycle development, from analysis to development to testing and deployment. It is a plus if you have experience with BCS, BFin, or another related discipline.