JOB OVERVIEW:
This position is responsible for working with the department to generate and summarize all aspects of data preparation, analytics, management reporting, and ad hoc reporting for the Product Category Management team. The data may consist of sales, cost, gross margin, commissions, product categories, cost adjustments, pricing, zone and regional reports as well as helping to track strengths, weaknesses and identify trends internal and external that may be impacting specific products or categories within the product and services portfolio. Requirements include creation of reports, compiling of data and the analysis to aid in the business strategy, development and maintenance of the product lines. Ability to onboard/mentor new team members and entry-level team members as needed.
KEY RESPONSIBILITIES:
- Compiles information necessary to review and create reporting to measure performance and trends for all product categories/suppliers as assigned. Data warehouse reporting, manipulation and analysis of data, both internal and external as well as ad hoc requests as needed to analyze trends in the business and support the business leaders.
- Creates a reporting tool and methodology for establishing marketing adjustments and the periodic maintenance and rationalization of them, review and manage the market adjustments providing analysis on market price changes inclusive of GPO contracts and provides information for Product Category Managers for review and disposition changes.
- Conducts needed analysis to help determine profitability models for all products, customers and/or suppliers.
- Responsible for supporting the sales tracing, performance rebate, quarterly rebate projections, and supplier marketing programs’ reporting and maintaining the related program elements including invoicing suppliers for monthly/quarterly programs as directed
- Responsible for supporting the tracking and monitoring of distribution agreement compliance and working with Pricing and Support teams to resolve non-compliance issues.
- Collaborates with Business Intelligence, Finance and other internal teams to support the reporting needs of the PCM team.
- Participates in special projects and performs other duties as required. Must be able to navigate the Henry Schein organization and understand department interdependencies.
SPECIFIC KNOWLEDGE & SKILLS:
- Ability to prioritize and handle multiple projects and daily tasks.
- Strong analytical, communication, and organizational skills.
- Working knowledge of data warehouse and Global Vendor reporting.
- JDE system experience is a plus.
- Strong knowledge of Excel (complex formulas, pivots, large datasets, financial modeling, scenario analysis, and data manipulation) and PowerPoint.
- Experience with MS Access is very he