Pricing and Data Analyst

York Design Group•York, PA

10h•Onsite

About The Position

This is a highly analytical role that develops predictive commercial analytics that identify leading indicators of sales declines, customer attrition, pricing erosion, customer agreements (Rebates & Allowances), inventory constraints, and margin compression, enabling proactive action by Sales and Leadership and support business decision-making.

Requirements

Bachelor’s degree in Business, Analytics, Data Science, Economics, or related field (Master’s preferred).
5–10+ years of experience in pricing, sales analytics, or customer insights.
Proven experience using AI/ML tools and modern analytics platforms (e.g., Python, SQL, Power BI, Tableau, or similar).
Strong understanding of pricing strategy, demand forecasting, and customer segmentation.
Exceptional ability to translate data into business insights and executive-level communication.
Demonstrated ability to build automated dashboards and alert systems.

Nice To Haves

Experience in manufacturing, consumer goods, or e-commerce preferred.

Responsibilities

Define, monitor, and optimize key pricing and commercial KPIs, including price realization, margin performance, volume growth, mix, and customer profitability.
Conduct Price-Volume-Mix (PVM) analysis to identify drivers of revenue and margin performance.
Monitor pricing compliance, discounting trends, promotional effectiveness, and price leakage across all sales channels.
Develop competitive pricing intelligence by channel and recommend pricing actions based on market trends.
Develop leading indicators and early warning metrics to identify risks before they impact sales or profitability.
Analyze sales trends, customer behavior, and channel performance to identify opportunities and emerging risks.
Identify declining customers, order frequency changes, reduced average order size, and other indicators requiring commercial action.
Partner with Sales leadership to prioritize accounts requiring intervention based on predictive analytics.
Monitor designer acquisition, activation, and retention metrics.
Analyze repetitive ordering patterns, dormant designers, and customer lifecycle trends.
Evaluate book/sample productivity and conversion rates.
Track average unit sales, project frequency, and customer profitability.
Analyze Paint & Wall Retailer performance, identifying growth opportunities and declining trends.
Develop channel-specific scorecards for eCommerce and National Accounts.
Monitor sales trends, conversion, assortment performance, customer purchasing behavior, and profitability.
Analyze fill rates, backorders, inventory constraints, and service levels.
Measure promotional effectiveness and pricing performance by account.
Own rebate and allowance reporting and weekly scorecards.
Compare deductions against customer agreements to identify discrepancies.
Investigate overages and partner with Operations, Sales, Customer Service, and Finance to determine root causes and corrective actions.
Monitor trade spend effectiveness and customer profitability.
Develop sales forecasts by customer, channel, and product category.
Support annual operating plans, budgeting, and demand planning.
Identify forecast variances and recommend actions based on changing market conditions.
Build and maintain automated dashboards and executive scorecards.
Develop self-service reporting tools that improve visibility into commercial performance.
Ensure data accuracy, governance, and consistency across ERP, CRM, and reporting platforms.
Translate complex data into actionable recommendations for executive leadership.
Partner with Sales, Marketing, Finance, Operations, Supply Chain, and Customer Service to improve business performance.
Present business insights and recommendations to senior leadership.
Support strategic initiatives through financial modeling, scenario analysis, and profitability assessments.
Drive continuous improvement in reporting processes and analytical capabilities.