Overview
The organization is seeking a Pricing & Merchandising Data Solutions Analyst to compile, analyze, and manage pricing and merchandising-related data, support analytics needs across multiple teams, and help drive decision-making using advanced analytics and reporting.
Base Pay Range: $80,000 - $90,000
Responsibilities
Data Management
- Compile and analyze pricing, merchandising, and AOR-related data.
- Audit and analyze large data sets to ensure accuracy.
- Use new and existing technologies efficiently to identify trends and make recommendations (including, but not limited to: data warehouse solutions, Alteryx, Snowflake, R-Studio, Excel, VBA, SQL Server Management Studio).
- Identify components of problems and apply appropriate analytics techniques to create solutions.
Analytics & Strategy
- Support Pricing, Merchandising, AOR, and Finance teams with advanced analytics; if assigned, provide support for additional family companies.
- Assemble, manage, and distribute operational reports and metrics, including interpretations of results and suggested actions.
- Use data and analytics to help achieve annual revenue and margin targets.
- Collaborate with teams including Supply Chain, Sales, Program Management, IT, and Marketing to develop solutions.
- On an ad-hoc basis, provide support and analysis to Finance, Program Management, Sales, Supplier Relations, and Inventory Management.
- Streamline data analytics and processes in collaboration with others to ensure a consistent approach and strategy.
Financial Analysis
- Maintain/create tools that accurately represent profitability in various ways for Pricing, Merchandising, and AOR.
- Analyze gross margin and revenue impact of recommendations made to Pricing, Merchandising, and AOR teams.
Other Duties
- Perform other duties as assigned.
Requirements
- Bachelor’s degree in a Business, Finance, Economics, Statistics, or business-related field required.
- Minimum of 2-4 years’ experience in a technical role focused on performance analytics, financial analysis, pricing/product analysis, or other related business field.
- Intermediate to advanced skills using Excel and PowerBI required; experience with Alteryx or other analytic process automation software preferred.
- Proficiency in MS Excel, Database, VBA, and SQL.
- Strong proficiency in analytical tools (e.g., Alteryx, SQL, Python) and visualization platforms (e.g., PowerBI, Tableau).
- Expertise with statistics, data modeling, and manipulation of large data sets.
- Strong attention to detail, organizational skills, interpersonal skills, and verbal and written communication.
- Strong problem-solving and time management skills.
- Ability to develop and maintain complex databases.
- Strong analytical ability to gather, analyze, and evaluate information and translate concepts into financial/operational models.
- Basic knowledge and understanding of business and finance/accounting.
- Excellent interpersonal, communication, and organizational skills with ability to succeed in a cross-functional working environment.
Preferred Qualifications
- Experience with Alteryx or other analytic process automation software.
Compensation & Benefits
- Base Pay Range: $80,000 - $90,000
- Compensation may also include commission, bonus, or profit sharing (based on qualifications, experience, and geographic location).
- Benefits may include:
- Paid time off
- Medical, dental, and vision
- 401k match (50% on the dollar up to 7% of employee contribution)
Location
Cleveland, OH (established in 1918 in Cleveland, OH)
Physical Job Requirements
- Sitting for long periods of time.
- Continuous viewing and inputting data into a computer screen.
- Travel domestically as required.
Additional Information
- Drug policy: drug-free environment; candidates considered for employment must pass a pre-employment drug screening before beginning work.
- This position is targeted to be closed on 2026-10-30.
- Equal Employment Opportunity employer (no discrimination on protected status under applicable law).
ADA Disclosure
Candidates who may need an accommodation to complete the application based on the impact of a disability should contact Human Resources to discuss specific needs.