Senior Pricing Analyst

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

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 remote days per week.

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

• Education:
  
  Bachelor’s degree in Business, Finance, Economics, Informatics, or a related field required. Master’s degree or advanced certifications (e.g., analytics, finance, or data science) preferred.
• Experience:
  
  4+ years of progressive experience in pricing, business analytics, financial analysis, or related roles, with demonstrated success in driving data-driven decisions and supporting cross-functional initiatives.
• Technical
  
  Skills:
  • Advanced proficiency in Microsoft Excel and full Microsoft Office suite (required).
  • Experience with data visualization tools such as Power BI, Tableau, or similar platforms (preferred).
  • Working knowledge of SQL, Python, SAP or Salesforce (preferred).
• Analytical & Business
  
  Skills:
  • Strong analytical and problem-solving capabilities with the ability to translate complex data into actionable insights.
  • Experience supporting pricing strategy, margin analysis, and financial modeling.
  • Ability to manage multiple projects, prioritize effectively, and meet tight deadlines.
  • Strong communication skills with the ability to present insights to both technical and non-technical stakeholders.

• Complex Formula Development & Troubleshooting:
  Expertise in building and debugging advanced formulas, including nested functions, and dynamic array solutions.
• Data Analysis & Summarization:
  Advanced use of Pivot Tables and Pivot Charts to analyze large datasets and identify trends.
• Data Modeling & Transformation:
  Proficiency with Power Query and Power Pivot for data cleansing, transformation, and model creation.
• Automation & Efficiency:
  Experience with Macros and VBA solutions to automate repetitive tasks and improve workflow efficiency.
• Visualization & Reporting:
  Ability to create dynamic dashboards and interactive reports to effectively communicate insights and drive business decisions.

$95,000 - $110,000 annually, bonus eligible.

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.