The majority of the work I do is around forecasting & reporting sales and inventory metrics. At the beginning of each month, I help forecast what the next month’s product shipments will look like to support our supply and demand team to determine how much of each product to produce. Towards the end of the month, I look at our sales and forecast what the customer’s margin will end up at for the month. On top of the forecasting & reporting, I also am the team excel specialist. Since I can write macros, I am often tasked with automating time-consuming processes or creating dashboards that allow higher-ups to digest data quickly and concisely via graphs.
The most rewarding aspect of my job is being able to quantify through sales the value that you add every day. One example is when I provide an analysis to help secure the customer adding one of our products to their set, I will be able to look at sales after three months and say I helped drive that. It is also satisfying to work and be involved in customer meetings, which helps provide insight into how they operate and think. I also enjoy the process improvement aspect of my job. It is very gratifying to know that you freed up time from someone else’s day.
Free lunch, product samples
One of the biggest downsides of my job is that it’s very repetitive. A lot of the work I do is refreshing daily, weekly & monthly reports. Another disadvantage, due to working in a sales office, there aren’t many different career paths for an analyst.
The most important skills are excel and analytics based. It is very important to understand what data points will help drive the desired outcome.