Role Profile
Job Title: Sales Forecast Analyst
Role Overview
Based in Tyholland, County Monaghan the analyst will identify, develop and communicate insights and opportunities to ensure sales forecasts are robust and accurate so that we maximise our sales and reduce waste throughout our supply chain.
Main Duties
Interrogate customer forecasts, promotional trackers, epos, waste and inventory to provide accurate and reliable sales forecasts
Collaborate with the sales team to gather and analyse sales data, historical trends, market conditions and customer demand patterns to prepare accurate sales forecasts
Monitor and analyse sales performance against forecast, identify any discrepancies or variances and provide insights and recommendations for improvement
Engage with our customer supply chain analysts / counterparts to develop strong customer relationships and collaboration on all aspects of the sales forecasts
Develop and maintain customer data sets to allow you to make your recommendations including market trends, promotional activities, economic indicators and customer insights
Review short, medium and long term forecasts identifying risks and opportunities and collaborate with cross-functional teams to align strategies and plans and make recommendations
Provide support and guidance to the sales team in particular short term alignment on volumes and promotional performance
Generate reports and presentations summarizing sales forecasts, performance analysis and recommendations for management review
Samples or routines include
Update & review daily sales review data by customer account
Update & review customer sales forecasts
Update & review organic sales
Update & review product group mix
Update & review customer mix as % of total sales
Review customer promotions and make recommendations about future forecasts
Issue weather forecast on a daily basis and make recommendations
Support on seasonal planning, seasonal uplift and promotional analysis
KPI recording and monitoring for the management reports and weekly customer KPI sheets
Ad-hoc reports
This is not an exhaustive list and is subject to change and amendment.
Competencies to perform the role
Strong analytical and problem-solving skills with the ability to interpret and analyse complex sales data and trends
Proficient in Excel in particular the advanced functions including pivot tables and VLOOKUP
Attention to detail – focus on accuracy is essential with the ability to manage multiple data sources and prioritise your workload
Proactive and self-motivated with the ability to work independently and prioritise tasks in a fast-paced deadline driven environment
A good understanding of numbers, analytical and able to demonstrate interpretation of numbers
Be an independent and self-motivated worker with the ability to work in a team environment
Have excellent presentation skills
Have excellent communication skills with the ability to effectively communicate to various stakeholders
Be flexible and adaptable as the role develops with time
High personal standards – confidentiality and time management
Strong business acumen and a good understanding of market dynamics, customer behaviour and sales processes
Experience and Qualifications
Bachelor's degree in business, finance, statistics or another related field
Proven experience in Sales Forecasting, demand planning or a similar analytical role
Proficient in using relevant software tools including Microsoft Excel, Word, PowerPoint and Outlook
Other Significant Role Requirements
Experience working with UK or Irish Retailers in chilled, fresh, own-label FMCG environment
Experience in the manufacturing or retail industry
Flexibility as the role will be varied
Willing to train quickly and under pressure
Strong initiative
Ability to manage their own time and prioritise appropriately
A desire to develop and learn
Ability to analyse situations and problem solve as required
Performing the role in line with the Monaghan Cultural Values
We do the right thing: We use this philosophy to drive every aspect of our business, from product, to process to people
Forward Thinking: We think ahead and we think for the long term
Down to Earth: We understand the importance of communicating our discoveries in a straightforward way
Inspiring: We seek out new ways to excite and inspire each other
Egalitarian: We have always been grounded in the belief that everyone is equal.
That everyone deserves an equal chance to speak, be heard and make an impact
#J-*****-Ljbffr