Data Analyst - Pricing and Margins in Oak Brook, Illinois, US at Mauser Packaging Solutions

Date Posted: 12/22/2020

Job Snapshot

Job Description

Plant Name: Oak Brook Executive Office

Requisition ID:005872--


This position will develop analytical approaches to provide our sales team with pricing guidance for customer quotes, collect and analyze data to provide insight for site-specific pricing strategies, and develop templates to report on KPIs. This person will work closely with other departments to enhance data integrity and analytical capabilities. In addition, this person will assist with managing and updating the data in the Enterprise Data Warehouse (EDW).   


  • Develop models to set pricing benchmarks by product type and locations as well as to illustrate price/margin performance and areas for opportunity.
  • Partner with IT to maintain and update the product category information at the SKU level in the EDW.
  • Work with IT to ensure pricing is implemented correctly in ERP systems.
  • Manage, monitor, and respond to daily quote and pricing requests.
  • Use Alteryx data management software to update the pricing tools.
  • Create templates to report on KPIs as well as the financial and volume impact of pricing actions.
  • Assist with calculating unit costs by product type and location for the reconditioning segment for use in identifying low-margin customers.
  • Partner with TSMs (Territory Sales Managers) to gain an understanding of each market’s competitive landscape, seasonal trends, raw material sourcing capacity, and plant utilization.
  • Provide pricing benchmarks for quote requests submitted by TSMs.
  • Assist with ad hoc requests and other duties as assigned.




Job Requirements


  • Bachelor’s degree in Math, Computer Science, Statistics, Finance or another relevant field.
  • Minimum of 2 years’ experience in Pricing, Finance, data analysis, and data manipulation.
  • Advanced Microsoft Excel skills required (macros, pivot tables, VBA).
  • Microsoft Dynamics SL, QAD, Salesforce and PowerBI a plus.
  • Ability to take ambiguous or incomplete information and turn it into a practical solution.
  • Strong analytical and problem-solving skills; self-starter with the ability to independently identify action items.
  • Ability to thrive in a fast-paced environment and possess the flexibility to quickly adapt to changing needs.
  • Possess customer service attitude and continuous improvement mindset.
  • Strong team orientation with ability to work collaboratively and influence others across the organization.
  • Excellent oral and written communication skills.

Not Ready to Apply?

Joining our Talent Network will enhance your job search and application process. Whether you choose to apply or just leave your information, we look forward to staying connected with you.