Senior Pricing Analyst
Guardian Protection Products

Vernon Hills, Illinois


JOB DESCRIPTION

Job Title: Senior Pricing Analyst

Location: Vernon Hills, IL

Department: Rust-Oleum US Marketing

Reports To: Director, Pricing Analytics & Administration

Direct Reports/Manages others: No

Hybrid Schedule: Our hybrid work environment includes two (2) remote days/week.

This position is part of the Pricing team and reports to the Director of Pricing Analytics & Administration. The role is based in Vernon Hills, IL. Our hybrid work environment includes two (2) remote days/week.

RESPONSIBILITY

  • Extract and compile customer & product sales data from SAP, Power BI, Data Lake, or all applicable sources to support the overall pricing team.
  • Build and create profitability analytics models utilizing advanced Excel, Power Pivot and Power Query. Create impact analytics of different pricing scenarios on revenue and profitability.
  • Key contributor to pricing changes data compilation, impact analytics, and pricing change performance evaluation at products and accounts level.
  • Conduct ad-hoc analyses in support of pricing strategy, trade marketing, and product management.
  • Work with Director of Pricing Analytics to develop & publish periodic price reporting. Conduct tracking of pricing forecast, price realization, and price opportunity identification.
  • Work with Director of Pricing Analytics to conduct full lifecycle analysis to understand product value proposition, current or proposed price points, data gathering & cleansing, and deep dive advanced statistical analysis/modeling.
  • Support the Pricing Strategy team to understand and design complex commercial pricing models leveraging data and analytics to develop and execute pricing strategies across various categories, suppliers, and customer segments.
  • Support Sales teams operationally through deal support, data gathering through custom dashboard/reports development and analysis.
QUALIFICATIONS
  • Education: 4-year BS degree in business, finance, economics, informatics, or related fields.
  • Experience: 4+ years of experience in business analysis, data analysis, project management, or a related field.
  • Advanced level Excel skillset and Microsoft Office packages experience is required.
  • Experience with Power BI, Tableau or other data visualization tools is desirable.
  • Familiarity with Access, SQL and SAP preferred.
Advanced Excel Proficiency requirements:
  • Create and troubleshoot complex formulas: Using functions like VLOOKUP, INDEX-MATCH, and array formulas.
  • Develop and manage PivotTables: For summarizing and analyzing large datasets.
  • Utilize advanced data analysis tools: Such as Power Query and Power Pivot for data modeling and transformation.
  • Automate tasks with Macros and VBA: To streamline repetitive tasks and enhance productivity.
  • Perform advanced data visualization: Creating dynamic charts and dashboards to present data insights effectively.
From big benefits to small, we take care of our associates! After 30 days of employment, you will be eligible for a benefits package that includes medical, dental, life, disability and business travel insurance, flexible spending accounts, EAP, stock purchases and vacation/sick days/parental leave.

We also offer a 401(k) plan after three months of employment. Associates are vested in the RPM Pension plan after completing five years of service. Rust-Oleum offers 9.5 paid holidays and two floating holidays per year. You are also eligible to earn three weeks of vacation on an annualized basis.

Rust-Oleum is an equal opportunity employer. Employment selection and related decisions are made without regard to sex, race, age, disability, religion, national origin, color, or any other protected class.



Get Hired Faster

Subscribe to job alerts and upload your resume!

*By registering with our site, you agree to our
Terms and Privacy Policy.

More Defence and Military jobs


Guardian Protection Products
Orlando, Florida
$60,000.00 - $80,000.00 per year
Posted 1 day ago
Guardian Protection Products
Pleasant Prairie, Wisconsin
Posted 1 day ago
Guardian Protection Products
Vernon Hills, Illinois
Posted 1 day ago
View Defence and Military jobs ยป

Share diversity job

Senior Pricing Analyst is posted on all sites within our Diversity Job Network.


African American Job Search Logo
Hispanic Inclusion Jobs Logo
Asian Job Search Logo
Women Inclusion Jobs Logo
Diversity Inclusion Jobs Logo
Seniors to Work Logo
Black Inclusion Jobs Logo
Veteran Job Center Logo
LGBT Job Search Logo
Asian Inclusion Jobs Logo
Disabled Job Seekers Logo
Senior Inclusion Jobs Logo
Disability Inclusion Jobs Logo
US Diversity Job Search Logo
LGBTQ Inclusion Jobs Logo
Hispanic Job Exchange Logo