Experienced Remote Data Analyst for Merchandise Planning and Analytics Team – Utilizing Advanced Excel Skills for Retail Business Optimization

Introduction to arenaflex

arenaflex is a global leader in retail pharmacy, dedicated to providing exceptional service and products to its customers. With a strong commitment to innovation and excellence, arenaflex is seeking a highly skilled Remote Analyst to join its Merchandise Planning Analytics team. This is a unique opportunity to work with a talented team of professionals who are passionate about optimizing business performance and driving success in the retail industry.

Job Summary

The Remote Analyst will play a critical role in supporting the Merchandising team by managing reporting, analysis, and tool building for the arenaflex Front End (non-Pharmacy) businesses. This is a 6-month contract position with the opportunity for extension or conversion, offering a chance to make a significant impact on the business and grow with the company.

Work Environment

The Remote Analyst will work 100% remotely, with a requirement to work in the Central Standard Time (CST) zone. The standard working hours are 8am-5pm, with a 9-hour day and a one-hour lunch break from 12pm-1pm. However, the hours can be flexible, with a minimum requirement of 30 hours per week to fulfill business needs.

Key Responsibilities

• Own 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
• Scope will include thousands of Own Brand items (at item level)
• Utilizing Excel as the primary system/tool, with a focus on complex Excel formulas and the ability to synthesize large data sets into meaningful executive recaps

Essential Qualifications

To be successful in this role, the Remote Analyst should possess the following essential qualifications:

• Bachelor's Degree and at least 3-5 years of experience in one or more of the following: analytics, data science, finance, financial analysis, assortment planning, retail, procurement/purchasing, merchandising
• Minimum 3 years of experience in data analytics or a related field, with a strong understanding of retail merchandising basics (i.e., category management) and merchandising organization structures and processes
• Outstanding analytical and problem-solving skills, partnered 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, with skills such as item level forecasting based on demand patterns or sell-through/sales/profit goals, knowledge of sales by type and AUR impacts, and all inventory and sales metrics
• Intermediate/Advanced level skill in Microsoft Excel (for example: using SUM/SUMIFS, Subtotals, VLOOKUP, HLOOKUP, Macros, Pivot tables) - CRITICAL SKILL NEEDED FOR ROLE, as most work will be done in Excel
• Intermediate level skill in Microsoft Word and PowerPoint

Preferred Qualifications

In addition to the essential qualifications, the following preferred qualifications will be considered an asset:

• MBA preferred; Science, Technology, Engineering, Mathematics, and/or other quantitative analytical degree a plus
• Data science experience
• Retail experience
• SQL Coding, Microsoft Access, Macro building

Career Growth Opportunities and Learning Benefits

At arenaflex, we are committed to the growth and development of our employees. As a Remote Analyst, you will have the opportunity to work with a talented team of professionals, develop your skills and expertise, and contribute to the success of the company. You will also have access to training and development programs, mentorship, and opportunities for advancement within the company.

Work Environment and Company Culture

arenaflex is a dynamic and innovative company that values its employees and is committed to creating a positive and inclusive work environment. As a Remote Analyst, you will be part of a team that is passionate about delivering exceptional results and making a difference in the retail industry. You will have the opportunity to work with a diverse group of professionals, collaborate on projects, and contribute to the company's mission and values.

Compensation, Perks, and Benefits

arenaflex offers a competitive compensation package, including a salary, benefits, and perks. As a Remote Analyst, you will have the opportunity to work from the comfort of your own home, with flexible hours and a healthy work-life balance. You will also have access to a range of benefits, including health insurance, retirement savings, and paid time off.

Conclusion

If you are a highly motivated and experienced data analyst looking for a new challenge, we encourage you to apply for this exciting opportunity at arenaflex. As a Remote Analyst, you will have the chance to work with a talented team of professionals, develop your skills and expertise, and contribute to the success of the company. Don't miss out on this opportunity to join a dynamic and innovative company that values its employees and is committed to delivering exceptional results. Apply now to become a part of the arenaflex team and take your career to the next level!