IT Data Integration Specialist

VSP Technologies; Prince George (VA); On-site; USD 70,000 - 110,000; Full time

Benefits offered by this job

401(k) match

Health, Dental, Vision

Short- & Long-Term Disability

Life Insurance

Paid time off

Paid Holidays

Tuition reimbursement

Job summary

VSP Technologies is seeking an IT Data Integration Specialist to maintain the integrity of data assets and enable timely, accurate reporting across departments. You will handle data integration among ERP and other systems, ensuring accuracy and availability for sales decisions and management insights.

The role requires proficiency in SQL, ETL tooling, and scripting, with exposure to Sage500 ERP and experience in data management and reporting.

Qualifications

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

Responsibilities

• Monitor and maintain the integrity of data assets across ERP, CRM, and other applications.
• Import and migrate large data sets into business systems for bulk updates.
• Prepare, test, validate, and combine large data sets from multiple sources.
• Create business reports using complex SQL queries from management requirements.
• Use ETL tools to synchronize data between systems.
• Audit end-user data records and document outcomes for stakeholders.
• Collaborate with internal developers to create robust data structures for web apps.
• Write documentation of data structures and procedures.
• Provide technical support to end-users.
• Promote the company and its products/services to enhance public recognition.
• Maintain a positive working relationship to boost morale, productivity, and efficiency.
• Adhere to Health, Safety, and Environmental policies.

Skills

SQL

ETL tools

Pivot tables

VBA/Python

Data integration

Reporting

Team collaboration

Education

Bachelor's in CS/Info Sci

Master's preferred

Tools

Sage500 ERP

Git

Java

JavaScript

PHP

Job description

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

VSP Technologies provides equal opportunities to all employees and applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, genetics, marital status, political affiliation or veteran status. For applicants or employees who are disabled or require a reasonable accommodation for any part of the application or hiring process may request assistance by contacting Human Resources at 804-668-1026.

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