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
- 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
DATA CONVERSION RESPONSIBILITIES
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.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
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 detailHighly trainable for an industry-specific businessCustomer service-mindedEffective communicatorDesire to grow and advanceREQUIREMENTS
Professional phone etiquette is a mustAbility to juggle multiple priorities at onceMust be able to work in a fast-paced environmentExperienced with current computer technologyPowered by JazzHR
qL16ey4fdi
