Analyst, Merchandise Information Office

New York - New York

Date Posted: Apr. 16, 2019

Requisition ID: MAC14615

Job Overview:

This Analyst position reports into the MIO department at Macy’s.  MIO, which stands for the Merchandise Information Office, is responsible for supporting the Omni & Digital Buyers and Planners (merchants) at Macy’s, as well as other cross-functional partners, including Stores Operations, Shortage Control, A/P, Private Label brands, leased businesses, distribution warehouses, and vendors.
This Analyst’s primary responsibility is maintaining integrity and stability of the Style File, including products being sold in stores as well as online. The Style File system holds information about all merchandise carried at Macy’s – about 2 million products, which equate to over 6 million records at color/size (UPC) level.  Because this system integrates with several other retail systems responsible for ordering, allocating and reporting, the Analyst is expected to perform various maintenance functions to support compliance with corporate hierarchy, website availability, proper aging, and taxing of merchandise. Perform other duties as assigned.

Essential Functions:

Maintain the Style File and EDI System:
  • Research and resolve systemic issues called in by Buyers and Planners or detected internally.
  • Perform maintenance submitted by the Buying Offices, ensuring it is processed timely and accurately.
  • Participate in testing enhancements.
Maintain related support files to ensure accurate financial accounting for inventory and taxation of products at point of sale:
  • Coordinate seasonal changes to merchandise departmental hierarchy as business needs dictate.
  • Perform file set-ups for existing and new store locations.
  • Perform tax maintenance to adhere to local regulations.
  • Partner with Gross Margin Accounting to review aging of product.
Review Merchandise Not live and ITS (Issue Tracking System) open issues:
  • Develop and enhance current website reporting for the Macy’s organization. Compile trend reporting for areas that consistently populate the website exception reports.
  • Support the Merchants with resolving open issues and assist in troubleshooting why products are not live on the site. 
  • Develop a complete working knowledge of the website area and learn about how it interfaces with all other areas of the support organization. 
  • Work with Customer Service & Facilities teams to ensure best practices are followed. Develop ad-hoc reporting as requested. 
  • Regular, dependable attendance & punctuality.

  • Bachelor’s Degree in Finance, Mathematics or Economics preferred, but not required. 
  • 1 to 2 years work experience preferred.
  • Must be able to work independently with minimal supervision.
  • Strong knowledge of the product development process (retail experience recommended).
Communication Skills: 
  • Excellent written and verbal communication skills.  
  • Ability to read, write, and interpret instructional documents such as reports and procedure manuals, and explain orally and in writing, technical information to partners in a simple and understandable format.
Mathematical Skills:
  • Strong Microsoft Excel and above average mathematical skills. 
  • Ability to compute rates, ratios, and percentages. 
  • Ability to work with mathematical concepts such as probability and statistical inference. 
Reasoning Ability:
  • Ability to multitask and work cross functionally with multiple business partners.
Physical Demands:
  • This position involves regular walking, standing, sitting for extended periods of time, hearing, and talking. 
  • May occasionally involve stooping, kneeling, or crouching. 
  • May involve close vision, color vision, depth perception, focus adjustment, and viewing computer monitor for extended periods of time.  
  • Involves manual dexterity for using keyboard, mouse, and other office equipment. 
  • May involve moving or lifting items under 10 pounds.
Work Hours:
  • Ability to work a flexible schedule based on department and store/company needs.

Company Profile:
As the fastest growing part of Macy's Inc. business, is achieving record sales and broadening our workforce. offers the entrepreneurial culture of a web business with the stability and support of the best brand in retailing. Creativity and ingenuity partner with business acumen and tech savvy to build a unique business poised for substantial growth. If you're interested in being a part of that growth and want to know what it's really like to work at, get an inside look at

Our employees have long-term opportunities and are encouraged to utilize their Supervisors and Human Resources for cross-functional movement to further their careers. At we are committed to giving back to the community by partnering with local charitable organizations. By skillfully combining the power of digital technology and omnichannel integration with the best in retailing, is reaching new heights.

This job description is not all inclusive. In addition, Macy's, Inc. reserves the right to amend this job description at any time. Macy’s, Inc. is an Equal Opportunity Employer, committed to a diverse and inclusive work environment.