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 customer experiences and optimizing business performance. Our Merchandise Planning Analytics team plays a crucial role in supporting our merchandising team, comprising over 100 merchants and 40 planners, to drive the success of our Front End (non-Pharmacy) businesses. We are now seeking a highly skilled Remote Analyst to join our team on a 6-month contract, with opportunities for extension or conversion to a permanent role. Job Summary The Remote Analyst will be responsible for managing reporting, analysis, and tool building for the arenaflex Merchandising team. This role will involve working closely with our team of merchants and planners to optimize business performance, with a focus on Own Brand (private label) reporting, recapping, tracking, and analysis. The successful candidate will have a strong background in analytics, data science, or a related field, with excellent analytical and problem-solving skills, and the ability to communicate complex data insights effectively. Work Environment As a Remote Analyst, you will work 100% remotely, with a requirement to work in the Central Standard Time (CST) zone. Your working hours will be 8am-5pm, with a 9-hour day and a one-hour lunch break from 12pm-1pm. While flexibility is offered, you must be available to work a minimum 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) Utilization of Excel as the primary system/tool, with complex Excel formulas and the ability to synthesize large data sets into meaningful executive recaps Essential Qualifications To be considered for this role, you must have: A 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 While not essential, the following qualifications are highly desirable: 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 in analytics and data science, and contribute to the success of our business. You will also have access to training and development programs, designed to help you achieve your career goals and advance in your career. Work Environment and Company Culture arenaflex is a dynamic and innovative company, with a strong focus on teamwork, collaboration, and customer satisfaction. Our company culture is built on values of integrity, respect, and excellence, and we are committed to creating a positive and inclusive work environment for all employees. As a Remote Analyst, you will be an integral part of our team, working closely with colleagues across different functions and departments to drive business success. Compensation, Perks, and Benefits arenaflex offers a competitive compensation package, with a range of perks and benefits designed to support the well-being and success of our employees. These may include health insurance, retirement plans, paid time off, and opportunities for professional development and growth. Conclusion If you are a highly motivated and experienced analytics professional, with a passion for data science and retail, we encourage you to apply for this exciting opportunity to join our team as a Remote Analyst. With your skills and expertise, you will play a critical role in driving business success and optimizing performance for our Front End (non-Pharmacy) businesses. Apply now to take the first step in your career with arenaflex and discover a world of opportunities and growth. Apply for this job