IT Data Integration Specialist

IT Data Integration Specialist

The Data Integration Specialist maintains the integrity of the company’s data assets. We are looking for someone who enjoys working with large data and has a keen eye for detail and accuracy to join our IT team. In this role, you will work with multiple departments to ensure they have access to timely, accurate reports to drive sales and make informed business decisions. You will also be responsible for integrating data among multiple systems while ensuring data integrity.

Essential Functions

1. Monitor and maintain the integrity of data assets, including the ERP, CRM, and other applications, as needed
2. Import and migrate large data sets into business systems for bulk updates
3. Prepare, test, validate, and combine large data sets from multiple sources
4. Create business reports using complex SQL queries from business requirements defined by company management.
5. Use ETL tools to synchronize data between systems
6. Audit end-user-created data records and document the outcome for non-technical and technical stakeholders
7. Collaborate with internal developers to create robust data structures to support custom web applications
8. Write documentation of data structures and work procedures
9. Provide technical support to end-users
10. Project a favorable image of the company to promote, foster, and enhance public recognition of the company and its products and services
11. 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
12. Adheres to all company Health, Safety, and Environmental policies and procedures as outlined in the VSP Health & Safety Manual. Actively contributes to maintaining a safe, compliant, and environmentally responsible workplace in alignment with VSP standards

Experience / Education

1. Bachelor’s degree in Computer Science, Information Science, or related field required, Master's preferred
2. Proven proficient in writing complex SQL queries in T-SQL and MySQL
3. Exposure to Sage500 ERP
4. Experience related to essential functions
5. Adept at summarizing large data sets using pivot tables and complex formulas
6. Experience with data management and systems integrations
7. Demonstrated ability to create and edit report templates to visualize data
8. Ability to create and edit scripts (such as VBA or Python) to modify spreadsheets
9. Familiar with Java, PHP, and JavaScript
10. Knowledge of version control with Git

Job Type: This is a full-time position.  Days of work are Monday through Friday, 8:00 a.m. to 5:00 p.m.

Travel

Limited overnight travel may be required as job duties demand.

Benefits:

• 401(k) plus company match
• Health, Dental, and Vision Insurance
• Short- & Long-Term Disability
• Life Insurance
• Paid time off
• Paid Holidays
• Tuition reimbursement