About This Role
This role is for a highly analytical and detail-oriented professional to transform sales, customer, product, pricing, distribution, and market data into actionable business insights. The analyst will be responsible for recurring performance reporting and ad hoc analysis for the National Accounts team, identifying trends and opportunities, and developing executive-ready and customer-facing presentations.
Responsibilities
- Analyze sales performance by customer, product, market, geography, and time period
- Prepare and maintain recurring reports and dashboards covering sales, distribution, pricing, inventory, market share, velocity, and other KPIs
- Clean, validate, import, and export data for Cognos and other reporting platforms
- Analyze IRI/Circana and Nielsen syndicated data to assess market share, distribution, pricing, promotions, competition, and category trends
- Conduct competitor, market, and category analysis to identify business opportunities and risks
- Perform post-promotional analysis, including sales lift, trade-spending effectiveness, and execution results
- Translate complex data into clear business insights, recommendations, and actionable next steps
- Create executive-ready and customer-facing presentations for customer reviews, annual planning, and category reviews
- Partner with Sales and cross-functional teams to address analytical requirements and support account strategies
- Develop and maintain standardized KPI definitions, reporting methodologies, and quality-control procedures
- Validate data, reconcile conflicting sources, identify anomalies, and resolve reporting discrepancies
- Improve dashboards, reporting processes, templates, and data quality controls
- Support AFS entry, promotional calendar maintenance, and other recurring sales-support activities as needed
Requirements
- Associate or Bachelor's degree in Business, Marketing, Finance, Analytics, Information Systems, or a related field
- At least 2 years of experience in business intelligence, sales analytics, category management, CPG, retail analytics, or a related field
- Advanced Microsoft Excel skills, including PivotTables, XLOOKUP/VLOOKUP, SUMIFS, nested formulas, charts, and large-data-set reconciliation
- Demonstrated experience with IRI/Circana and Nielsen syndicated data is highly preferred
- Strong knowledge of retail and Consumer Packaged Goods (CPG) analytics and performance metrics
- Experience with Cognos, VIP, retailer portals, Power BI, Tableau, or comparable BI/reporting platforms is an advantage
- Strong PowerPoint and business storytelling skills, with the ability to create executive-ready presentations
- Strong analytical, critical-thinking, problem-solving, and data-validation skills
