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