Merchandising Analyst - Pittsburgh, PA Metro

Merchandising Analyst - Pittsburgh, PA Metro – Remote at UNFI

The Merchandising Analyst will use financial targets and competitive data to provide business insights and recommendations to improve sales, operations and profitability for markets and categories. The analyst communicates analysis using comprehensive, easy to digest methods that translate into impactful and actionable reports for category leadership.

• Provides business, customer insights and competitor intelligence to support the development of category strategies, forecasts and performance reporting
• Identifies and validates opportunities within a given category, market or division using category roles, competitive pricing, frequency reports, elasticity reports, market data and many other sources
• Provides analytical and quantitative secondary research support to the business by accessing, verifying and organizing market trend, competitive intelligence and sales data using a variety of sources such as Data Warehouse, Nielsen and IRI syndicated data
• Plans and executes data mining, trend analysis, and ad hoc data analysis activities, which will include a strong focus on operations and sales studies to identify alternatives of doing business to improve business practices, efficiencies, and profitability
• Collaborates with merchandising team to develop and implement base pricing strategies, rules, and parameters
• Interpret trends and spot opportunities to improve sales and profitability
• Conducts special merchandising and business-related research and cooperates with other departments in the preparation of analysis
• Monitors and tracks vendor decisions, compliance, and performance. Works with vendors to identify category opportunities and track performance against category business plans and store execution opportunities
• Reviews and analyzes processes and contributes to making them efficient to reduce costs
• Compiles, develops and prepares reports, graphs and charts of findings
• Maintains pricing/sales system information to ensure that performance reporting contains accurate information
• Develops tools to provide forecasts and projections for sales and margin management and utilizes the tools to identify opportunities to improve margin and track margin performance to annual operating plan targets
• Updates and reviews all key promotional pricing metrics and prepares recommendations for action as needed
• Provides data, support, reporting and analysis for trimester planning
• Tracks results at end of each promotion in terms of sales, profit and share growth or contribution
• Maintains weekly, quarterly and yearly scorecards to track sales, gross profit dollars and share of each category
• Coordinates promotional plans (ads and displays), and merchandising messages within department as assigned by management
• Maintains regular scorecards to track sales, gross profit dollars, expense reduction or other projected benefits of implemented improvement initiatives
• As an ongoing effort, will work with management and IS on automating performance metrics, audit reports, and pricing programs that currently are managed and maintained manually
• Performs other duties as assigned

Bachelor’s Degree in Business, Marketing, Communications, Finance, Accounting or related field

3+ years of analytical experience in category management, retail or wholesale general business or financial analysis experience required

• SQL, VBA, Alteryx knowledge a plus
• Knowledge of Nielsen and IRI data sources and their application a plus
• Skilled with Microsoft Office products (Excel, Word, Access, PowerPoint)
• Ability to work independently in a fast-paced environment
• Ability to work across vast amounts of data from different data sources
• Strong quantitative skills, with the ability to compile and analyze data
• Strong written, verbal, and interpersonal communication skills
• Strong math and analytical skills
• Must be systems-oriented, enjoy work with new tools, and be a self-motivated and detail-oriented learner
• Ability to present results of analysis, data models, and other projects to management in a concise and professional manner
• Good judgment is required for this position as there may be times when direct supervision may not be immediately available

This position is classified as remote where the associate will perform remote work from their primary residence. Remote associates are welcome to work from the office but are not required to do so. While remote associates are not required to work from an office on a regular basis, they may be required to come to the office or other UNFI locations for necessary business reasons or if directed to do so by their manager.

This position may require the associate to travel to company offices, distribution centers, or other locations for specific meetings or other business reasons.

• Most work is performed in a…