**Experienced Entry-Level Data Analyst – Retail Merchandising and Analytics**

At arenaflex, we're on a mission to revolutionize the retail pharmacy industry with cutting-edge analytics and data-driven insights. As a global leader in retail pharmacy, arenaflex is constantly seeking innovative solutions to optimize performance and drive business growth. We're now looking for an experienced Entry-Level Data Analyst to join our Merchandise Planning Analytics team on a 6-month contract with the opportunity for extension or conversion. **About arenaflex's Merchandise Planning Analytics Team** arenaflex's Merchandise Planning Analytics team is a dynamic and fast-paced group that manages reporting, analysis, and tool building for the arenaflex Merchandising team. With a team of over 100 merchants and 40+ planners, we support the optimization of performance for arenaflex's Front End (non-Pharmacy) businesses. Our team is passionate about leveraging data and analytics to drive business decisions and drive growth. **Work Environment** As a Remote Analyst at arenaflex, you'll have the flexibility to work from anywhere in the Central Standard Time (CST) zone. Our team is fully remote, and we're committed to creating a collaborative and inclusive work environment that fosters open communication and teamwork. You'll work a standard 8am-5pm schedule with a one-hour lunch break from 12pm-1pm. While our hours are flexible, we require a minimum of 30 hours per week to fulfill business needs. **Responsibilities** As an Entry-Level Data Analyst, you'll be responsible for: * **Own Brand Reporting and Analysis**: Own and manage reporting, recapping, tracking, and analysis for thousands of arenaflex's private label items, including ad-hoc analysis based on business needs. * **Item Level Historical Analysis and Recapping**: Conduct item-level historical analysis and recapping to identify trends and patterns. * **Item Level Future Looking Forecast**: Develop and maintain item-level future-looking forecasts to inform business decisions. * **Complex Excel Formulas and Data Synthesis**: Utilize complex Excel formulas to synthesize large data sets into meaningful executive recaps. * **System/Tool Used**: Work primarily in Microsoft Excel, with occasional use of other tools and software. **Top Must-Have Skills** To succeed in this role, you'll need: * **Bachelor's Degree and Relevant Experience**: A Bachelor's degree in a quantitative field (e.g., analytics, data science, finance, financial analysis, assortment planning, retail, procurement/purchasing, merchandising) and at least 3-5 years of experience in one or more of these fields. * **Data Analytics and Retail Merchandising Background**: A strong understanding of retail merchandising basics, including category management and merchandising organization structures and processes. * **Analytical and Problem-Solving Skills**: Outstanding analytical and problem-solving skills, paired with storytelling finesse to communicate complex ideas to stakeholders. * **Microsoft Excel and PowerPoint Skills**: Intermediate to advanced level skills in Microsoft Excel, including complex formulas, pivot tables, and data visualization. Strong communication skills in Microsoft PowerPoint. * **Time Management and Prioritization**: Ability to manage and prioritize multiple assignments and meet tight deadlines. * **Stakeholder Management**: Ability to develop effective working relationships with Merchandising, Planning, Finance, and other stakeholders. * **Retail Math Background**: Retail math background, including item-level forecasting, demand patterns, sell-through, sales, profit goals, sales by type, and AUR impacts. * **Microsoft Excel Critical Skill**: Intermediate to advanced level skill in Microsoft Excel, including SUM/SUMIFS, Subtotals, VLOOKUP, HLOOKUP, Macros, and Pivot tables. **Top Nice-to-Have Skills** While not required, the following skills are highly desirable: * **MBA or Quantitative Degree**: MBA or a degree in a quantitative field (e.g., Science, Technology, Engineering, Mathematics). * **Data Science Experience**: Experience in data science, including data modeling, machine learning, and statistical analysis. * **Retail Experience**: Retail experience, including merchandising, planning, or analytics. * **SQL Coding and Macro Building**: Intermediate level skill in SQL coding and macro building in Microsoft Access. **Education and Experience Requirements** To be considered for this role, you'll need: * **3-5 Years of Experience**: At least 3-5 years of experience in analytics or data science, with a merchandising background. * **Bachelor's Degree**: A Bachelor's degree in a quantitative field. **What We Offer** As an Entry-Level Data Analyst at arenaflex, you'll have the opportunity to: * **Work Remotely**: Work from anywhere in the CST zone and enjoy a flexible work schedule. * **Develop Your Skills**: Develop your skills in data analytics, retail merchandising, and Microsoft Excel. * **Collaborate with a Dynamic Team**: Collaborate with a dynamic team of analysts, planners, and merchants to drive business growth. * **Grow Your Career**: Grow your career with arenaflex, with opportunities for extension or conversion. * **Competitive Compensation and Benefits**: Enjoy competitive compensation and benefits, including health insurance, retirement plans, and paid time off. **How to Apply** If you're a motivated and detail-oriented individual with a passion for data analytics and retail merchandising, we encourage you to apply for this exciting opportunity. Please submit your application through our website: Apply Job! We can't wait to hear from you! Apply for this job