Forecast Analyst jobs in Billings, MT

PURPOSE:

The Sales Analyst is responsible for reporting, data mining, data analysis and project support for the Sales team as well as the customer. Has a direct relationship with the customer’s business, data, and IT team and works with internal business partners involved in managing, determining, and maintaining data, in order to support the customer’s utilization of company data. Provides recurring reports and develops ad hoc reports needed to monitor company and customer businesses. Analyzes data, prepares and presents results in order to identify and/or resolve business problems as well as drive business actions in often-critical areas. Develops processes and technological tools, identifies technological and data-driven solutions, and leads or participates in the development of and execution of IT-related projects such as new report development and system enhancements/fixes to meet company and customer goals. The nature of the work is highly analytical and organized.

JOB RESPONSIBILITIES:

Sales Data Mining & Analysis (40%)

• Assesses sales data for the sales team. Examine monthly, quarterly, and annual sales reports to: identify sales patterns, areas for improvement, contract compliance, supplement UNFI fill rate reporting and specific customer requests.
• Assess market data, including competitors, to identify areas where the sales team can increase its efforts.
• Evaluates data using Access, Excel and other tools to identify root causes and possible solutions to company and customer business issues and to support business project and change needs; sources and manipulates data from company and customer.
• Provides guidance on pros and cons of possible solutions, recommends business process changes, and develops metrics.
• Develops analytics on sales data by customers to help determine opportunities of what the customer may carry today compared to top selling items for that brand or category.

Sales Forecasting (20%)

• Creates sales and revenue forecasts using economic conditions, pipeline analysis, booking estimates, and key sales performance indicators.
• Gathers, analyzes, and provides forecast information on sales, products, and customers for assigned territory.

Account Support (20%)

• Assist in preparing sales materials.
• Work with the Operations teams to determine the status of deliveries.
• Work with internal teams to determine the arrival of out-of-stock products.

Project Support (20%)

• Provides direct support to the customer’s data and IT teams to research and resolve issues with transmitted company data, especially cost and product data.
• Submits IT Service Requests to automate ad hoc reports, enhance system functionality, and fix system issues; designs and performs high-quality and accurate user-acceptance testing; approves developed solution for install.

JOB REQUIREMENTS:

Education/ Certifications:

• Bachelor’s Degree preferred.

Experience:

• 3 years of sales analyst experience preferred.
• Understanding of sales forecasting, programs, promotions, and related techniques.
• Understanding of margin and company profitability.

Other Skills/ Abilities:

• Root cause analysis, solution research and development, modeling of change options and recommendations.
• Compilation and presentation of data and analysis results that inform and drive leadership decisions.
• Able to manage and coordinate projects.
• Strong interpersonal, communication, organizational and analytical skills.
• Experience working with Data Warehouses and querying information from large datasets.
• Basic knowledge of writing or working with VBA and SQL languages preferred.

PHYSICAL ENVIRONMENT/ DEMANDS:

• Most work is performed in a temperature-controlled office environment.
• Incumbent may sit for long periods of time at desk or computer terminal.
• While performing the duties of this job, the employee is regularly required to sit; use hands to finger, handle, or feel; reach with hands and arms; and talk or hear.
• Incumbent may use calculators, keyboards, telephone and other office equipment in the course of normal workday.
• Stooping, bending, twisting and reaching may be required in completion of job duties.

All qualified applicants will receive consideration for employment without regard to race, color, age, religion, sex, sexual orientation, gender identity or expression, national origin, disability, or protected veteran status. UNFI is an Equal Opportunity employer committed to creating an inclusive and respectful environment for all. - M/F/Veteran/Disability. VEVRAA Federal Contractor.