Associate Manager, Merchandising Analytics
Company: KeHE
Category: Professional Services
Hybrid, Naperville
Type: Full Time
KeHE seeks an Associate Manager, Merchandising Analytics to join their team. The Associate Manager, Merchandising Analytics plays a pivotal role in transforming data into strategic insights that inform and influence merchandising decisions. This role bridges the gap between business strategy and analytics by developing advanced dashboards, automated reports, and data solutions that align with key business priorities. The ideal candidate is a proactive problem-solver with strong analytical and technical skills, has a keen eye for data visualization, and the ability to clearly communicate complex data to stakeholders at all levels. Salary range is $95,700 – $114,490. Benefits: health/Rx, dental, vision, flexible and health spending accounts (FSA/HSA), supplemental life insurance, 401(k), paid time off, paid sick time, short term & long-term disability coverage (STD/LTD), employee stock ownership (ESOP), and holiday pay for company designated holidays. Responsibilities:
- Transform Business Needs into Technical Solutions:Â Work closely with stakeholders to translate business requirements into clear technical specifications and implement scalable, repeatable analytics solutions.
- Design & Deliver Actionable Dashboards:Â Build and maintain advanced Power BI dashboards and paginated reports that provide clear insights into merchandising, supplier, item, and promotional performance.
- Data Modeling & Optimization:Â Create and optimize semantic data models using star schemas and relationships that support efficient DAX calculations and self-service reporting.
- SQL-Based Data Analysis:Â Write and maintain complex SQL queries to extract, clean, and analyze data from multiple sources (including data marts, warehouse systems, and Excel) to support category, brand, and supplier reviews.
- Data Quality & Validation:Â Implement automated checks, exception reporting, and audit processes to ensure data accuracy, completeness, and trustworthiness in reporting.
- Automation & Process Improvement:Â Leverage Power Query, VBA, Python, and Report Builder to automate recurring reports and streamline manual workflows across the Merchandising organization.
- Stakeholder Collaboration: Partner with cross-functional teams—Merchandising, Sales, Supply Chain, IT, and Leadership—to align on KPIs, improve data governance, and deliver timely analytics.
- Training & Adoption Support:Â Create documentation, job aids, and lead user training sessions to promote adoption of dashboards and self-service BI tools.
- End-to-End Project Ownership:Â Manage the full lifecycle of analytics projects, from discovery and prototyping through testing, deployment, and ongoing refinement based on user feedback.
- Continuous Learning:Â Stay up to date on Power BI features, Microsoft platform innovations, SQL performance tuning strategies, and best practices in CPG analytics.



