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

At arenaflex, we're on a mission to revolutionize the retail pharmacy industry by harnessing the power of data-driven insights. As a global leader in retail pharmacy, we're committed to delivering exceptional customer experiences and driving business growth through innovative solutions. We're now seeking 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** Our Merchandise Planning Analytics team is the backbone of arenaflex's retail merchandising strategy. With a team of over 100 merchants and 40+ planners, we're dedicated to optimizing the performance of arenaflex's Front End (non-Pharmacy) businesses. Our team manages reporting, analysis, and tool building to drive business growth and improve customer satisfaction. **Work Environment and Schedule** As a Remote Analyst at arenaflex, you'll have the flexibility to work from anywhere in the Central Standard Time (CST) zone. Our standard working hours are 8am-5pm, with a one-hour lunch break from 12pm-1pm. While we offer flexible scheduling, we require a minimum of 30 hours per week to fulfill our business needs. **Key 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 advanced Excel formulas and techniques to synthesize large data sets into meaningful executive recaps. * **System/Tool Used**: Excel will be the primary system used for this project. **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 (e.g., category management) and merchandising organization structures and processes. * **Analytical and Problem-Solving Skills**: Outstanding analytical and problem-solving skills, paired with storytelling finesse. * **Microsoft Excel and PowerPoint Skills**: Ability to conduct complex quantitative analysis and build analytical models using Microsoft Excel, as well as communicate effectively and succinctly via 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**: Knowledge of retail math concepts, including item-level forecasting, demand patterns, sell-through, sales, profit goals, and inventory and sales metrics. * **Intermediate/Advanced Excel Skills**: Intermediate/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**: An MBA or degree in a quantitative field (e.g., Science, Technology, Engineering, Mathematics) is a plus. * **Data Science Experience**: Experience in data science, including data mining, machine learning, and statistical modeling. * **Retail Experience**: Prior experience in retail, including merchandising, planning, or analytics. * **SQL Coding and Microsoft Access**: Knowledge of SQL coding and Microsoft Access is a plus. * **Macro Building**: Ability to build and maintain complex macros in Excel. **Education and Experience Requirements** To be considered for this role, you'll need: * **3-5 Years of Experience**: 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. **Why Join arenaflex?** At arenaflex, we offer a dynamic and supportive work environment that fosters growth and development. As a Remote Analyst, you'll have the opportunity to work on high-impact projects, collaborate with a talented team, and contribute to the success of our retail pharmacy business. We're committed to providing a comprehensive benefits package, including: * **Competitive Compensation**: A competitive salary and benefits package. * **Professional Development**: Opportunities for professional growth and development, including training and mentorship programs. * **Flexible Work Arrangements**: Flexible work arrangements, including remote work options. * **Recognition and Rewards**: Recognition and rewards for outstanding performance and contributions. **How to Apply** If you're 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 can't wait to hear from you! Apply Now! Apply for this job