eCommerce Analyst

Job Description

Simon & Schuster is a global leader in general interest publishing, dedicated to providing the best in fiction and nonfiction for readers of all ages, and in all printed, digital and audio formats. Its distinguished roster of authors includes many of the world's most popular and widely recognized writers, and winners of the most prestigious literary honors and awards.

It is home to numerous well-known imprints and divisions such as Simon & Schuster, Scribner, Atria Books, Gallery Books, Pocket Books, Adams Media, Simon & Schuster Children's Publishing and Simon & Schuster Audio and international companies in Australia, Canada, India and the United Kingdom, and proudly brings the works of its authors to readers in more than 200 countries and territories. For more information visit our website at www.simonandschuster.com.

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

ViacomCBS is an equal opportunity employer (EOE) including disability/vet.

Jobcode: Reference SBJ-d8736x-3-16-66-206-42 in your application.