Sales Data Analyst

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