Analyst, Assortment

Home Depot; Atlanta (GA); On-site; USD 65,000 - 90,000; Full time

Job summary

The Home Depot is seeking an Assortment Analyst - Online Merchandising to understand and analyze performance drivers for homedepot.com merchandising. You will work with Online Merchants, Merchandise Planning Managers, and cross-functional partners to identify opportunities and recommend strategies to boost sales and profitability.

Responsibilities include conducting internal sales and competitive analyses, supporting daily/weekly/monthly reporting, and contributing to projects on supplier

Qualifications

• BA/BS in Industrial Engineering, Management, Economics, or Retail Sciences.
• Work experience in retail, merchandising, or a consulting/project management role in a corporate environment.
• Demonstrated ability with business modeling using SQL, Excel, Access, Tableau and advanced proficiency with Microsoft Office.

Responsibilities

• 50% Work with Online Merchants, Merchandise Planning Managers, and cross functional partners to analyze business drivers and recommend/execute strategies to achieve business objectives
• 30% Contribute to projects and new initiatives which further strategic business objectives
• 20% Execute key daily/weekly/monthly business performance reporting; seek out opportunities to continuously improve reporting efforts

Skills

Business analytics

Cross-functional collaboration

Data visualization

Communication

Education

BA/BS in Industrial Engineering

BA/BS in Management or Retail Sciences

Bachelor's degree

Tools

SQL

Excel

Access

Tableau

Microsoft Office

Job description

With a career at The Home Depot, you can be yourself and also be part of something bigger.

Position Purpose:

The Assortment Analyst - Online Merchandising will be responsible for understanding and analyzing the key drivers of performance related to homedepot.com merchandising. The role works with Online Merchants, Merchandise Planning Managers, and other cross-functional business partners to identify opportunities and recommend/ execute strategies to achieve business objectives and maximize sales and profitability. The Assortment Analyst will conduct internal sales and competitive analyses that help identify financial strategies for product selection and pricing. The Assortment Analyst will also be responsible for executing and continuously improving daily/weekly/monthly reporting efforts as well as contributing to projects that further strategic business initiatives related to supplier engagement, profitability and productivity.

Key Responsibilities:

• 50% Work with Online Merchants, Merchandise Planning Managers, and cross functional partners to analyze business drivers and recommend/execute strategies to achieve business objectives
• 30% Contribute to projects and new initiatives which further strategic business objectives
• 20% Execute key daily/weekly/monthly business performance reporting; seek out opportunities to continuously improve reporting efforts

Direct Manager/Direct Reports:

• Reports to a Manager, Merchandising Planning.
• This role has no direct reports.

Travel Requirements:

• Typically requires overnight travel less than 10% of the time.

Physical Requirements:

• Most of the time is spent sitting in a comfortable position and there is frequent opportunity to move about. On rare occasions there may be a need to move or lift light articles.

Working Conditions:

• Located in a comfortable indoor area. Any unpleasant conditions would be infrequent and not objectionable.

Minimum Qualifications:

• Must be eighteen years of age or older.
• Must be legally permitted to work in the United States.

Preferred Qualifications:

• BA/S in Industrial Engineering, Management, Economics, or Retail Sciences
• Work experience in retail, merchandising, or a consulting/ project management role in a corporate environment
• Demonstrated ability with business modeling capabilities using tools such as SQL, Excel, Access, and Tableau and advanced proficiency with other Microsoft Office programs

Minimum Education:

• The knowledge, skills and abilities typically acquired through the completion of a bachelor's degree program or equivalent degree in a field of study related to the job.

Preferred Education:

• No additional education

Minimum Years of Work Experience:

• 2

Preferred Years of Work Experience:

• No additional years of experience

Minimum Leadership Experience:

• None

Preferred Leadership Experience:

• None

Certifications:

• None

Competencies:

• Ability to understand business drivers and influence decision making with cross-functional partners
• Proven ability to analyze, evaluate, and interpret complex data; innate intellectual curiosity
• Track record of taking ownership and driving results; ability to learn quickly and independently
• Ability to work simultaneously across several work streams balancing quality of work and consistent delivery
• Strong communication and presentation skills
• High comfort level working in fast paced environment