Category Insights Analyst: Drive Retail Growth with Data

ADP, Inc.; Warminster Township (Bucks County); On-site; USD 65,000 - 90,000; Full time

Benefits offered by this job

Health Reimbursement Account

401(k) Plan with company match

Generous Paid Time Off

Employee Assistance Program

Tuition Reimbursement

Training and Development

Short / Long Term Disability

Life Insurance

KASHABLE loan program

Free garden vegetables from our farm (

Job summary

Burpee is seeking a Category Insights Analyst to become the go-to expert for customer analysis and selling stories. You will translate category trends and POS data into actionable tactics that drive sales and profitability, collaborating with cross-functional partners.

You will build dashboards for U.S. Retail, eCommerce, and Canada, develop semantic models in Power BI with a Data Engineer, and perform profitability-based sell-through analyses.

Qualifications

• Bachelor's degree in Business, Analytics, Data Science, or related field.
• 3+ years of experience in retail sales or business analytics.
• Advanced Power BI and dashboard development skills.
• Strong data analysis skills including SKU, assortment, and profitability analysis.
• Experience with retailer/vendor data platforms (Scintilla, Nielsen, Circana/IRI, etc.).
• Strong communication and cross-functional collaboration skills.

Responsibilities

• Generate content from data analytics to support customer line review presentations.
• Ingest Weekly Vendor Portal Data for auditing; segment tracking.
• Provide sales team with ad hoc analytical support.
• Create dashboards to analyze business units - U.S. Retail Sales, eCommerce, Canada.
• Build Semantic Models in Power BI collaborating with Data Engineer to produce DataMart where necessary.
• Optimal sell-through analytics by customer based on profitability.
• Data reporting - analyze retail sales, cross functional support, and translate it into actionable insights to drive sales.
• Category Performance - category metric reporting (category, segment, brand performance, and indexing).
• Retailer Insights - retailer objectives, trends, and category contribution.
• Build strong relationship with retail customer leaders.
• Use Scintilla to drive sales through store and item-level analysis, identify market innovations, monitor nil picks, and build competitive tracking tools for the sales team.

Skills

Power BI

Data analysis

Retail analytics

Collaboration

Dashboard development

SQL

Education

Bachelor's degree in Business, Analytics, Data Science, or related field

Tools

Scintilla

Nielsen

Circana/IRI

Job description

Burpee is seeking a Category Insights Analyst to become the go-to expert for customer analysis and selling stories. You will translate category trends and POS data into actionable tactics that drive sales and profitability, collaborating with cross-functional partners.

You will build dashboards for U.S. Retail, eCommerce, and Canada, develop semantic models in Power BI with a Data Engineer, and perform profitability-based sell-through analyses.