Commercial Business Analyst

Medline Industries, LP•Northfield, IL

4d•$67,000 - $101,000

About The Position

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. Prepare business, financial and data analysis and reports. Job Description 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). Medline Industries, LP, and its subsidiaries, offer a competitive total rewards package, continuing education & training, and tremendous potential with a growing worldwide organization. The anticipated salary range for this position: $67,000.00 - $101,000.00 Annual The actual salary will vary based on applicant’s location, education, experience, skills, and abilities. This role is bonus and/or incentive eligible. Medline will not pay less than the applicable minimum wage or salary threshold. Our benefit package includes health insurance, life and disability, 401(k) contributions, paid time off, etc., for employees working 30 or more hours per week on average. For a more comprehensive list of our benefits please click here. For roles where employees work less than 30 hours per week, benefits include 401(k) contributions as well as access to the Employee Assistance Program, Employee Resource Groups and the Employee Service Corp. We’re dedicated to creating a Medline where everyone feels they belong and can grow their career. We strive to do this by seeking diversity in all forms, acting inclusively, and ensuring that people have tools and resources to perform at their best. Explore our Belonging page here. Medline Industries, LP is an equal opportunity employer. Medline evaluates qualified individuals without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, age, disability, neurodivergence, protected veteran status, marital or family status, caregiver responsibilities, genetic information, or any other characteristic protected by applicable federal, state, or local laws. Through our culture of belonging, our agile and resilient global team is determined to get our customers exactly what they need, at the right time, every time. If you’re a self-starter, eager to grow your career within a high-performing environment, this is the place for you. Introduce yourself to our recruiters and we'll get in touch if there's a role that seems like a good match. Medline is the largest provider of medical-surgical products and supply chain solutions serving all points of care. Through its broad product portfolio, resilient supply chain and leading clinical solutions, Medline helps healthcare providers improve their clinical, financial and operational outcomes. Headquartered in Northfield, Illinois, the company employs more than 43,000 people worldwide and operates in more than 100 countries and territories. To learn more about how Medline makes healthcare run better, visit www.medline.com.

Requirements

Bachelor’s degree in Business, Finance, Accounting, Information Systems, Mathematics or Applied Statistics.
At least 2 years of experience in sales analysis.
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).

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.