Sales Data Analyst

Position Overview

Key Responsibilities

• Dashboard Development & Maintenance
• 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.
• Retail & Syndicated Data Pulls & Analysis
• Extract and cleanse data from Retailer portals (Retail Link, Partners Online, VIP, etc.).
• Syndicated sources (Circana/IRI, Nielsen, SPINS, 84.51°/Kroger Precision).
• Period-over-period, plan-vs-actual, and promo lift analysis.
• Flag outliers and reconcile discrepancies with account teams.
• Conduct ad hoc analysis and provide insights for key business questions.
• Trade Spend & ROI Analysis
• 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.
• Project Management & Cross-Functional Support
• 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.

Qualifications

• Education: Bachelor’s degree in Analytics, Business, Economics, Statistics, or related field.
• Experience: 2-4 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 Skills

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

Compensation

Base Salary: $105,000.00 - $115,000.00 per year
Annual Bonus: 5% of base salary, based on company and individual performance
Medical insurance
Dental insurance
Vision insurance
Wellness Program
401k Matching
HSA/FSA
LifeLock Identity Theft Protection
STD/LTD Life Insurance
Tuition Reimbursement
ESOP (Employee Stock Ownership Plan)
Equal Opportunity Employer: World’s Finest Chocolate is an equal opportunity employer and is committed to creating a diverse and inclusive workplace. We prohibit discrimination and harassment of any kind based on race, color, religion, sex, sexual orientation, gender identity, age, national origin, disability, veteran status, or any other protected characteristic as outlined by federal, state, or local laws. We celebrate diversity and are dedicated to providing an environment of respect and inclusivity for all employees.