Experienced 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 Data Analyst to join our Merchandise Planning Analytics team on a 6-month contract with the opportunity for extension or conversion.

About the Role

Our Merchandise Planning Analytics team is the backbone of our retail merchandising operations, providing critical support to our merchants and planners to optimize performance of our Front End (non-Pharmacy) businesses. As a Data Analyst, you'll play a vital role in managing reporting, analysis, and tool building for our Merchandising team, working closely with stakeholders to drive business growth and improve operational efficiency.

Work Environment

As a remote analyst, you'll have the flexibility to work from anywhere in the Central Standard Time (CST) zone, with a standard 8am-5pm schedule and a one-hour lunch break from 12pm-1pm. While we offer flexible working hours, we require a minimum of 30 hours per week to fulfill our business needs. You'll be part of a dynamic team that values collaboration, innovation, and continuous learning.

Key Responsibilities

As a Data Analyst, your key responsibilities will include:

• Own Brand Reporting and Analysis: Own and manage reporting, recapping, tracking, and analysis of private label products, 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 item-level future looking forecasts to inform business decisions.
• Complex Excel Formulas and Data Synthesis: Utilize complex Excel formulas and data synthesis techniques to extract meaningful insights from large data sets.
• Executive Recaps and Presentations: Develop clear and concise executive recaps and presentations to communicate findings and recommendations to stakeholders.

Top Must-Have Skills

To succeed in this role, you'll need:

• Bachelor's Degree and 3-5 Years of Experience: A bachelor's degree in analytics, data science, finance, financial analysis, assortment planning, retail, procurement/purchasing, or merchandising, with at least 3-5 years of experience in one or more of these fields.
• Strong Analytical and Problem-Solving Skills: Outstanding analytical and problem-solving skills, paired with storytelling finesse to communicate complex insights to stakeholders.
• Microsoft Excel Expertise: Intermediate to advanced level skill in Microsoft Excel, including complex formulas, data synthesis, and data visualization.
• Communication and Collaboration: Ability to communicate effectively and succinctly both verbally and in writing, with strong collaboration and interpersonal skills.
• Retail Math Background: Retail math background, including item-level forecasting, demand patterns, sell-through/sales/profit goals, sales by type, and AUR impacts.
• Inventory and Sales Metrics: Knowledge of inventory and sales metrics, including sales by type and AUR impacts.

Top Nice-to-Have Skills

While not essential, the following skills are highly desirable:

• MBA or Quantitative Analytical Degree: MBA or a degree in science, technology, engineering, mathematics (STEM), or other quantitative analytical fields.
• Data Science Experience: Experience in data science, including data visualization, machine learning, and statistical modeling.
• Retail Experience: Retail experience, including merchandising, assortment planning, or procurement/purchasing.
• SQL Coding and Macro Building: SQL coding, Microsoft Access, and macro building skills.

Education and Experience Requirements

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

• 3-5 Years of Experience in Analytics or Data Science: 3-5 years of experience in analytics or data science, with a strong background in merchandising.
• Bachelor's Degree: A bachelor's degree in a relevant field.

What We Offer

As a Data Analyst at arenaflex, you'll enjoy:

• Competitive Compensation: Competitive compensation and benefits package.
• Flexible Working Hours: Flexible working hours, with a standard 8am-5pm schedule and a one-hour lunch break.
• Opportunities for Growth: Opportunities for growth and professional development, with a focus on continuous learning and skill-building.
• Collaborative Work Environment: Collaborative work environment, with a dynamic team that values innovation and creativity.
• Recognition and Rewards: Recognition and rewards for outstanding performance and contributions to the team.

How to Apply

If you're a motivated and detail-oriented data analyst with a passion for retail merchandising and analytics, we encourage you to apply for this exciting opportunity. Please submit your resume and a cover letter outlining your experience, skills, and qualifications for the role. We can't wait to hear from you! Apply for this job