The Nations 2nd largest Technical Staffing and Services Firm, has an opening for a Remote Analyst at a global leader in retail pharmacy for a 6-month contract with the opportunity for extension or conversion.
Summary:
The Walgreens Merchandise Planning Analytics team manages reporting, analysis, and tool building for the Walgreens Merchandising team. They support a team of 100+ merchants and 40+ planners to optimize performance of the Walgreens Front End (non-Pharmacy) businesses.
Work Environment:
- 100% remote - must work in CST
- 8am-5pm (9 hour day with one hour lunch break 12pm-1pm).
- The hours can be flexible per above but minimally need 30 hours a week in order to fulfill the business needs
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
Top Must-Have Skills:
- Bachelors Degree and at least 3-5 year of experience in one or more of the following: analytics, data science, finance, financial analysis, assortment planning, retail, procurement/purchasing, merchandising
- Minimum 3 years experience in data analytics or other related field with 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