Pricing Analyst (Sr)

Tremco Construction Products Group; Beachwood (OH); On-site; USD 75,000 - 90,000; Full time

Benefits offered by this job

Health insurance

Paid holidays

Paid time off

401(k) with company match

Company Pension Plan

Performance Based Commission

Continuing education

Job summary

Tremco Construction Products Group in Beachwood, OH seeks a Sr. Pricing Analyst to translate pricing data into actionable strategies, forecast revenue, and improve profitability across our commercial, institutional, and industrial businesses.

You will own end-of-month reporting, build PowerBI dashboards, run SQL queries, and partner with Sales and Marketing to optimize pricing. A Bachelor's in math/ Stats/ finance and 2–4 years pricing experience are required; a Master's is a plus.

Qualifications

• Bachelor's degree in mathematics, statistics, finance, economics, or related field.
• 2–4 years pricing analyst experience in similar industry.
• Experience in Chemical, Building Materials or Industrial product industries preferred.
• Strong BI, pricing analytics, and data visualization skills.

Responsibilities

• Perform end-of-month price reporting and margin analysis.
• Update pricing data and price lists; manage GM% files.
• Develop and maintain PowerBI dashboards and SQL queries.
• Analyze competitor pricing and market trends to boost market share.
• Prepare internal analytics for price optimization decisions.
• Collaborate with Sales and Marketing on pricing strategies.

Skills

Power BI

SQL

Statistics

Pricing strategy

Data analysis

Excel

Salesforce

Education

Bachelor's degree in mathematics/ statistics/ finance

Master's in business administration advantageous

Tools

Tableau

Power BI

SAP

Job description

JOB DESCRIPTION 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.

Education

A Bachelor's degree in mathematics, statistics, finance, economics, or in a related field.

A Master's degree in business administration will be advantageous.

Experience

A minimum of two to four years' experience as a pricing analyst in a similar industry.

Experience in Chemical, Building Materials and/or Industrial Product industry experience preferred.

Skills and Abilities

• Proficiency in business intelligence (BI) software, such as PowerBI.
• Experience utilizing pricing in SAP advantageous.
• Experience working within Salesforce platform advantageous.
• In-depth knowledge of statistical methods and data analysis.
• Extensive experience in analyzing pricing strategies and forecasting revenue and market share.
• Experience in collaborating on pricing strategies with sales and marketing departments.
• Ability to keep abreast of industry trends and develop dynamic pricing tools.
• Advanced ability to present pricing analysis reports to relevant stakeholders.
• Excellent analytical and communication skills.

Other Qualifications

Ability to travel up to 15%

Additional Information: Primary Role (Summary)

• Improving data structures, integration between systems, data reliability/consistency for usage in pricing analytics
• Tracking Price realization, leakage and other related KPIs
• Supporting design and tracking of price approval process
• Supporting deal review and providing guidance and analytics on improving pricing/profitability
• Setting and tracking pricing policies, business rules and RACIs

Skills: Behavioral & Technical

• Profitability and growth orientation; does not hesitate in challenging sales force when required;
• Willingness and mindset to get into details
• Strong financial skills to utilize the decision support systems to interface with the sales and marketing organizations to drive specific action plans and programs
• Comfortable executing analyses independently in MS Excel
• Comfortable with independently accessing and running analyses on data directly from a database (e.g. via SQL)
• Experience with BI or dashboarding technologies (e.g. Tableau, Power BI) to independently build and manipulate fit-for-purpose reporting

Key Accountabilities / Essential Functions of the Job

• Supporting and refining existing price realization dashboards while spearheading monthly investigations into price performance and providing insights to Pricing Leader and other business leaders
• Identifying gaps in current data structures, closing these gaps in collaboration with other business functions
• Performing historical price analysis and transactional analysis to continuously track pricing discipline as well as potential for list price changes based on customer willingness to pay
• Support tracking of raw material inflation pass through and setting pricing targets working with Procurement, and Finance
• Support price list design changes and price setting analytics based on market dynamics, competitive intelligence, historical transactional data in collaboration with Product Marketing and Sales
• Support monitoring of pricing approvals and governance processes within the business

The salary range for applicants in this position generally ranges between $75,000 and $90,000. This range is an estimate, based on potential employee qualifications, operations, needs, and other considerations permitted by law.

Benefits

• health insurance
• paid holidays
• paid time off
• 401(k) with company match
• Company Pension Plan
• Performance Based Commission
• continuing education

Qualified applicants will receive consideration for employment without regard to their race, color, religion, national origin, sex, sexual orientation, gender identity, protected veteran status or disability.