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.

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

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