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

At arenaflex, we're on a mission to revolutionize the retail pharmacy industry with innovative solutions and cutting-edge technology. As a global leader in retail pharmacy, we're committed to delivering exceptional customer experiences and driving business growth through data-driven insights. 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 operations. With a team of over 100 merchants and 40 planners, we're responsible for managing reporting, analysis, and tool building to optimize performance of our Front End (non-Pharmacy) businesses. Our team is passionate about using data to drive business decisions and deliver exceptional results.

• *Work Environment**

As a Remote Analyst at arenaflex, you'll enjoy a flexible and dynamic work environment that offers the perfect blend of autonomy and collaboration. Here are some highlights of what you can expect:

• **100% Remote**: Work from the comfort of your own home or office, with minimal distractions and maximum productivity.
• **Central Standard Time (CST)**: Our team operates on CST, so you'll need to be available during this time zone.
• **Flexible Hours**: While our standard working hours are 8am-5pm (with a one-hour lunch break from 12pm-1pm), we're open to flexible arrangements that meet your needs and our business requirements.
• **Minimum 30 hours per week**: We need our team members to commit to a minimum of 30 hours per week to ensure we meet our business needs.

• *Key Responsibilities**

As an Entry-Level Data Analyst at arenaflex, you'll be responsible for:

• **Own Brand Reporting**: Develop and maintain reports, recaps, and analysis for our private label products, including ad-hoc analysis based on business needs.
• **Item Level Historical Analysis**: Conduct in-depth analysis of historical sales data for individual items, identifying trends and insights to inform business decisions.
• **Item Level Future Looking Forecast**: Develop forecasts for individual items, using data and analytics to predict future sales and optimize inventory levels.
• **Complex Excel Formulas**: Develop and maintain complex Excel formulas to synthesize large data sets into meaningful executive recaps.
• **System/Tool Used**: Excel will be your primary tool for this role, so you'll need to be proficient in using it to analyze and present data.

• *Top Must-Have Skills**

To succeed in this role, you'll need to possess the following skills and qualifications:

• **Bachelor's Degree**: A degree in a quantitative field such as analytics, data science, finance, or a related field.
• **3-5 Years of Experience**: At least 3-5 years of experience in analytics, data science, finance, or a related field, with a strong understanding of retail merchandising basics.
• **Analytical and Problem-Solving Skills**: Outstanding analytical and problem-solving skills, with the ability to communicate complex insights in a clear and concise manner.
• **Microsoft Excel**: Intermediate to advanced level skills in Microsoft Excel, including the ability to use SUM/SUMIFS, Subtotals, VLOOKUP, HLOOKUP, Macros, and Pivot tables.
• **Communication Skills**: Excellent verbal and written communication skills, with the ability to present data insights to stakeholders using Microsoft PowerPoint.
• **Time Management**: Ability to manage and prioritize multiple assignments and meet tight deadlines.
• **Collaboration**: Ability to develop effective working relationships with Merchandising, Planning, Finance, and other stakeholders.

• *Top Nice-to-Have Skills**

While not essential, the following skills and qualifications would be beneficial for this role:

• **MBA**: A Master's degree in Business Administration or a related field.
• **Data Science Experience**: Experience in data science, including machine learning and statistical modeling.
• **Retail Experience**: Experience working in retail, including merchandising, planning, or analytics.
• **SQL Coding**: Knowledge of SQL coding and database management.
• **Microsoft Access**: Experience with Microsoft Access and database management.
• **Macro Building**: Ability to build and maintain complex macros in Excel.

• *Education/Experience Requirements**

To be considered for this role, you'll need to have:

• **3-5 Years of Experience**: At least 3-5 years of experience in analytics or data science, with a merchandising background.

• *What We Offer**

As an Entry-Level Data Analyst at arenaflex, you'll enjoy a range of benefits and perks, including:

• **Competitive Salary**: A competitive salary that reflects your skills and experience.
• **Flexible Work Arrangements**: The flexibility to work from home or in the office, with minimal distractions and maximum productivity.
• **Opportunities for Growth**: The opportunity to grow and develop your skills, with a clear career path and opportunities for advancement.
• **Collaborative Team Environment**: A collaborative and supportive team environment that encourages innovation and creativity.
• **Professional Development**: Opportunities for professional development, including training and education programs.

• *How to Apply**

If you're a motivated and analytical individual with a passion for data-driven insights, we'd love to hear from you. Please apply through our website, and don't forget to include your resume, cover letter, and any relevant work samples or projects.