Data Integration Specialist

Job Description

Job Description

• Data Integration Specialist

AREAS

Quality Assurance / Data Integration

ABOUT THE ROLE

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.

ROLE PURPOSE

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.

RESPONSIBILITIES

QUALITY ASSURANCE RESPONSIBILITIES

DATA CONVERSION RESPONSIBILITIES

PARTS PRICING DATA INTEGRATION

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.

PERSONAL TRAITS

REQUIREMENTS

Powered by JazzHR

qL16ey4fdi