Data Entry // Data Processing // Data Management Person Needed

---

---

Company Summary: Verve Coffee is an Omni-Channel Coffee Company with Wholesale, Retail (14 cafes) and E-Commerce Website. Data is all over the place despite the fact that we have a very extensive data stack. There is a shrinking list of data gaps we are trying to address. Should Require a Couple Days a Month after Some Catchup Work. Toolset // Topics PlateIQ (Cloud Software) – Collecting, Uploading and Cross Referencing. a. Collecting i. Reaching out to PlateIQ to Request PDF Files for Verve’s Account ii. Download Detail Purchase Report b. Uploading i. Drop File in a Folder ii. Push Button To Upload Report to SQL Server iii. Place PDF’s in a Folder Use in Reporting c. Cross Referencing i. Use a Custom Tool that will allow for Deduping Highly Duplicated Data (think 11 sku’s for a pumplin muffin from same vendor) UPS Data – Collecting, Uploading a. Collecting i. Download Invoice Data from UPS.com b. Uploading i. Drop in Folder ii. Push Button To Upload Report to SQL Server Freight Shipments – Collecting, Uploading and Cross Referencing a. Collecting i. Download and Collect Documents From a Variety of Sources (Freightquote.com, Email, etc.) b. Uploading // Converting i. Convert PDF Documents to Excel // Database Using Parsing Software ii. Upload Converted Data to SQL Server c. Cross Referencing i. Use a Custom Tool to Connect Freight Bills to Customer Invoices and Products There are a bunch of other topics // possibilities a. Data Quality Monitoring b. Image and Product Detail Page Management c. Allocation Management for COGS (think rent, utilities, etc) d. Delivery Costs e. Manage Recipes for Coffee Drinks and / or Food Items

Keyword: Data Cleaning

Price: $10.0

Data Cleaning Data Entry Document Conversion Microsoft Excel Google Docs Database