Experienced Data Analyst – Retail Merchandising and Analytics
At arenaflex, we are a global leader in retail pharmacy, dedicated to delivering exceptional customer experiences and driving business growth through innovative solutions. As a key member of our Merchandise Planning Analytics team, you will play a critical role in supporting our team of 100+ merchants and 40+ planners to optimize performance of our Front End (non-Pharmacy) businesses.
Job Summary:
We are seeking an experienced Data Analyst to join our team on a 6-month contract with the opportunity for extension or conversion. As a Remote Analyst, you will work 100% remotely, with a flexible schedule that requires a minimum of 30 hours per week. You will be responsible for managing and analyzing large datasets, creating complex reports, and developing effective working relationships with stakeholders across the organization.
Work Environment:
* 100% remote work arrangement, with a requirement to work in Central Standard Time (CST)
- Flexible schedule with a minimum of 30 hours per week, with a standard 8am-5pm schedule (9-hour day with a 1-hour lunch break from 12pm-1pm)
- Opportunity to work independently and adapt to changing work priorities
Responsibilities:
* Own 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
- Scope will be thousands of Own Brand items (at item level)
- System/tool used is Excel
- Project will involve complex excel formulas and ability to synthesize large data sets into meaningful executive recaps
- Develop and maintain effective working relationships with Merchandising, Planning, Finance, and other stakeholders
- Communicate complex analytical findings and recommendations to stakeholders through clear and concise reports and presentations
- Manage and prioritize multiple assignments and meet tight deadlines
- Stay up-to-date with industry trends and best practices in data analytics and retail merchandising
Top Must-Have Skills:
* Bachelor's Degree in a quantitative field (e.g., analytics, data science, finance, financial analysis, assortment planning, retail, procurement/purchasing, merchandising)
- At least 3-5 years of experience in one or more of the following: analytics, data science, finance, financial analysis, assortment planning, retail, procurement/purchasing, merchandising
- Strong understanding of retail merchandising basics (i.e., category management) and merchandising organization structures and processes
- Outstanding analytical and problem-solving skills partnered 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; skills such as 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 (for example: 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:
* 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:
* 3-5 year experience in Analytics or Data Science, Merchandising background
What We Offer:
* Opportunity to work with a global leader in retail pharmacy
- Flexible remote work arrangement
- Competitive compensation and benefits package
- Opportunity for career growth and professional development
- Collaborative and dynamic work environment
- Access to cutting-edge technology and tools
How to Apply:
If you are 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. Apply for this job