Senior Pricing Analyst

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.

QUALIFICATIONS

• Education: Bachelors degree in Business Finance Economics Informatics or a related field required. Masters 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: $95000 - $110000 annually bonus eligible

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