World's Finest® Chocolate→
Sales Data Analyst
Entry LevelHybrid
Location
Chicago, IL
Salary
$105k–$115k/yr
Experience
Not specified
Posted
1 day ago
Skills
excelsqltableaupower bialteryxpythonpostgresqlretailer portalssyndicated data sourcestrade promotion managementetl toolssmartsheetasanamicrosoft projectdata storytellingproject management
Job Description
Summary: 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
Required Qualifications:
- 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)
Preferred Qualifications:
- 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
Required Skills: Excel, SQL, Tableau, Power BI, Alteryx, Python, PostgreSQL, Retailer Portals, Syndicated Data Sources, Trade Promotion Management, ETL Tools, Smartsheet, Asana, Microsoft Project, Data Storytelling, Project Management
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
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