North America Sales Strategy & Analytics Analyst
$55,000–$83,000 year
HybridColumbus, Ohio, United States
Job Summary
Consolidate weekly, monthly, and quarterly sales data on KPIs including forecast vs. actuals, top doors, SKUs, inventory levels, and shipments. Produce sell-in and sell-out reports for leadership review while validating data quality and escalating discrepancies. Support NA sales forecasting processes by performing ad-hoc variance analysis and coordinating planning calendar activities. Consolidate retailer performance metrics for partners like Ulta, Sephora, Amazon, and TikTok Shop to track market share and inventory trends. Maintain the Alloy system by executing data validation, monitoring dashboard accuracy, and documenting best practices. Collaborate with sales, supply chain, and finance teams to gather data and support visualization for leadership meetings.
Required Qualifications
- Bachelor's degree in Business, Finance, Economics, Analytics, or related field
- 1-3 years of professional experience in corporate strategy, sales analytics, business intelligence, financial analysis, or related analytical role
- Familiarity with data visualization tools (Power BI) and dashboard concepts
- Microsoft Excel proficiency, including intermediate-to-advanced functions (pivot tables, VLOOKUP, basic data modeling, formulas)
- Ability to navigate reporting modules and pull data
- Experience working with or viewing dashboards in Tableau, Power BI, or equivalent BI tools
- Proficiency with PowerPoint for creating clear, professional reports and presentations
- Exceptional attention to detail and strong commitment to data accuracy and integrity
- Strong analytical thinking; ability to work with complex datasets and identify patterns or discrepancies
- Clear written and verbal communication skills; ability to explain technical findings to non-technical stakeholders
- Collaborative and proactive team player; comfortable seeking guidance and escalating issues appropriately
- Strong organizational skills and ability to manage multiple tasks and priorities
- Eagerness to learn new tools, systems, and analytics methodologies; self-directed learner
Desired Qualifications
- Experience with Alloy or similar modern analytics platforms
- Background in beauty, retail, or CPG industry
- Familiarity with sales forecasting concepts and revenue planning processes
- Experience with data warehousing
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.