Remote Data Analyst / HR

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.


Remote

Skills:
Analysis Skills, Business Administration, Business Analysis, Category Management, Communication Skills, Data Analysis, Data Science, Data Sets, Demand Forecasting/Planning, Establish Priorities, Finance, Financial Analysis, Forecasting, Mathematics, Merchandising, Metrics, Microsoft Access Database, Microsoft Excel, Microsoft PowerPoint, Microsoft Word, Performance Tuning/Optimization, Pharmacy, Pivot Tables, Problem Solving Skills, Purchasing/Procurement, Quantitative Analysis, Retail, Retail Merchandising, SQL (Structured Query Language), Sales, Storytelling, Team Lead/Manager, Technical Recruiting, Time Management, United States Citizen, User Interface/Experience (UI/UX), Vlookups


undefined:
Jobsultant Solutions



Back to blog

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...