Contractors’ Warehouse —
STATISTICAL FORECAST ANALYST

The Statistical Forecast Analyst position is responsible for the development of The Home Depot sales forecast at the Store/SKU level. With input from the appropriate Replenishment Analysts, they establish Store/SKU clustering, Seasonal selling profiles and exception reporting criteria for their assigned product categories. They will make appropriate adjustments as dictated by forecast accuracy. The Statistical Forecast Analyst will work collaboratively with the Replenishment Analysts in reviewing and resolving forecast exceptions and ensuring the business strategies are appropriately implemented and maintained in the system. They will be required to interpret data based on specific statistical criteria and to synthesize the findings from the analysis. The Statistical Forecast Analyst will participate in strategic process improvements initiatives by analyzing business processes, procedures and monitoring the progress.

Key Responsibilities:

• 60% Develop statistical forecast models by SKU/Store groups, establish parameters for Forecast exception reporting and make appropriate revisions as indicated from the exception reporting. Track forecast accuracy at various product and store hierarchy levels. Identify and mitigate sources of forecast variance through collaboration with Inventory Analysts and Upper Management.
• 10% Establish business rules for shaping customer demand in collaboration with functional partners regarding product seasonality, product knowledge and Merchandising strategies. Ensure forecast models are adjusted for changing business strategies and product assortments.
• 10% Share insights, challenge assumptions and identify drivers of forecast variance with appropriate Replenishment analysts and Management. The associate will provide formal training and on-going mentoring for the Replenishment Analysts.
• 10% The individual must perform other tasks regarding forecasts and sales analysis as deemed appropriate by the Manager.
• 10% Analyze, identify and implement opportunities for improvements to the forecasting process. Contributes significant participation in cross functional projects by developing timelines and coordinating teams across each area, ensuring on time delivery of goals and requirements.

Direct Manager/Direct Reports:

• Position generally reports to a Manager or Sr. Manager
• Responsible for helping others and providing on-the-job training or guidance

Travel Requirements:

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

Physical Requirements:

• Frequent periods are spent standing or sitting in the same location with some opportunity to move about; occasionally there may be a need to stoop or lift light objects (typically less than 8 pounds).

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.
• Strong analytical and statistical skills. Must be familiar with and comfortable with methods for organizing, handling and evaluating large amounts of data.

Preferred Qualifications:

• Previous experience with demand forecasting or supply chain replenishment in an environment with high numbers of store/sku records.
• Advanced computer skills to retrieve, manipulate, analyze and interpret large amounts of data. Experience with MS Office Excel and Access.
• Prior experience using Teradata DCM forecasting software or a similar advanced demand forecasting tool.
• Proficient in business process evaluation and procedure development; demonstrates a thorough knowledge of all tools, processes, methodologies and standards for requirements gathering, documentation and analysis.
• Masters Degree with an emphasis in Supply Chain Management or Economics.

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:

• 1

Preferred Years of Work Experience:

• No additional years of experience

Minimum Leadership Experience:

• None

Preferred Leadership Experience:

• None

Certifications:

• None

Competencies:

• Critical thinking skills to identify the strengths and weaknesses of alternative solutions; ability to understand and foresee implications of new information for current and future problem solving.
• Solid understanding and use of statistical software to manipulate, analyze and interpret data.
• Proficient in business process evaluation and procedure development; demonstrates a thorough knowledge of all tools, processes, methodologies and standards for requirements gathering, documentation and analysis.
• Strong written and verbal communications skills. Ability to persuade or influence others.
• Strong self starter with ability to work with little supervision.