Remote Excel Vba Macro Jobs in Arizona (NOW HIRING)

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

Equal Opportunities

Optimere is an Equal Employment Opportunity employer that proudly pursues and hires a diverse workforce. Optimere does not make hiring or employment decisions on the basis of race, color, religion or religious belief, ethnic or national origin, nationality, sex, gender, gender identity, sexual orientation, disability, age or any other basis protected by applicable

PLEASE NOTE: Optimere is unable to sponsor visas at this time. You must be a US Citizen or Permanent Resident authorized to work in the US.