Bachelor's degree in Computer Science, Information Science, or related field required; Master's preferred
Proficient in writing complex SQL queries in T-SQL and MySQL
Exposure to Sage500 ERP
Experience with data management and systems integrations
Adept at summarizing large data sets using pivot tables and complex formulas
Ability to create and edit scripts (such as VBA or Python) to modify spreadsheets
Familiar with Java, PHP, and JavaScript
Responsibilities
Monitor and maintain the integrity of data assets across various applications
Import and migrate large data sets into business systems for updates
Prepare, test, validate, and combine large data sets from multiple sources
Create business reports using complex SQL queries based on management requirements
Use ETL tools to synchronize data between systems
Audit end-user-created data records and document outcomes for stakeholders
Collaborate with internal developers to create robust data structures for web applications
Benefits
401(k) plus company match
Health, Dental, and Vision Insurance
Short- & Long-Term Disability
Life Insurance
Paid time off
Paid Holidays
Tuition reimbursement
Full 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
Monitor and maintain the integrity of data assets, including the ERP, CRM, and other applications, as needed
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 business requirements defined by company management.
Use ETL tools to synchronize data between systems
Audit end-user-created data records and document the outcome for non-technical and technical stakeholders
Collaborate with internal developers to create robust data structures to support custom web applications
Write documentation of data structures and work procedures
Provide technical support to end-users
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
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
Bachelor's degree in Computer Science, Information Science, or related field required, Master's preferred
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
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.
