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

At arenaflex, we are a global leader in retail pharmacy, dedicated to delivering exceptional customer experiences and innovative solutions to the retail industry. As a key player in the retail pharmacy market, we are constantly seeking talented professionals to join our team and contribute to our mission of excellence. We are currently seeking an experienced Data Analyst to join our Merchandise Planning Analytics team on a 6-month contract with the opportunity for extension or conversion. This role will play a critical part in supporting our team of 100+ merchants and 40+ planners to optimize the performance of our Front End (non-Pharmacy) businesses. **Work Environment:** As a remote employee, you will have the flexibility to work from the comfort of your own home, while still being part of a dynamic and collaborative team. Our remote work environment is designed to foster productivity, creativity, and open communication. You will be expected to work in the Central Standard Time (CST) zone and maintain regular working hours of 8am-5pm, 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 in our Merchandise Planning Analytics team, you will be responsible for: * 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 complex Excel formulas and synthesizing large data sets into meaningful executive recaps * Collaborating with cross-functional teams, including Merchandising, Planning, Finance, and other stakeholders to drive business decisions * Communicating effectively and succinctly through written and verbal reports, using Microsoft PowerPoint and Excel **Top Must-Have Skills:** * Bachelor's Degree in a relevant field, such as 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, 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 * Effective communication and presentation skills, both verbally and in writing, using Microsoft PowerPoint * Ability to manage and prioritize multiple assignments and meet tight deadlines * Ability to develop effective working relationships with cross-functional teams * Retail math background, including item-level forecasting, sales by type, and AUR impacts * Intermediate to advanced level skill in Microsoft Excel, including SUM/SUMIFS, Subtotals, VLOOKUP, HLOOKUP, Macros, and Pivot tables **Top Nice-to-Have Skills:** * MBA or a Science, Technology, Engineering, Mathematics (STEM) degree * Data science experience * Retail experience * SQL coding, Microsoft Access, and Macro building skills **Education / Experience Requirements:** * 3-5 years of experience in analytics or data science, with a merchandising background **What We Offer:** * Competitive compensation and benefits package * Opportunity for career growth and professional development * Collaborative and dynamic work environment * Flexible remote work arrangement * Access to cutting-edge technology and tools * Recognition and rewards for outstanding performance **How to Apply:** If you are a motivated and detail-oriented individual with a passion for data analysis and retail merchandising, 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. We look forward to hearing from you! Apply Now! Apply for this job