Ecommerce Analyst
Simon & Schuster
Riverside, NJThis was removed by the employer on 8/9/2021 7:59:00 AM PST
Not to worry we have many other jobs on the site;
Browse all jobs
Browse the Sales Category
Search for Ecommerce Analyst jobs in Riverside-NJ
Search all Ecommerce Analyst postings
Full Time Job
The eCommerce Analyst will prepare and process Customer E-Book billings; develop, analyze and run queries/ reports to minimize errors and reconcile customer files to actual billings. The eCommerce Analyst will support the group, including EDI and POS, with functional testing as needed and adhere to all company and departmental policies and procedures.
eBook Processing:
• Responsible for accuracy of all E-Book billing transactions for Agency and TOS customers
• Responsible for ensuring all E-Book billing transactions process efficiently and on schedule
• Process all Pimsleur Subscription billings from source file into UOPS, verify accuracy and report on any exceptions
• Monitor E-Book billing functions and resolve issues
• Analyze processes to increase E-Book billing efficiencies
• Procure and track all customer E-book files on a monthly basis for processing
• Assist in reconciliation of customer E-Book files to actual E-Book billing
• Work with CFS to accurately capture and process E-Book refusals or sale reversals
EDI:
• Research new and existing EDI documents
• Analyze processes to increase EDI efficiencies
• Assist EDI and IT personnel with technical support as relates to troubleshooting, testing and resolving issues
Point of Sale (POS):
• Retrieve weekly POS files from customer source (email, FTP, Portal) and load to appropriate location
• Run weekly POS reports in IBM Cognos for distribution to various Departments
• Run regular validation reports to ensure accurate POS data loaded into system
Other:
• Document and develop processes and suggest improvements based on analytical conclusion
• Interact frequently with customer and sales contacts to resolve issues and ensure customer compliance
• Interface with IT for issue resolution and mapping
• Create queries from Excel and Access to run required reports
• Analyze systems, reports and procedures to support business rules and practices
• Other duties as necessary
REQUIREMENTS:
• Bachelor's Degree in Business Technology or related field from an accredited college/university
• Accounting, Finance, Customer Service or related experience a plus
• Excellent communication skills: verbal and written
• Excellent PC skills. Excel spreadsheet (Pivot Tables, V-Lookup, Macros), MS Access, Cognos and SQL
• Ability to use various PC utilities and Internet based utilities
• Strong interpersonal skills needed in dealing with other employees, management and customers
• Must be able to exercise good independent judgment, with good skills
• Well organized, with good time management skills
• Attention to detail and accuracy
• Ability to analyze reports/procedures and make suggestions for process improvements where needed
• Must be able to interpret objectives and coordinate day to day tasks
• Good at facilitating problem solving with customers and colleagues
• Ability to work under pressure to meet deadlines and month end goals