About the job
BUILD YOUR FUTURE WHILE YOU HELP BUILD A BETTER WORLD!
Tremco CPG is an aggressive, growth-oriented company with revenues of over $1 billion. We are a world leader in solving complex waterproofing and roofing problems for our commercial, institutional, and industrial customers.
If you’re looking for a place to build a career, with great benefits, advancement opportunities, technology, people and a commitment to a sustainable future, you’ve found it with us.
We are currently looking for an innovative Sr. pricing analyst to increase our business’ competitiveness and profitability. In this role, you will be analyzing pricing data, preparing market share and revenue forecasts, and comparing the outcomes of different pricing strategies. To ensure success as a Sr. pricing analyst, you should possess sound knowledge of quantitative and qualitative data analysis methods and experience in a similar role. An accomplished Sr. pricing analyst is someone who can translate pricing data into actionable profit-enhancing strategies.
Essential Duties And Responsibilities
- RPM end of month reporting based on brand/region analyzing sales trends & PVM effects on margin.
- End-of-month reporting based on select customer list defined by Pricing Manager/Pricing Director (including sales trends + PVM effects).
- End-of month reporting on Price Effect including validation/analysis against automated tools to ensure no errors across all reports.
- Weekly reporting for low-margin items/transactions across all Tremco brands/regions.
- Ad-hoc updates to Pricing Master for new items/item updates including all respective updates to price lists and GM% files.
- Build out all load files necessary for Ops team to execute.
- Includes maintenance for PowerBI price lists + necessary Sharepoint reference files.
- Assist Pricing Manager with data validation/testing regarding PowerBI models/dashboards and major IT projects (RPM One, Tremco Data Lake etc.)
- Ad-hoc development of PowerBI models/dashboards. Identify opportunities where PowerBI can be leveraged to automate manual Excel processes/reports.
- Execute ad-hoc queries in SQL and build respective Excel reports.
- Prepare and present internal customer facing analytics.
- Identify opportunities to improve/streamline existing reporting methods/processes to ensure optimal turnaround times and improve data quality.
- Keeping informed on pricing analysis methods and industry trends.
- Continued learning on current data science methodologies (Python, Databricks, etc.
- Analyzing competitor pricing and market trends to increase market share and profitability.