Commercial Business Analyst

Commercial Business Analyst

Requirements

• Bachelor’s degree in Business, Finance, Accounting, Information Systems, Mathematics or Applied Statistics.
• At least 2 years of experience in sales analysis.
• Advanced level skill in Microsoft Access (for example: modifying default field properties, creating a sub form, adding a control button, modifying query criteria and query totals, using conditional formatting and/or viewing data relationships).
• Advanced level skill in Microsoft Excel (for example: using AVERAGE function, merging and centering cells, printing centered page and/or creating a pivot table).
• Ability to calculate figures and amounts such as discounts, interest, commissions, proportions, percentages, volume.
• Ability to apply concepts of algebra and business statistics.
• Willingness to travel for business related needs (i.e. training, accounts meetings, development, etc).

Responsibilities

• Analyze existing product pricing across all market sectors, identify price/volume trends and recommend price ranges based on customer type (market segment). Develop analysis to measure the trends, efficiencies and effectiveness of sales and resource allocation and utilization.
• Prepare and analyze sales forecast and results reports and presentations including analysis of variances versus budget forecasts.
• Analyze item pricing across all customers to identify situations where pricing is outside of the normal, predetermined price range.
• Review pricing to determine items that are priced outside of the normal predetermined range for typical customers of that market type.
• Develop moderately complex reports and queries for sales management. Measure the trends, efficiencies and effectiveness of sales and resource allocation and utilization.
• Ensure new pricing rules are first reviewed and evaluated for their impact on sales rep commissions before final implementation.
• Evaluate 3rd party industry pricing data being marketed and sold to Medline customers to understand what information is being provided and implications to the Company.
• Support sales teams in preparing and evaluating deal scenarios and contract terms.
• Collaborate with Sales, IS and Finance to develop, create and maintain reporting requirements and ensure systems provide accurate and timely data.
• Provide support, guidance, and training to less experienced analysts, in order to develop skills and experience to attain and exceed predefined goals including fill rates, pricing accuracy percentages, A/R balances and surplus depletion.

Preferred Qualifications

No preferred qualifications provided.