Sales Analyst

Vacancy: Replacement

Pay Range: $70,000 - $84,000

This role will be accountable for providing analysis and reporting of order backlog data and sales delivery data to various user groups across the organization. This role will liaise with Commercial Management, Finance, Sales Support, Operations, Customer Support, Logistics, Sales, and Marketing to provide backlog and sales delivery data organized by week, month, quarter and year and segmented by Geographic territory, Products, Manufacturing location, Markets, Sales Organization and other attributes as required.

Responsibilities:

• Daily monitoring, refresh and reconciliation of backlog data and invoices for unclean orders and shifts from current quarter.
• During the course of refresh, reconciliation and monitoring, apply critical analysis to highlight discrepancies, trends, and higher level insights, to inform business leadership
• Continuous improvement of the process and tools, to drive improved efficiency and quality of results
• Conduct weekly backlog review meetings with Sales Support, Commercial Operations, Operations, Logistics, Customer Support and Accounting to ensure cross functional alignment on revenue recognition including customer acceptance requirements, shipment consolidation requirements, Incoterms and shipping duration and pre-shipment collection status
• Document notes during weekly calls
• Support backlog management and sales forecast accuracy by properly maintaining revenue recognition month, status color, confidence level, and partial revenue recognition—especially for newly confirmed orders
• Assist business leadership with ad hoc backlog analysis
• Ensure transparency of shipped goods status, including outbound tracking
• Execute monthly backlog closing activities
• Follow up on any missed revenue recognition items throughout the month
• Lead the cleanup of $200K backlog, including associated revenue recognition
• Prepare and submit weekly reports for meetings
• Follow up with PE and/or team leaders for orders past due for initiation (kick off) in manufacturing
• Follow up with PE and/or team leaders for orders with misalignment between sales order delivery dates and purchase order dates
• Follow up with PE and/or team leaders for orders where delivery dates are out of alignment
• Preparation and distribution of various views of backlog and sales deliveries data on a weekly basis
• Data entry of delivery dates from manufacturing locations not using BaanIV
• Data entry of Service order completion dates
• Provide support to Orders to Cash continuous improvement project managers with data reporting and analysis required for project scoping, execution or metrics

Qualifications:

• Expert Knowledge of Microsoft Excel Pivot Tables, coding and other analysis tools and formulas, preferably experience with VBA macro programming
• Proven report writing experience, preferably with SAP Business Objects
• Prior experience with data analytics
• Exposure ERP system use in a manufacturing environment involving sales order control, project control, production control and purchase control activities, preferably with an Infor BaanIV.
• Exposure to an order management system, preferably MicroSoft Dyanmics CRM.
• Exposure to international shipping and logistics activities, preferably with a strong working knowledge of Incoterms 2010.
• Effective intake skills to develop a clear understanding of report requirements and business value.
• Analytical ability with a strong attention to detail to manage large amounts of data and draw meaningful conclusions that are presented in clear and concise ways.