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

Date Posted: 11/19/2020

Job Snapshot

Job Description

Plant Name: Oak Brook Executive Office

Requisition ID:005108--Corp


POSITION SUMMARY

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).   

RESPONSIBILITIES:

  • 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.
  • Use Alteryx data management software to update the pricing tools each week.
  • 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 Territory Sales Managers (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.

 

#LI-VE1

 

Job Requirements

REQUIREMENTS:

  • Bachelor’s degree in Math, Computer Science, Statistics, Finance or another relevant field.
  • Minimum of 2 years’ experience in a data scientist, data analyst, or similar role working with large data sets and preparing complex analyses for a company with multiple locations.
  • Advanced Microsoft Excel skills required (macros, pivot tables, VBA).
  • Microsoft Dynamics SL, QAD, Salesforce and PowerBI a plus.
  • Familiarity with relational databases and SQL a plus.
  • 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.