
Associate Manager, Merchandising Analytics
- Naperville, IL
- $95,700-127,490 per year
- Permanent
- Full-time
- Full-time
- Pay Range: $95,700.00/Yr. - $127,490.00/Yr.
- Shift Days: , Shift Time:
- Benefits on Day 1
- 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)
- Holiday pay for company designated holidays
- Translate business requirements into actionable technical specifications, timelines, and scalable BI solutions.
- Aggregate, analyze, and visualize data to support strategic planning, performance tracking, and accountability across Merchandising.
- Design, build, and maintain advanced Power BI dashboards, reports, and data models that offer clear and impactful business insights.
- Ensure data quality and accuracy through automated validation checks, data audits, and exception reporting.
- Optimize data models using relational structures (e.g., star schema) to improve performance and scalability.
- Troubleshoot and resolve issues related to BI dashboards, data refreshes, or underlying data integrity.
- Drive automation of routine merchandising functions, supporting broader business transformation and process improvement initiatives.
- Build and maintain strong cross-functional partnerships (e.g., with Merchandising, Supply Chain, Sales Operations, IT) to improve data governance, accessibility, and analytical alignment.
- Develop user training materials and lead knowledge-sharing sessions to drive BI tool adoption and self-service capabilities.
- Provide hands-on support throughout the full project lifecycle—from discovery and requirements gathering to deployment and post-launch optimization.
- Stay current with emerging BI technologies, analytics trends, and tools to continuously enhance team capabilities and output.
- Strong analytical thinking and technical aptitude, with a clear understanding of business processes and systems.
- Ability to translate business questions into data-driven solutions and communicate findings to both technical and non-technical audiences.
- Proficiency in BI tools such as Power BI, Tableau, or Qlik.
- Hands-on experience creating interactive dashboards, writing DAX measures, and implementing row-level security in Power BI.
- Strong SQL and DAX skills and familiarity with R or Python.
- Solid understanding of UX/UI principles as they apply to dashboard and report design.
- Experience with SSRS.
- Experience with data modeling, data warehouses (Snowflake, Redshift, etc.), and ETL pipelines.
- Advanced Excel skills, including PivotTables, VLOOKUP/XLOOKUP, and VBA.
- Highly detail-oriented with a strong sense of ownership, urgency, and accountability.
- Excellent verbal and written communication skills.
- Collaborative, resourceful, and adaptable team player who thrives in a dynamic environment.
- Excellent communication, project management skills with the ability to manage multiple projects and prioritize workload effectively.
- Willingness to travel occasionally for in-person collaboration or team meetings.
- Bachelor’s degree in Computer Science, Data Analytics, Information Systems, or related field
- 3-5 years of experience using BI tools in a business-facing analytics or data visualization role.
- These physical demands are representative of the physical requirements necessary for an employee to successfully perform the essential functions of the job.