CFS Reporting Analyst

Simon and Schuster

• Email Address: kathleenpaglia@simonandschuster.com
• Fax: 856-824-2406
• Posting Date: 6/16/2008

Responsible for providing reporting and analysis required meeting the group’s financial reporting and cash forecasting requirements for the CFS department; this includes compiling all the necessary supporting documentation and understanding a variety of databases such as Hyperion, Business Objects, Essbase and Access. The analyst will also reconcile domestic credit card account and prepare monthly journal entries and Ad Hoc reporting as requested by management.

SCOPE AND IMPACT OF JOB

Dollar responsibilities (revenue)
• Average monthly accounts receivable of $350 million
• Monthly cash forecasting totaling in excess of $850 million annually
• Group Operating budget $2m+

Other responsibilities
• Failure to provide timely and accurate reporting could result in influencing poor decisions and driving excessive losses to the company.
• Failure to properly reconcile receivable balances due in a timely manner will result in a deterioration of the reporting and an increase in bad debt exposure.

REQUIRED KNOWLEDGE AND EXPERIENCE (Knowledge and experience necessary to do job)

Related Work Experience
• 1 to 2 years of accounting experience with knowledge & focus on reporting.
• Strong database skills preferred in Excel & Access.

Formal education or equivalent
• Bachelor’s degree (BS or BA) in Accounting or Finance considered.

Skills
• Good communication skills; verbal and written.
• Excellent accounting and analytical skills.
• Excellent presentation skills.
• Strong personal computer skills, including database management, essential.
• Strong planning and organization skills.

Other
• Knowledge of SAP financial systems, including general ledger and accounts receivable modules, preferred.
• Working knowledge of Hyperion and Business Objects considered.
• Working knowledge of Essbase and Access considered.
• Able to work in a fast paced, somewhat stressful environment.
• Must be able to meet deadlines.

PRIMARY RESPONSIBILITIES (List in order of importance, and list amount of time spent on task)

• Provide analytical support in connection with the group’s reporting requirements.
• Develop or assist in the development and issuing of various management reports and variance analysis.
• Responsible for timely and accurate reporting.
• Review current reporting requirements and recommend changes.
• Collect relevant data for report preparation from internal and external sources.
• Maintain required databases using Essbase and other analytical tools.
• Analyze monthly expenses and report on variances.
• Review and process all expense/ invoices to accounts payable.
• Prepare any necessary monthly and year-end journal entries and accruals.
• Access accounts receivable and other databases to provide analysis and ad hoc reports.
• Maintains an excellent working knowledge of Company Policies and Procedures.
• Maintain detailed processes, procedures and tracking of Sarbanes-Oxley requirements and departmental compliance.