Jobsultant Solutions
Jobsultant Solutions is hiring: Remote Data Analyst in Denver
Jobsultant Solutions, Denver, CO, United States
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 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.