Sr Customer Forecast Analyst Job
Merck/MSD 1,078 reviews - Memphis, TN

This job posting is no longer available on Merck & Co.. Find similar jobs:Senior Customer Forecast Analyst jobs - Merck/MSD jobs

Sr Customer Forecast Analyst-SUP000404


Merck is a global health care leader with a diversified portfolio of prescription medicines, vaccines and consumer health products, as well as animal health products. Today, we are building a new kind of healthcare company – one that is ready to help create a healthier future for all of us.

Our ability to excel depends on the integrity, knowledge, imagination, skill, diversity and teamwork of people like you. To this end, we strive to create an environment of mutual respect, encouragement and teamwork. As part of our global team, you’ll have the opportunity to collaborate with talented and dedicated colleagues while developing and expanding your career.

This Planning position is responsible for all forecasting activities associated with Merck Consumer Care (MCC) customers for all strategic business units (i.e.: Skincare, Footcare, Gastro Intestinal and Upper Respiratory). The Senior Forecast Analyst creates and maintains forecast models for their customers, incorporating business intelligence and forecast information gathered from Sales, Marketing, Finance, retailer replenishment analysts, and other sources (i.e.: IRI or other syndicated consumer data). This position is the talent pool for the Demand Manager, Customer Supply Chain Analyst/Manager and SBU MRP backfills within the Supply Chain organization.

The Senior Customer Forecast Analyst is the integration point into the Sales organization. Basic forecast modeling is the responsibility of this position. This position leads the dialogue each month for their respective customers with CBM’s, CFM’s and Channel Leads during the forecast collaboration process with sales.

This position is also responsible for customer collaborations (CPFR). The Senior Forecast Analyst frequently communicates with the customer’s replenishment and forecasting groups.

Major Activities and Responsibilities:

Basic Functions:

•Develop demand forecasts (operational forecasts) at multiple levels of aggregation for multiple time horizons as part of a demand planning function.

•Review historical sales trends, research demand drivers, prepare forecast data, develop statistical forecast models, and evaluate forecast results.

•Coordinate cross-functional research activities to reconcile significant variances and refine the forecast model to reflect updated sales and market assumptions.

•Interact with Sales, Marketing, and Customer Finance to understand demand forecast drivers.

•Utilize a collaborative and consensus approach by working with Sales, Marketing and Finance to obtain and ensure that current and accurate information is used for demand forecasts.

•Use and maintain SAP/APO Demand Planning software as the primary forecasting system tool.

•Leads CPFR discussions.

•Provide input to the Supply Planning organization in developing inventory strategies on existing items, new products, and product phase-outs.

•Closely coordinate and communicate customer action plans with supply planning

Job Functions:

•Create statistical forecasts:

•Gather, analyze and validate data

•Execute statistical modeling software

•Review resulting statistical forecast model

•Apply error analysis techniques to improve forecasting

•Summarize/aggregate statistical forecasts

•Review sales plans, customer finance EA and demand drivers:

•Present, solicit, and assess feedback on the various forecasts from Sales and finance

•Recommend adjustments for operational forecasts

•Review promotional plans with Sales

•Collaborate with key Merck Consumer Care customers.

•Develop CPFR analysis for review with customer Forecast/Replenishment group.

•Lead CPFR collaboration meetings.

•Achieve consensus for operational demand forecasts by facilitating a collaborative planning process with Sales and Finance personnel

•Prepare relevant material to facilitate research and discussion

•Provide input to volume planning.

•Facilitate and manage demand planning/customer meetings

•Achieve consensus

•Maintain demand planning system:

•Enter and modify data

•Monitor trends in forecast accuracy

•Identify relevant market-related data

•Prepare and maintain relevant reports pertaining to demand planning process

Key Results:

•A customer demand forecast which incorporates current and accurate market information that allows Merck Consumer Care to correctly predict customer demand and provide its supply chain with the appropriate information to plan how to meet that customer demand.

•Improved relationships among Planners, Sales, Marketing and Finance, which will lead to effective knowledge sharing and an optimal consensus forecast to better guide Merck Consumer Care.

•Refined systems and methods to continually improve forecasts so that Merck Consumer Care can better anticipate customer needs.




* Bachelor's degree required.

* MBA preferred


* Minimum of 2 years of work experience.

* Demonstrated proficiency in statistics, forecasting and forecasting methods with an understanding of their financial and

* operational impacts.

* Experience with Windows, Microsoft Office and forecasting software.

* Strong analytical, organizational, decision making, and presentation skills.

* Strong interpersonal skills are also essential to effectively interact with all customers, teams and levels of business

* affecting the forecast process.


* Previous work experience in packaged goods/consumer products industry

* APICS certification

- Knowledge of SAP/APO, Manugistics, and/or JDA related to demand planning.

Our employees are the key to our company’s success. We demonstrate our commitment to our employees by offering a competitive and valuable rewards program. Merck’s benefits are designed to support the wide range of goals, needs and lifestyles of our employees, and many of the people that matter the most in their lives.

Merck is an equal opportunity employer, M/F/D/V – proudly embracing diversity in all of its manifestations.
Former Military, Transitioning Service Members, National Guard & Reserves - We value your past and present service.

Search Firm Representatives

Please Read Carefully:

Merck is not accepting unsolicited assistance from search firms for this employment opportunity. Please, no phone calls or emails. All resumes ted by search firms to any employee at Merck via-email, the Internet or in any form and/or method without a valid written search agreement in place for this position will be deemed the sole property of Merck. No fee will be paid in the event the candidate is hired by Merck as a result of the referral or through other means.

Merck is an equal opportunity employer, M/F/D/V – proudly embracing diversity in all of its manifestations. Former Military, Transitioning Service Members, National Guard & Reserves - We value your past and present service.

Job: Supply Chain Dev&Optimization

Job Title : Specialist

Primary Location: NA-US-TN-Memphis

Employee Status: Regular

Travel: Yes, 10 % of the Time

Number of Openings: 1

About this company
1,078 reviews
About Merck Merck makes medicines for a number of maladies, from stuffy noses and asthma to hypertension and arthritis. The...