About the job Remote Data Analyst
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 needsItem level historical analysis and recappingItem level future looking forecastScope will be thousands of Own Brand items (at item level)System / tool used is ExcelProject will involve complex excel formulas and ability to synthesize large data sets into meaningful executive recapsTop 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, merchandisingMinimum 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 processesOutstanding analytical and problem-solving skills partnered with storytelling finesseAbility to conduct complex quantitative analysis and build analytical models using Microsoft ExcelAbility to communicate effectively and succinctly both verbally and in writing via Microsoft PowerPointAbility to manage and prioritize multiple assignments and meet tight deadlinesAbility to develop effective working relationships with Merchandising, Planning, Finance and other stakeholdersAbility to work independently and adapt to changing work prioritiesRetail 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 metricsIntermediate / 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 excelIntermediate level skill in Microsoft Word and PowerPointTop Nice-to-Have Skills :
MBA preferred; Science, Technology, Engineering, Mathematics and / or other quantitative analytical degree a plusData science experienceRetail experienceSQL Coding, Microsoft Access, Macro buildingEducation / Experience Requirements :
3-5 year experience in Analytics or Data Science, Merchandising background