Our client located in the Dunwoody/Perimeter area is looking for an Business Systems Specialist - VBA Expert to join their growing organization

Direct-Hire, Permanent Position

Location: Dunwoody, GA

They are working a hybrid schedule 3 days in office/2 days WFH after the training period

Salary: $65-75K

MUST LIVE IN THE ATLANTA AREA, as they are looking to hire ASAP

Summary:

Analyze computer systems and provide solutions in conjunction with IT with minimum or zero supervision. In alignment with Management, formulate application system solutions to resolve issues and improve productivity/efficiencies in the Region. Work with subject matter experts to build the required automation such as macros, robotic process automation (Blue Prism), Power

Automate, and other tools to streamline processes and improve efficiency. This can range from

ad-hoc one-time use solutions to full-blown process automation.

Responsibilities

• In alignment with management will work with the Areas, other regions, global teams, and IT and lead the creation of automation solutions that will answer the needs of the business and result in financial and manpower savings.
• The specialist will lead in the design, development, documentation, analysis, creation, testing, and maintenance of automation programs and roll out the automation of automated tasks/processes with minimum supervision.
• In charge of the creation and maintenance of high-value macros using MS Office/Excel
• In charge of the creation and maintenance of RPA, Power Automate, and other tools.
• During the manager's absence, supervise employees within the Business Systems team.
• Experience with Data Transformation, EG. Take a report and transform it into Excel for analysis.
• Liaise with Area and Regional offices to obtain factual process improvements/ requirements
• Document/create SOPs, user instructions and manuals
• Provide staff with guidance in handling difficult or complex problems and in resolving complex, escalated complaints, or disputes.
• Manage support tickets via JIRA for all systems related to Automation.
• Point of contact for Area users when regional and global changes occur within the Automation team’s responsibility.
• Update and test improvements of company software.
• Update all area users within company systems.
• Ensure consistent application of company policies to all personnel actions

Qualifications

• Bachelor’s Degree with a minimum of 3 years of Business Systems experience, or the equivalent combination of education and experience. Maritime experience preferred.
• Excellent communication and organizational skills.
• Expert in VBA with emphasis on Excel, Outlook, and Access-based macros
• Knowledge of Automation, Python, and Power Tools tools will be an added advantage
• Ability to work and collaborate with various teams to identify business needs and create appropriate plans to achieve the defined project goals.
• Understand interfaces between layers of software, software modules, and the process they reflect and apply that understanding in the development, testing and/or support of applications and systems in general.
• Ability to train users on new systems or enhancements to existing.
• Proficient in MS Office (e.g., MS Teams, Excel, PowerPoint, etc.) and other software appropriate to work demands.