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.
MAJOR TASKS, RESPONSIBILITIES AND KEY ACCOUNTABILITIES
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.
NATURE AND SCOPE
This position reports to the Senior Manager, Assortment Planning.
This position has no direct responsibility for supervising others.
ENVIRONMENTAL JOB REQUIREMENTS
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.
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
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.
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.