**Experienced Data Analyst – Retail Merchandising and Analytics**

At arenaflex, we're on a mission to revolutionize the retail pharmacy industry with cutting-edge solutions and innovative approaches. As a global leader in retail pharmacy, arenaflex is committed to delivering exceptional customer experiences and driving business growth through data-driven insights. We're now seeking an experienced Data Analyst to join our Merchandise Planning Analytics team for a 6-month contract with the opportunity for extension or conversion. **About the Role:** The Merchandise Planning Analytics team at arenaflex is responsible for managing reporting, analysis, and tool building for the arenaflex Merchandising team. Our team supports a diverse group of 100+ merchants and 40+ planners to optimize performance of the arenaflex Front End (non-Pharmacy) businesses. As a Data Analyst, you will play a critical role in driving business growth by providing actionable insights and recommendations to our stakeholders. **Work Environment:** As a remote employee, you will have the flexibility to work from anywhere in the Central Standard Time (CST) zone. Our team operates on a standard 8am-5pm schedule with a one-hour lunch break from 12pm-1pm. While we understand the importance of work-life balance, we require a minimum of 30 hours per week to fulfill the business needs of our team. **Responsibilities:** As a Data Analyst, your key responsibilities will include: * 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 * Managing and analyzing thousands of Own Brand items at the item level * Utilizing Microsoft Excel to build complex formulas and synthesize large data sets into meaningful executive recaps * Collaborating with stakeholders to provide actionable insights and recommendations * Developing effective working relationships with Merchandising, Planning, Finance, and other stakeholders * Managing and prioritizing multiple assignments and meeting tight deadlines **Top Must-Have Skills:** To succeed in this role, you will need to possess the following skills: * 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 other related fields 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; skills such as 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 Microsoft Excel (for example: 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 Microsoft Word and PowerPoint **Top Nice-to-Have Skills:** While not required, the following skills would be beneficial for this role: * 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 **Education / Experience Requirements:** To be considered for this role, you will need to have: * 3-5 years of experience in Analytics or Data Science, Merchandising background **What We Offer:** As a Data Analyst at arenaflex, you will have the opportunity to work on exciting projects, develop your skills, and grow your career. We offer a competitive compensation package, including: * Competitive salary * Comprehensive benefits package * Opportunities for professional growth and development * Collaborative and dynamic work environment * Flexible work arrangements **How to Apply:** If you're a motivated and detail-oriented individual with a passion for data analysis, 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 Now! Apply for this job