Pricing Analyst (Sr)

<div><p><b>BUILD YOUR FUTURE WHILE YOU HELP BUILD A BETTER WORLD!</b>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.</p><h3>Essential Duties And Responsibilities</h3><ul><li>RPM end of month reporting based on brand/region analyzing sales trends&PVM effects on margin.</li><li>End-of-month reporting based on select customer list defined by Pricing Manager/Pricing Director (including sales trends + PVM effects).</li><li>End-of month reporting on Price Effect including validation/analysis against automated tools to ensure no errors across all reports.</li><li>Weekly reporting for low-margin items/transactions across all Tremco brands/regions.</li><li>Ad-hoc updates to Pricing Master for new items/item updates including all respective updates to price lists and GM% files.<ul><li>Build out all load files necessary for Ops team to execute.</li><li>Includes maintenance for PowerBI price lists + necessary Sharepoint reference files.</li></ul></li><li>Assist Pricing Manager with data validation/testing regarding PowerBI models/dashboards and major IT projects (RPM One, Tremco Data Lake etc.)</li><li>Ad-hoc development of PowerBI models/dashboards. Identify opportunities where PowerBI can be leveraged to automate manual Excel processes/reports.</li><li>Execute ad-hoc queries in SQL and build respective Excel reports.<ul><li>Prepare and present internal customer facing analytics.</li></ul></li><li>Identify opportunities to improve/streamline existing reporting methods/processes to ensure optimal turnaround times and improve data quality.</li><li>Keeping informed on pricing analysis methods and industry trends.<ul><li>Continued learning on current data science methodologies (Python, Databricks, etc.)</li></ul></li><li>Analyzing competitor pricing and market trends to increase market share and profitability.</li></ul><h3>Education</h3><ul><li>A Bachelor's degree in mathematics, statistics, finance, economics, or in a related field.</li><li>A Master’s degree in business administration will be advantageous.</li></ul><h3>Experience</h3><ul><li>A minimum of two to four years' experience as a pricing analyst in a similar industry.</li><li>Experience in Chemical, Building Materials and/or Industrial Product industry experience preferred.</li></ul><h3>Skills And Abilities</h3><ul><li>Proficiency in business intelligence (BI) software, such as PowerBI.</li><li>Experience utilizing pricing in SAP advantageous.</li><li>Experience working within Salesforce platform advantageous.In-depth knowledge of statistical methods and data analysis.</li><li>Extensive experience in analyzing pricing strategies and forecasting revenue and market share.</li><li>Experience in collaborating on pricing strategies with sales and marketing departments.</li><li>Ability to keep abreast of industry trends and develop dynamic pricing tools.</li><li>Advanced ability to present pricing analysis reports to relevant stakeholders.</li><li>Excellent analytical and communication skills.</li></ul><h3>Other Qualifications</h3><ul><li>Ability to travel up to 15%</li></ul><h3>Additional Information</h3><ul><li>Primary Role (Summary)<ul><li>Improving data structures, integration between systems, data reliability/consistency for usage in pricing analytics</li><li>Tracking Price realization, leakage and other related KPIs</li><li>Supporting design and tracking of price approval process</li><li>Supporting deal review and providing guidance and analytics on improving pricing/profitability</li><li>Setting and tracking pricing policies, business rules and RACIs</li></ul></li><li>Skills: Behavioral&Technical:<ul><li>Profitability and growth orientation; does not hesitate in challenging sales force when required; Willingness and mindset to get into details</li><li>Strong financial skills to utilize the decision support systems to interface with the sales and marketing organizations to drive specific action plans and programs</li><li>Comfortable executing analyses independently in MS Excel</li><li>Comfortable with independently accessing and running analyses on data directly from a database (e.g. via SQL)</li><li>Experience with BI or dashboarding technologies (e.g. Tableau, Power BI) to independently build and manipulate fit-for-purpose reporting</li></ul></li><li>Key Accountabilities / Essential Functions of the Job:<ul><li>Supporting and refining existing price realization dashboards while spearheading monthly investigations into price performance and providing insights to Pricing Leader and other business leaders</li><li>Identifying gaps in current data structures, closing these gaps in collaboration with other busines