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 the Role:
Our Merchandise Planning Analytics team is the backbone of our retail pharmacy business, providing critical insights and analysis to optimize performance across 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, supporting over 100 merchants and 40 planners. Your expertise will help us make data-driven decisions, drive business growth, and deliver exceptional customer experiences.
Work Environment:
As a remote analyst, you'll have the flexibility to work from anywhere in the Central Standard Time (CST) zone. Our team is highly collaborative, and we use a range of tools to stay connected and productive. You'll work a standard 8am-5pm schedule with a one-hour lunch break from 12pm-1pm. While we're flexible, we require a minimum of 30 hours per week to fulfill our business needs.
Responsibilities:
As a Data Analyst, you'll be responsible for:
- Owning Brand (private label) reporting, recapping, tracking, and analysis, including ad-hoc analysis based on business needs
- Item-level historical analysis and recapping
- Item-level future-looking forecast
- Managing thousands of Own Brand items at an item level
- Utilizing Excel to analyze complex data sets and create meaningful executive recaps
- Developing and maintaining complex Excel formulas and models
- Communicating insights and recommendations to stakeholders through Microsoft PowerPoint
- Collaborating with Merchandising, Planning, Finance, and other stakeholders to drive business growth
- Managing multiple assignments and meeting tight deadlines
- Developing effective working relationships with cross-functional teams
Top Must-Have Skills:
To succeed in this role, you'll need:
- A Bachelor's Degree and at least 3-5 years of experience in analytics, data science, finance, financial analysis, assortment planning, retail, procurement/purchasing, or merchandising
- Minimum 3 years of experience in data analytics or a related field with a strong understanding of retail merchandising basics (i.e., category management) and merchandising organization structures and processes
- Outstanding analytical and problem-solving skills, paired with storytelling finesse
- Ability to conduct complex quantitative analysis and build analytical models using Microsoft Excel
- Ability to communicate effectively and succinctly both verbally and in writing via Microsoft PowerPoint
- Ability to manage and prioritize multiple assignments and meet tight deadlines
- Ability to develop effective working relationships with Merchandising, Planning, Finance, and other stakeholders
- Ability to work independently and adapt to changing work priorities
- Retail math background, including item-level forecasting based on demand patterns or sell-through/sales/profit goals, knowledge of sales by type and AUR impacts, all inventory and sales metrics
- Intermediate/Advanced level skill in Microsoft Excel (e.g., using SUM/SUMIFS, Subtotals, VLOOKUP, HLOOKUP, Macros, Pivot tables) - CRITICAL SKILL NEEDED FOR ROLE, most work will be done in Excel
- Intermediate level skill in Microsoft Word and PowerPoint
Top Nice-to-Have Skills:
While not required, the following skills will be highly valued:
- MBA preferred; Science, Technology, Engineering, Mathematics, and/or other quantitative analytical degree a plus
- Data science experience
- Retail experience
- SQL Coding, Microsoft Access, Macro building
Education / Experience Requirements:
We're looking for candidates with 3-5 years of experience in Analytics or Data Science, with a merchandising background.
What We Offer:
As a Data Analyst at arenaflex, you'll enjoy:
- A competitive salary and benefits package
- Opportunities for career growth and professional development
- A dynamic and collaborative work environment
- Flexible remote work arrangements
- Access to cutting-edge technology and tools
- A comprehensive training program to help you succeed in your role
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. We can't wait to hear from you! Apply Now! Apply for this job