Spearhead Staffing has a new opening for a Data Analyst based in Lyndhurst, NJ. Please send your Word format resume and best number to reach you to if qualified and interested. Add "Job 248 Data Analyst" in the subject line. Please note Spearhead Staffing does not work 3rd party c2c or provide sponsorship. JOB DESCRIPTION: DATA ANALYST (ORD & EWR) General Overview To act as part of the facility teams as it relates to inbound data file importing. To actively retrieve daily data files from FTP and email, manipulate, correct and import them into PPX program and or USPS applications for processing. Maintain customer parcel data files and archives on a daily basis. Data - Daily Tasks -- Pull all data files (*all Canada, International and Domestic) from FTP folders or from emails, daily, a minimum of twice a day, or as required. -- Download customer data from FTP sites, and review product for import to determine if content contains any prohibited items, zero values, valid 2 letter country of origin codes, 2 letter province codes, any duplication of data (not to be confused with multi-package orders, these should appear on separate lines with their own unique identifier) and notify reporting Manager to take corrective action when necessary. -- Verify data is properly formatted for importing into PPX. -- Verify data is properly formatted for file upload to the USPS FTP for GSS processing. -- Notify customer service, in some instances customer's directly s via email or phone of any missing data or other data related issues -- Import customer data into PPX for processing purposes. -- Create .XML file for GSS processing and upload to USPS FTP site. -- Post copy of customer original data to FTP "To" archive folder and an excel version of the file to the XPO/RRD Operations folder daily. -- Work closely with Data Analysts in LAX location to assist in covering vacation and sick days, overflow during peak season. -- Work closely with Operations personnel to resolve any file or data issues. -- Re-import file when necessary for processing to be completed. -- All other duties as assigned by Management. Weekly Tasks -- Assist Operations teams to prepare all LVS, OGD and B to B Customs Manifests for all Canada bound trucks as they are scheduled. Create .txt format for WLR Broker and transmit files via email before truck crosses the border. Confirm files are "OK" once transmitted and run by WLR.