The Home Depot Veterans Jobs

Advertisement Advertisement

Job Information

Home Depot Senior Analyst, Assortment Planning (Category Health) in Atlanta, Georgia


The Senior Analyst - Category Health position assists in the development and execution of analytics to support the Category Management Team. The role works cross-functionally with business partners from Merchandising, Finance, Operations, Supply Chain, Online and IT to design and implement analytics, tools, and new visibility/reporting capabilities. This role will both build and utilize these reports to support specific needs from the Category Managers and merchants. The candidate will work to understand how their analytics merge with the merchandising strategy of their business partners and leverage effective communication skills to translate these analytics into actionable insights.


90% Work in collaboration with Merchants to determine category review goals and objectives, conduct standard and ad hoc analysis to identify key drivers of performance, recommend assortment decisions that will improve category performance and develop financial plans that reflect category changes. Typical analysis will include: (a) marketplace and macroeconomic trends impacting the category including competitive assessment, (b) vendor portfolio strengths and weaknesses including private brand, (c) line structure, (d) store clustering, (e) customer and store feedback, (f) identifying key product attributes and (g) regional performance. Develop executive-level presentations that summarize analysis including historical category performance, strategic rationale underpinning assortment decisions and expected financial impact. Report out to all levels of management. Accountable for accuracy, thoroughness, thought process, timeliness and viability of recommendations.

10% Own Merchant/Associate Merchant relationship for designated department. Special projects. Ad hoc analysis and reporting.


This position reports to the Senior Manager, Assortment Planning.

This position has no direct responsibility for supervising others.



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


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


Must be eighteen years of age or older.

Must be legally permitted to work in the United States.

Additional Minimum Qualifications:

Experience communicating to leadership.

Education Required:

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.

Years of Relevant Work Experience: 2 years

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.

Preferred Qualifications:

2+ years experience working in retail

Experience analyzing large amounts of data

Advanced knowledge of Excel (pivot tables, v-lookup, macros)

Experience utilizing SQL to create tables and build reporting

Intermediate to Advanced Tableau knowledge and experience building dashboards

Knowledge, Skills, Abilities and Competencies:

Ability to partner with cross-functional teams at all levels across a complex organization

Ability to get results despite a large workload, competing demands and working in a fast paced environment

Ability to effectively prioritize multiple demands, adjust to change quickly and work constructively under pressure

Ability to structure nebulous projects and to work constructively under tight deadlines

Ability to influence peers and business partners without authority

We are an Equal Opportunity Employer and do not discriminate against any employee or applicant for employment because of race, color, sex, age, national origin, religion, sexual orientation, gender identity, status as a veteran, and basis of disability or any other federal, state or local protected class.