JOB PURPOSE    

This position is responsible for maintaining data, analyzing and reporting trends, preparing analysis, and implementing computer systems to gather data.

ESSENTIAL DUTIES AND RESPONSIBILITIES

1.   Maintains data to provide the U.S. Distribution, Marketing, and/or Sales divisions with pertinent impact analysis of economic and Company factors affecting ongoing and proposed programs.  Analyzes output by evaluating trends, historical relationships and other factors that may have caused variances.  Keeps abreast of Company programs and events such as the car program, the sales force compensation program, contests, promotions, product launches, etc., in order to perform effective analyses.  Assists in preparing recommendations to be presented to Distribution, Marketing, Sales, and/or Finance management.

2.   Coordinates the timing of and preparation of detail and summary reports for annual budgets and periodic estimate updates for all income and expense categories in the Distribution, Marketing, and/or Sales divisions.  This process involves communicating with designated planners in each reporting area in order to coordinate assumptions and completion deadlines as well as providing assistance to planners in the mechanics of using the Hyperion planning system.  Summarizes results for each division and uses knowledge of departmental activities to write variance explanations for significant variances.

3.   Assists the department’s management team with special projects by gathering and analyzing data from various databases and formatting in either graph or text form as required for presentation purposes.  This requires knowledge of various data available (sales force, financial and product), Company programs, and graphic packages.

4.   Analyzes ongoing income statement activity for the Distribution, Marketing, and/or Sales divisions and prepares monthly written variance explanations for Sales, Variable, Semi-Variable and Fixed SG&A financial reports.  Uses knowledge of planned projects and activities for each department to monitor key expense trends and thereby anticipate variance explanations.

5.   Uses data mining software to gather historical data from the Company’s data warehouse for use in analyzing sales and marketing programs.  Prepares reports of findings in either graph or text form to support information requests from management.  Uses presentation software (Tableau) to maximize effectiveness of visualizations for presentation purposes to ensure audience understanding.