Senior Pricing Analyst

Rust-Oleum Corporation; Vernon Hills (IL); Hybrid; USD 95,000 - 110,000; Full time

Benefits offered by this job

Medical, dental, and life insurance

401(k) plan

Three weeks of vacation annually

Nine paid holidays and two floating holidays

Job summary

Rust-Oleum Corporation is seeking a Senior Pricing Analyst to join their Pricing team in Vernon Hills, IL. This hybrid role allows for two remote days each week. The incumbent will be responsible for extracting sales data, building profitability models, and conducting comprehensive analyses to support pricing strategy.

The ideal candidate should possess strong analytical skills, a Bachelor's degree, and 4+ years of relevant experience in pricing or analytics. Benefits include a competitive salary range of $95,000 - $110,000 annually, medical and 401(k) plans, and several paid holidays.

Qualifications

• 4+ years of experience in pricing, business analytics, or financial analysis.
• Demonstrated success in driving data-driven decisions.
• Strong analytical and problem-solving capabilities.

Responsibilities

• Extract and compile customer & product sales data from applicable sources.
• Build profitability analytics models utilizing advanced Excel.
• Key contributor to pricing changes data compilation and evaluation.
• Conduct ad-hoc analyses in support of pricing strategy.
• Work with Director to develop & publish periodic price reporting.
• Support Pricing Strategy team in designing complex commercial pricing models.
• Support Sales teams operationally through deal support and data analysis.

Skills

Advanced proficiency in Microsoft Excel

Data visualization tools (Power BI, Tableau)

SQL

Python

Education

Bachelor’s degree in Business, Finance, Economics, or related field

Master’s degree or advanced certifications (analytics, finance, or data science)

Tools

SAP

Salesforce

Job description

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.

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

Advanced Excel Proficiency Requirements

• Complex Formula Development & Troubleshooting: Expertise in building and debugging advanced formulas, including nested functions, and dynamic array solutions.
• Data Analysis & Summarization: Advanced use of PivotTables and PivotCharts 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.

Salary Range

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

Benefits

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.

Equal Opportunity Employment Statement

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.