Sales Analyst

Retailer Sales Reporting and Analysis using Excel and Access to streamline the process and track and maintain selling history across all accounts and divisions.

Manage company database that compiles sales team projections together with real-time order level data to produce multi-dimensional hierarchy that allows upper-level management to understand current and hirsotrical business performance and forecasts.

Royalty accounting and reporting, including producing quarterly licensor statements and internal royalty statements.

Additional analysis projects as needed by CFO or CEO.

Technical Requirements:

Advanced Excel, Formulas, Pivot Tables, Macros VBA

Advanced Access Macros, VBA, ODC Linking

Familiarity with retailer sales reporting web portals

Retail Math, File conversion skills

Compensation $50-60k DOE