Job Opening

IT Data Technician – Prince George, VA

The IT Data Technician maintains the integrity of the company’s data assets.

Essential Functions

  • Monitor and maintains the integrity of the company’s data assets to include the ERP, CRM, and other applications as needed
  • Prepare, test, validate, and execute the import of large data sets into business ¬systems for bulk updates
  • Compare, map, and combine large data sets from multiple sources
  • Generate reports based on complex SQL queries to support business requirements and allow for in-depth data analysis by VSP management
  • Audit new, end-user created records for completeness and accuracy, and recommend corrections as needed:
    • Items, customers, etc. entered in the ERP
    • New leads and prospects created in the CRM
    • Customers, sales orders, and order lines copied from the ERP to the CRM
    • Provide reports to IT Manager and other managers and supervisors on audits and corrections made
  • Work with internal developers to create robust data structures to support custom, internal web applications
  • Work with marketing to summarize and report on complex data from multiple sources
  • Show proficiency with relational databases, including T-SQL and MySQL
  • Generate documentation of data structures and work procedures
  • Project a favorable image of the company to promote, foster, and enhance public recognition of the company and its products and services
  • Maintain a favorable working relationship with all company employees to foster and promote a cooperative and harmonious working climate that will be conducive to maximum employee morale, productivity, and efficiency/effectiveness

Required Experience / Education

  • Bachelor’s degree in Computer Science or related field
  • Experience related to essential functions

Preferred Experience / Education

  • Proficient in writing complex SQL queries in T-SQL and MySQL
  • Demonstrated ability to create and edit Crystal Reports
  • Ability to create and edit VBA macros in Microsoft Office documents, primarily Excel
  • Adept at summarizing large data sets in Excel using pivot tables and complex formulas
  • Experience with Salesforce data management and systems integration
  • Knowledgeable of web-based technologies, including HTML, CSS, JavaScript, PHP, and the Laravel framework
Job Title