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. Apply for this job