US Business Analyst II - Product Category

Henry Schein, Inc.; United States; Hybrid; USD 63,000 - 99,000; Full time

Benefits offered by this job

Medical

Dental and Vision Coverage

401K Plan with Company Match

PTO

Paid Parental Leave

Income Protection

Work Life Assistance Program

Flexible Spending Accounts

Educational Benefits

Worldwide Scholarship Program and Vol

Job summary

Henry Schein is seeking a data analytics and reporting professional to drive preparation, analysis, and management reporting for the Product Category Management team. You will build and summarize data across sales, cost, margin, pricing, and categories to support business strategy.

The role requires strong Excel and data warehouse skills, with the ability to onboard new colleagues and collaborate with Finance, BI, and PCM teams to deliver timely insights.

Qualifications

• Experience with data preparation, analytics and management reporting.
• Ability to create reports and summarize data for business strategy.
• Mentor/ onboard new team members as needed.

Responsibilities

• Compile information to review and create reporting on product categories and suppliers.
• Perform data manipulation and analysis for trends and profitability.
• Develop reporting tools and methodologies for market adjustments.
• Support rebate projections and supplier marketing program reporting.
• Collaborate with BI, Finance and PCM teams.

Skills

Analytical skills

Data analysis

Reporting

Excel advanced

PowerPoint

MS Access familiarity

JDE experience

Education

Bachelor's degree or global equivalent

Tools

Data warehouse reporting

Microsoft Excel

PowerPoint

MS Access

JDE

Job description

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 helpful and/or basic knowledge to learn such software tools. A successful candidate will have a good understanding of the systems and how data comes together from each source. They will have an innate sense for details, accuracy, and the urgency for reporting. Problem solver who can interpret data.

GENERAL SKILLS & COMPETENCIES:

Basic understanding of industry practices General proficiency with tools, systems, and procedures Basic planning/organizational skills and techniques Good decision making, analysis and problem solving skills Good verbal and written communication skills Basic presentation and public speaking skills Basic interpersonal skills Developing professional credibility

MINIMUM WORK EXPERIENCE:

Typically 2 to 4 years of related professional experience.

PREFERRED EDUCATION:

Typically a Bachelor's Degree or global equivalent in related discipline.

TRAVEL / PHYSICAL DEMANDS:

Travel typically less than 10%. Office environment. No special physical demands required.

Salary & Benefits

The posted range for this position is $63,396 to $99,056 which is the expected starting base salary range for an employee who is new to the role to fully proficient in the role. This position is eligible for a bonus not reflected in the posted range.

Other benefits available include:

• Medical
• Dental and Vision Coverage
• 401K Plan with Company Match
• PTO
• Paid Parental Leave
• Income Protection
• Work Life Assistance Program
• Flexible Spending Accounts
• Educational Benefits
• Worldwide Scholarship Program and Volunteer Opportunities

Henry Schein, Inc. is an Equal Employment Opportunity Employer and does not discriminate against applicants or employees on the basis of race, color, religion, creed, national origin, ancestry, disability that can be reasonably accommodated without undue hardship, sex, sexual orientation, gender identity, age, citizenship, marital or veteran status, or any other legally protected status.

For more information about career opportunities at Henry Schein, please visit our website at: www.henryschein.com/careers

Accommodation Requests

Please e-mail the appropriate email address below with the type of accommodation you are requesting. Please include your first and last name, phone number, position for which you are interested in applying and geographic location in your request.

US Candidates: [e-mail]
UK and Ireland Candidates: [e-mail]
Australia and New Zealand Candidates: [e-mail]
Malaysia Candidates: [e-mail]
Italy Candidates: [e-mail]

Work Arrangement Options

• Work From Home: Work is performed directly from the TSM's home office.
• Hybrid: Time is scheduled between working from a TSM home office and at a company facility, as required.
• Onsite: Work is performed exclusively at a company facility.
• Field: Position requires traveling to different locations within a specific geographic territory, as assigned.