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

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