Ecommerce Data Acquisition Specialist – It
Current• Gather relevant sales / order data from each retailer on a daily • Perform error-checking and conversion on all files to ensure valid data is received before importing into the company's system (NetSuite)• Extensive data cleansing and analysis, using pivot tables, formulas (v-lookup and others), data validation, conditional formatting, and graph and chart manipulation• Merge and de-duplicate data from individual retailers so that orders with multiple items are viewed as a single order for processing• Re-structure data from each retailer into a format that is compatible with the company's inventory and shipping system• Import re-structured data into inventory and shipping system; bulk create shipping labels for order fulfillment team• Ensure that inventory system is properly updated to reflect processed orders• Create response files containing tracking information for all shipped orders and upload to each retailer• Provide technical support for all computers, mobile devices, printers and servers