Senior Pricing Analyst

Tremco Construction Products Group•Vernon Hills, IL

9h•Hybrid

About The Position

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.

Requirements

Bachelor’s degree in Business, Finance, Economics, Informatics, or a related field required.
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
Advanced proficiency in Microsoft Excel and full Microsoft Office suite (required)
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
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

Nice To Haves

Master’s degree or advanced certifications (e.g., analytics, finance, or data science) preferred.
Experience with data visualization tools such as Power BI, Tableau, or similar platforms (preferred)
Working knowledge of SQL, Python, SAP or Salesforce (preferred)

Responsibilities

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.