[Hiring] VBA Developer @Georgia IT

Role Description

• Advanced Excel Skills:
  • Proficiency in complex formulas, functions, and data analysis tools in Excel.
  • Ability to work with large datasets and utilize pivot tables for summarizing data.
• VBA Programming:
  • Expert-level knowledge of VBA programming language and its application in Excel.
  • Experience in writing efficient and error-handling VBA code.
  • Experience in designing, developing, and implementing VBA macros and scripts to automate repetitive tasks and processes in Excel.
  • Experience in creating user-friendly interfaces (user forms) for data input, processing, and reporting.
  • Experience in optimizing VBA code for performance and maintainability.
  • Experience in importing and exporting data between Excel and other data sources, such as databases or cubes.
  • Experience in establishing connections to external data sources using VBA and ADO (ActiveX Data Objects).
  • Good at documenting VBA code, macros, and Excel solutions for future reference and knowledge sharing.
• SQL Knowledge:
  • Strong SQL skills beyond basic queries, including the ability to write complex SQL queries and optimize database performance.
• Git Version Control:
  • Familiarity with version control systems like Git for managing code changes and collaborating with other team members.
• Problem-Solving:
  • Ability to identify business problems and devise practical Excel-based solutions.
  • Critical thinking skills to optimize processes and automate tasks.
• Communication:
  • Excellent verbal and written communication skills to collaborate with team members and stakeholders.
  • The capability to explain technical concepts to non-technical personnel.
• Continuous Learning:
  • Willingness to stay updated with the latest Excel features and VBA best practices.
  • Openness to explore and adopt new technologies to improve efficiency.
• Business Understanding:
  • Understanding of business processes and data needs in various industries.
  • Ability to align Excel and VBA solutions with specific business objectives.

Company Description