CORE Design Group

Data Analyst

• 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.
• 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.

Pricing and Data Analyst