Job Description
At arenaflex, we're on a mission to revolutionize the retail pharmacy industry through innovative solutions and cutting-edge analytics. As a global leader in retail pharmacy, we're looking for a talented and driven Data Analyst to join our Merchandise Planning Analytics team. This is a unique opportunity to work remotely, develop your skills, and contribute to the success of our Front End (non-Pharmacy) businesses. About arenaflex arenaflex is a global leader in retail pharmacy, dedicated to providing exceptional customer experiences and innovative solutions to the healthcare industry.
Our Merchandise Planning Analytics team plays a critical role in supporting our merchants and planners to optimize performance and drive business growth. As a Data Analyst, you'll be part of a dynamic team that's passionate about data-driven decision-making and analytics. Work Environment As a remote Data Analyst, you'll have the flexibility to work from anywhere in the United States, with a focus on the Central Standard Time (CST) zone. Our team operates from 8am to 5pm, with a one-hour lunch break from 12pm to 1pm.
While we offer flexible hours, we require a minimum of 30 hours per week to fulfill business needs. This role is a 6-month contract with the opportunity for extension or conversion. Responsibilities As a Data Analyst, 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 * Working with thousands of Own Brand items at an item level * Utilizing bolthires Excel to analyze complex data sets and create meaningful executive recaps * Developing and maintaining complex Excel formulas and models * Communicating effectively with stakeholders through bolthires PowerPoint and written reports * 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 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 * Minimum 3 years of experience in data analytics or a related field, with a strong understanding of retail merchandising basics (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 bolthires Excel * Ability to communicate effectively and succinctly both verbally and in writing via bolthires 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, knowledge of sales by type and AUR impacts, all inventory and sales metrics * Intermediate/
Advanced level skill in bolthires Excel (e.g., using SUM/SUMIFS, Subtotals, VLOOKUP, HLOOKUP, Macros, Pivot tables) - CRITICAL SKILL NEEDED FOR ROLE, most work will be done in Excel * Intermediate level skill in bolthires Word and PowerPoint Top Nice-to-Have Skills While not required, the following skills are highly desirable: * MBA preferred; Science, Technology, Engineering, Mathematics, and/or other quantitative analytical degree a plus * Data science experience * Retail experience * SQL Coding, bolthires Access, Macro building Education / Experience Requirements To be considered for this role, you'll need: * 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 supportive work environment * Flexible remote work arrangements * Access to cutting-edge technology and tools * Collaborative and innovative team culture * Recognition and rewards for outstanding performance If you're a motivated and detail-oriented Data Analyst 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. We can't wait to hear from you!