About the job Entry Level Data Entry Clerk / Remote Remote Analyst We have 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
Microsoft Word Data Analyst Problem-solving sumifs Storytelling macros procurement Retail forecasting Quantitative analysis Financial Analyst vlookup inventory-management Microsoft Excel Merchandising