Sales Data Analyst
World’s Finest Chocolate is seeking a Sales Data Analyst to support their North American retail sales organization. This role involves transforming raw sales data into actionable insights through dashboards and reporting, while also driving cross-functional projects from ideation to execution.
Responsibilities
- Build and refresh weekly/monthly Tableau (or Power BI) dashboards tracking: POS velocity, ACV distribution, % promo, share of shelf, Category growth vs. prior year / plan, Customer P&L summaries
- Automate data pipelines using Alteryx, Python, or native connector tools
- Utilize SQL to query and aggregate customer transaction data from a PostgreSQL database, identifying trends that informed marketing strategies
- Extract and cleanse data from: Retailer portals (Retail Link, Partners Online, VIP, etc.), Syndicated sources (Circana/IRI, Nielsen, SPINS, 84.51°/Kroger Precision)
- Perform period-over-period, plan-vs-actual, and promo lift analyses
- Flag outliers and reconcile discrepancies with account teams
- Conduct ad hoc analysis and provide insights for key business questions
- Maintain trade-spend tracker; calculate ROI, GMROI, and incremental lift for every door-level event
- Partner with Trade Marketing to recommend optimal spend mix (TPR, display, feature)
- Build post-event recaps within 5 business days of event close
- Lead analytics-driven projects (e.g., new item launch tracking, void closure initiatives, assortment optimization, JBP data room prep)
- Own JDA/Blue Yonder or internal planning templates for quarterly line reviews and JBP prep
- Define scope, timelines, milestones, and deliverables; run status meetings and drive stakeholder alignment
- Document processes and train account managers on self-service tools
Skills
- Bachelor's degree in Analytics, Business, Economics, Statistics, or related field
- 1–3 years in CPG sales analytics, revenue growth management, or category management
- Hands-on experience pulling data from retailer portals and syndicated sources (Circana, Nielsen, etc.)
- Proven ability to build dashboards in Tableau or Power BI
- Intermediate Excel (VLOOKUP, pivot tables, index/match); intermediate SQL skills
- 1+ years managing projects end-to-end (charter, timeline, status updates, stakeholder alignment)
- Familiarity with trade promotion management (TPM) tools or TPM ROI models
- Experience with workflow automation or ETL tools (e.g., Alteryx, Power Automate, Zapier, UiPath, or scripting)
- Strong storytelling with data; able to present to non-technical stakeholders
- Experience with Smartsheet, Asana, or Microsoft Project
Benefits
- Annual Bonus: 5% of base salary (based on company and individual performance)
- Full medical, dental, and vision insurance
- 401k Matching
- HSA/FSA & Wellness Programs
- Life & Disability Insurance (STD/LTD)
- Tuition Reimbursement
- LifeLock Identity Theft Protection
Company Overview
Company H1B Sponsorship