STATISTICAL FORECAST ANALYST-2

Home Depot; United States; Remote; USD 55,000 - 90,000; Full time

Job summary

An established industry player is seeking a Statistical Forecast Analyst who will play a crucial role in developing sales forecasts at the Store/SKU level. This position involves analyzing data, collaborating with replenishment analysts, and implementing strategic improvements. The ideal candidate should possess strong analytical and statistical skills, with experience in demand forecasting and supply chain replenishment. Join this innovative firm and contribute to enhancing business strategies and processes in a dynamic environment where your insights will drive significant improvements.

Qualifications

• Strong analytical and statistical skills with data evaluation experience.
• Familiar with demand forecasting or supply chain replenishment.

Responsibilities

• Develop statistical forecast models and track accuracy across stores.
• Collaborate with Inventory Analysts to mitigate forecast variance.

Skills

Analytical Skills

Statistical Skills

Data Handling

Critical Thinking

Education

Bachelor's Degree

Master's Degree in Supply Chain Management or Economics

Tools

MS Office Excel

MS Access

Teradata DCM

Job description

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

Position Purpose:

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.