Commercial Business Analyst
Medline Industries - Transportation & Operations, Libertyville, IL, United States
Job Summary
Join our dynamic Sales Operations department where collaborative teams in Pricing, Customer Data Management, Sales Compensation, and more intersect to empower our sales teams. Our mission is to grow and retain customers through consistency and overall experience to optimize Medline sales and customer experience enabling long-term partnership. Dive into an organization dedicated to precise product pricing, comprehensive market insights, seamless customer onboarding, and all the critical support our Salesforce needs for continuous growth.
Analyze business and financial results to support the sales organization. Present findings and recommendations to sales management to solve problems and issues related to sales opportunities. Plan and prepare business, financial and data analysis and reports.
Job Description
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.
Required Experience:
Education
Bachelor’s degree in Business, Finance, Accounting, Information Systems, Mathematics or Applied Statistics.
Work Experience
At least 2 years of experience in sales analysis. Additional - Ability to successfully apply standard financial, accounting and business problem-solving skills to business problems with multiple variables.
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).
Benefits
- Medline is committed to offering competitive benefits and a variety of choices to best meet the needs of you and your family. For employees scheduled to work at least 30 hours per week, this includes health and well-being, financial fitness, career development, paid time off and more. Employees scheduled to work less than 30 hours per week can participate in the 401(k) plan, access the Employee Assistance Program (EAP), Employee Resource Groups (ERG) and Medline Service Corps. For a more comprehensive list of our benefits, please click
Every day, we’re focused on building a more diverse and inclusive company, one that recognizes, values and respects the differences we all bring to the workplace. From doing what’s right to delivering business results, together, we’re better. Explore our Diversity, Equity and Inclusion page
Medline Industries, LP is an equal opportunity employer. Medline evaluates qualified applicants without regard to race, color, religion, gender, national origin, age, sexual orientation, gender identity or expression, protected veteran status, disability/handicap status or any other legally protected characteristic.