Data Integration Specialist

Data Integration Specialist AREAS

Quality Assurance/ Data Integration

The Data Integration Specialist plays a crucial role in our company with focus on data extraction, transformation, and loading of data for our ERP business system solutions. You will participate in a team on the journey of successful data conversions ensuring data integrity is maintained and quality data is ready for use in our business system solutions. A positive, problem-solving attitude and the ability to achieve specific goals are essential skills for performing well in this position.

This role is integral to our operations as the Data Integration Specialist will be responsible for converting data from other business systems and formats to our platform, ensuring data integrity and accuracy. You will work collaboratively with all teams to support data migration, analysis, quality assurance, and process improvement efforts.

• Perform quality data validations for data imported comparing data sources to data fields and report results in the ERP business system solutions.
• Use current processes and implement process improvements as needed for our internal team and customers which may involve programming.
• Develop and implement quality assurance standards.
• Provide feedback to Quality Assurance Specialist on quality assurance issues.

• Perform data extractions, data analysis, data mapping, and data importing from multiple formats to our ERP business system solutions.
• Use internal tools to complete documentation for conversion projects and track time involvement.
• Troubleshoot and resolve any technical issues related to data conversion and communicate all issues effectively.
• Effectively and professionally participate in ongoing collaborations with management and internal teams and provide updates regarding conversion projects. This requires effective communication across all aspects of collaboratively worked projects.

• Receive and review manufacturer parts price files (typically in CSV format).
• Validate data for completeness, accuracy, and consistency.
• Identify and resolve data anomalies, formatting issues, or missing fields.
• Map incoming data fields to the appropriate fields in the ERP system.
• Apply business rules and logic to transform raw data into usable formats.
• Standardize units, categories, and naming conventions across manufacturers.
• Import transformed data into the ERP or business management system.
• Conduct testing to verify successful data integration.
• Perform audits to ensure pricing accuracy and data integrity.
• Document and resolve any discrepancies or errors.
• Work closely with product managers, procurement teams, and ERP administrators.
• Communicate with manufacturers or vendors to clarify data formats or resolve issues.
• Provide feedback to improve data submission standards and templates.
• Maintain detailed records of data sources, transformation rules, and integration processes.
• Generate necessary reports on data quality, pricing updates, and integration status.
• Identify opportunities to automate repetitive tasks (e.g., using scripts or ETL tools).
• Recommend enhancements to data workflows and integration tools.
• Stay updated on industry standards for product data and ERP integration.

• Ability to learn quickly and work independently or as part of a team.
• Analytical and critical thinking skills with attention to detail.
• Customer-service-oriented with excellent written and verbal communication skills.
• Excellent problem-solving and decision-making skills while using good judgement.
• A motivated and positive outlook with the ability to prioritize responsibilities.
• Strong attention to detail.
• Highly trainable for an industry-specific business.
• Customer service-minded.
• Effective communicator.
• Desire to grow and advance.

• Professional phone etiquette is a must.
• Ability to juggle multiple priorities at once.
• Must be able to work in a fast-paced environment.
• Experienced with current computer technology.