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

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.

QUALIFICATIONS

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.

Advanced Excel Proficiency requirements:

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.

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 service. Rust-Oleum offers 9 paid holidays and one floating holiday 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

About Tremco Construction Products Group, Inc.

Learn More About Tremco Construction Products Group, Inc.

Tremco Construction Products Group, Inc. Careers

There has never been a more opportune time to join the dynamic team at Tremco Construction Products Group, Inc., a leader in delivering innovative solutions in the construction industry. This company stands at the forefront of technology and sustainability, making it an ideal place for professionals to advance their careers.

Explore Job Opportunities

Tremco Construction Products Group, Inc. offers a variety of job opportunities that cater to a range of skills and interests. Each position at the company is designed to challenge team members while providing meaningful solutions that contribute to global construction advancements.

Experience Professional Growth and Development

At Tremco Construction Products Group, Inc., growth and leadership go hand in hand. The company supports career advancement through professional development programs and leadership training, ensuring that every team member has the tools to succeed. Networking within the industry and within the company is encouraged, fostering a culture of collaboration and innovation.

Join a Diverse and Inclusive Team

Diversity and inclusion are at the core of the company culture at Tremco Construction Products Group, Inc. By embracing a wide range of perspectives, the company fosters an environment where all employees can thrive. Diversity training is integral, preparing team members to work effectively in today's global marketplace.

Internship Programs

For those starting their careers, Tremco Construction Products Group, Inc. offers internship programs that provide a robust foundation in the construction products industry. Interns gain hands-on experience, beneficial for both their professional growth and their resumes.

Benefits and Culture

Choosing to work at Tremco Construction Products Group, Inc. means opting for a company that values the well-being of its employees. The benefits package is comprehensive, supporting both the professional and personal needs of the team members. The company culture is built on a commitment to excellence, safety, and ethical practices, aligning with the company’s mission to lead the industry forward.

How to Apply

To explore employment opportunities and become part of a leading team, interested candidates should prepare their resumes and apply through the Tremco Construction Products Group, Inc. careers page. The hiring process is transparent, starting with an interview to assess fit and expertise.

Stay Connected with Career Opportunities

Stay informed about new positions and career tips by subscribing to job alert emails from Tremco Construction Products Group, Inc. Tailor the subscription to match personal career preferences and be the first to know about new openings and insider insights.

Innovation, Leadership, and Career Longevity

Tremco Construction Products Group, Inc. is not just a company; it's a place where careers are built. The team is committed to innovation and leadership in the construction products sector. Join Tremco Construction Products Group, Inc. and be part of shaping the future of construction, experiencing a career that grows as you do.