**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 the backbone of arenaflex's retail merchandising operations. With a team of over 100 merchants and 40 planners, we're dedicated to optimizing the performance of our Front End (non-Pharmacy) businesses. Our team manages reporting, analysis, and tool building to support our merchants and planners in making data-driven decisions. As a Data Analyst on our team, you'll play a critical role in driving business growth and improving customer experiences through your analytical expertise.

• *Work Environment**

As a remote 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 9-hour day with a one-hour lunch break from 12 pm to 1 pm. While we're flexible with our hours, we require a minimum of 30 hours per week to fulfill our business needs.

• *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
• Item-level historical analysis and recapping
• Item-level future-looking forecast
• Managing thousands of Own Brand items at the item level
• Utilizing Microsoft Excel to analyze complex data sets and build analytical models
• Developing effective working relationships with Merchandising, Planning, Finance, and other stakeholders
• Communicating insights and recommendations through clear and concise reports and presentations
• Managing and prioritizing multiple assignments and meeting tight deadlines

• *Top Must-Have Skills**

To succeed in this role, you'll need:

• A Bachelor's Degree and at least 3-5 years of experience in analytics, data science, finance, financial analysis, assortment planning, retail, procurement/purchasing, or merchandising
• A strong understanding of retail merchandising basics, including category management 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 item-level forecasting based on demand patterns or sell-through/sales/profit goals
• Intermediate/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 will be beneficial:

• MBA or Science, Technology, Engineering, Mathematics (STEM) and/or other quantitative analytical degree
• Data science experience
• Retail experience
• SQL Coding, Microsoft Access, Macro building

• *Education / Experience Requirements**

We're looking for candidates with 3-5 years of experience in Analytics or Data Science, with a background in merchandising.

• *What We Offer**

As a Data Analyst on our team, you'll enjoy:

• A competitive salary and benefits package
• Opportunities for career growth and professional development
• A dynamic and supportive work environment
• Flexible work arrangements, including remote work options
• Access to cutting-edge tools and technologies
• Collaborative and innovative team culture

• *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 application through our website, and we'll be in touch to discuss your qualifications further.

• *Join arenaflex's Team**

At arenaflex, we're committed to creating a workplace that's inclusive, diverse, and supportive. We believe that our employees are our greatest asset, and we're dedicated to providing opportunities for growth and development. If you're looking for a challenging and rewarding career, we encourage you to join our team and be a part of our mission to revolutionize the retail pharmacy industry.