Experienced Data Analyst – Retail Merchandising and Analytics

At arenaflex, we're on a mission to revolutionize the retail pharmacy industry by leveraging cutting-edge analytics and data-driven insights. As a global leader in retail pharmacy, we're committed to delivering exceptional customer experiences and driving business growth through innovative solutions. We're now seeking an experienced Data Analyst to join our Merchandise Planning Analytics team on a 6-month contract with the opportunity for extension or conversion.

About arenaflex's Merchandise Planning Analytics Team

Our Merchandise Planning Analytics team is a dynamic and collaborative group of professionals who are passionate about driving business growth through data-driven insights. We manage reporting, analysis, and tool building for the arenaflex Merchandising team, supporting over 100 merchants and 40 planners to optimize performance of our Front End (non-Pharmacy) businesses. Our team is responsible for providing actionable insights and recommendations to inform business decisions, drive revenue growth, and improve customer satisfaction.

Work Environment

As a remote Data Analyst, you'll have the flexibility to work from anywhere in the Central Standard Time (CST) zone. Our team is committed to maintaining a healthy work-life balance, and we offer a flexible schedule with a minimum of 30 hours per week. You'll work closely with our Merchandising, Planning, Finance, and other stakeholders to deliver high-quality results and meet tight deadlines.

Responsibilities

As a Data Analyst on our team, you'll be responsible for:

• Owning Brand (private label) reporting, recapping, tracking, and analysis, including ad-hoc analysis based on business needs
• Conducting item-level historical analysis and recapping
• Developing item-level future-looking forecasts
• Working with thousands of Own Brand items at the item level
• Utilizing Microsoft Excel to analyze complex data sets and build analytical models
• Communicating insights and recommendations to executive stakeholders via Microsoft PowerPoint
• Managing and prioritizing multiple assignments and meeting tight deadlines
• Developing effective working relationships with Merchandising, Planning, Finance, and other stakeholders
• Working independently and adapting to changing work priorities
• Analyzing retail math concepts, such as item-level forecasting based on demand patterns or sell-through/sales/profit goals
• Developing intermediate to advanced-level skills in Microsoft Excel, including SUM/SUMIFS, Subtotals, VLOOKUP, HLOOKUP, Macros, and Pivot tables

Top Must-Have Skills

To succeed in this role, you'll need:

• A Bachelor's degree in a quantitative field, such as analytics, data science, finance, financial analysis, assortment planning, retail, procurement/purchasing, or merchandising
• At least 3-5 years of experience in analytics, data science, or a related field, with a strong understanding of retail merchandising basics and merchandising organization structures and processes
• Outstanding analytical and problem-solving skills, paired with storytelling finesse
• Ability to conduct complex quantitative analysis and build analytical models using Microsoft Excel
• Ability to communicate effectively and succinctly both verbally and in writing via Microsoft PowerPoint
• Ability to manage and prioritize multiple assignments and meet tight deadlines
• Ability to develop effective working relationships with Merchandising, Planning, Finance, and other stakeholders
• Ability to work independently and adapt to changing work priorities
• Retail math background, including skills such as item-level forecasting based on demand patterns or sell-through/sales/profit goals
• Intermediate to advanced-level skill in Microsoft Excel, including SUM/SUMIFS, Subtotals, VLOOKUP, HLOOKUP, Macros, and Pivot tables

Top Nice-to-Have Skills

While not required, the following skills are highly desirable:

• MBA or a Science, Technology, Engineering, Mathematics (STEM) degree
• Data science experience
• Retail experience
• SQL coding, Microsoft Access, or macro building skills

Education / Experience Requirements

We're looking for candidates with 3-5 years of experience in analytics or data science, with a merchandising background.

What We Offer

As a Data Analyst at arenaflex, you'll enjoy:

• A competitive salary and benefits package
• Opportunities for career growth and professional development
• A dynamic and collaborative work environment
• Flexible work arrangements, including remote work options
• Access to cutting-edge tools and technologies
• A comprehensive training program to help you succeed in your role

How to Apply

If you're a motivated and analytical individual with a passion for retail merchandising and analytics, we encourage you to apply for this exciting opportunity. Please submit your resume and a cover letter outlining your experience and qualifications for the role. Apply for this job