Analyst, II - Merchandise Analytics

Essendant is a purpose-driven company that reaches beyond business goals to define its success within commerce today. We support our associates, customers and communities – our core values and guiding principles shape what we aspire to do. Integrity, Collaboration, Customer-Centric, Embrace and Drive Change are our core values that serve as the foundation of our pathway to success. Diversity, Equity & Inclusion, Giving Back, Associate Safety, and Accountability are our guiding principles that motivate us to focus on creating a safe and rewarding experience. Essendant is a leader in supporting the supply chain industry and has been in business for 100 years to deliver the best practices for our customers and associates. Join us at Essendant, the better way to commerce.

Major Responsibilities:

Analytics: 

• Analyze SKU-level and supplier-level performance within a set of merchandise categories. This includes, but is not limited to category trends, key supplier dynamics, EBITDA economics at the SKU level, historical evolution of cost and margins 
• Provide market and industry insights on top performing items purchased in the market and by customers 
• Perform competitive benchmarking (assortment, SKU distribution) in specific product categories 
• Identify cost and margin opportunities across SKUs and suppliers (e.g., cost gaps, profit gaps, productivity gaps) and guide Merchants in prioritizing for impact
• Execute "what if" scenarios on proposed assortment changes or share shifts before completing assortment decisions, partnering with Inventory, Pricing, Sales & Marketing 
• Craft analytical materials to be shared with suppliers during supplier negotiations, category reviews and assortment discussions 

Item lifecycle management: 

• Develop criteria for adding new items; Provide oversight for execution of process 
• Reporting on new item performance and monthly / quarterly discontinuation review process (ongoing “tail trimming”). Provide project management to ensure execution of process 

Other: 

• Work on special projects, ad hoc analysis, and initiatives related to assortment performance and COGS management 
• Understands and demonstrates Essendant's Core Values 
• Performs other duties as assigned 

Skills/Knowledge:

• Understanding of Merchandising business processes and their influence on organizational performance and profitability is preferred 
• Solid analytical and problem-solving skills required
• Strong Financial skills required, including the ability to gather, analyze and organize complex data, and draw conclusions 
• Proficient verbal and written communication skills required (effectiveness with PowerPoint a plus) 
• Strong project management skills preferred 
• Ability to prioritize and manage multiple assignments and meet tight deadlines required 
• Ability to work cross-functionally and build & maintain effective relationships particularly with Merchant teams required 
• Strong attention to detail required 
• Expert abilities in Microsoft Office Suite software including MS Excel and PowerPoint, and Word. 
• Expert knowledge of business intelligence tools and languages required, preferably SQL, Power BI, OLAP, Power Pivot, Snowflake

Education and Experience:

• Bachelor’s Degree required, preferably in Finance, Mathematics, or related quantitative discipline. 
• 2 – 5 years of applicable work experience preferred. 
• Financial or Merchandising analysis experience preferred.
• Experience presenting to groups and senior management. 

Benefits:

• Health benefits (Medical, Dental, Vision)
• 401k with matching
• Company Holidays
• Overtime Pay for hourly employees
• Paid Vacation, Floating Holidays, and Sick Time
• Maternity and Parental leave benefits
• Employee discount
• Tuition Reimbursement
• Employee Assistance Program

Essendant drives to be inclusive and celebrates diversity by starting with our associates. We are an Equal Employment Opportunity employer that is committed to building a diverse and inclusive environment. We strongly encourage candidates to apply for opportunities, even if you do not believe you meet every one of the qualifications described. At Essendant we are building an elevated community by creating a safe and supportive work environment. We prohibit discrimination and harassment of any kind, including or based on age, race, color, disability, ancestry, religion, sex, gender identity or expression, sexual orientation, pregnancy, marital status, national origin, protected veteran status, or any other characteristic protected by federal, state, or local laws. People are what drives our company. We are one team with endless possibilities. We are Essendant.

ABOUT ESSENDANT