Entry Level Data Entry Clerk / Remote

Summary

Allied Global Marketing is recruiting for a global leader in retail pharmacy supporting the Walgreens Merchandise Planning Analytics team. The Remote Analyst will manage Own Brand reporting, historical and forward-looking item-level analysis, forecasting, and ad hoc analytics using Excel to help optimize Walgreens Front End merchandising performance.

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

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
• 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

Qualifications

Must Haves

• 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

Nice to Haves

• 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

Benefits

• 6-month contract with the opportunity for extension or conversion
• 100% remote
• The hours can be flexible per above but minimally need 30 hours a week in order to fulfill the business needs