VB Script/Excel Developer in Columbus, OH at APEX Systems

Date Posted: 5/23/2018

Job Snapshot

  • Employee Type:
    Contractor
  • Location:
    Columbus, OH
  • Job Type:
    Other
  • Experience:
    Up to 12 year(s)
  • Date Posted:
    5/23/2018

Job Description

Job #:  851867

Job Title: VBScript/Excel Macro Developer

Location: Columbus, OH

Contract: Multi-year – open ended

If you are interested in applying please contact Kelsey Dyke: kdyke@apexsystems.com 614-467-4200

  • Design, develop, document, test, and debug new and existing complex MS excel spreadsheets, graphs and reports for internal use.
  • Serve as technical expert on complex MS Excel conversions from using Microsoft Drivers on WIN7 operating system to using Oracle ODBC Drivers on Win10 operating system.
  • Work directly with the business and end users to modify, develop and test all MS Excel conversions. Skills/knowledge required: complex MS Excel Macro work, Visual Basic (VB) Script work, ODBC Driver Connection Code work, Relational DB work, Data Formatting, XLQuery Add Ins, Date Parameter Changes, DSN Connections, Access DB and MAGNUM. Identify and evaluate new technologies for implementation as it relates to MS Excel conversions on the Win10 Operating System and MS Office 2016.
  • Analyze code to find causes of errors and revise as needed. Participate in meetings and analyze user needs to determine technical requirements and needed changes to ensure converted spreadsheets work as expected.
  • Consult with end user to prototype, refine, test, and debug spreadsheets to meet needs.
  • Considered highly skilled and proficient in discipline.
  • Seeking candidates that have recent experience converting complex MS Excel spreadsheets from using MS Drivers to using Oracle ODBC Drivers.
  • Conducts complex work important to the organization.
  • Works under minimal supervision with wide latitude for independent judgment. Strong communication skills, both verbal and written with collaborative and organizational skills.

 

Typically requires six to nine years of relevant experience or equivalent combination of experience and education.

 

Minimum Requirements:

 

Education:

Bachelor Degree in Computer Science, or Associates Degree with 8-12 years IT Software Developer related experience or High School Diploma/GED with 10 years IT Software Developer experience.

 

Experience:

8-12 years IT Software Developer experience (in addition to any experience identified above). Technical knowledge usually acquired from an educational institution or through equivalent work experience.