Senior Lead Analyst Forecasting

As a Senior Lead Analyst, Forecasting, your objective is to provide analytical and data support to Forecasting & Demand Planning Management, Regional Sales Team, and Vertical Team in a monthly cycle by providing current orders, backlogs, forecast and sales of Exports Air Conditioning, Export Refrigeration, Export Transport, Export Motors, and Cold Chain to be used for strategic planning and marketing purposes.

Main Duties 

• Consolidates and standardize data from different data sources
• Combines extracted data from multiple resources using automated tools (excel, macro, OTHER database TOOLS)
• Apply basic calculation to summarize the gathered data into information for further analysis
• Cleans extracted data using pre-defined guidelines or instructions.
• Formats extracted data based on expected report output. (multiple data formatting requirements)
• Creates histograms, charts, summaries as necessary to aid in easy interpretation and better provide decision support to the Marketing and Sales Community
• Calculates data using available fields within the gathered information. (statistics)
• Analyze and interpret data using descriptive analytics (basic mathematics, comparative analysis) 
•  Creates charts, trends as necessary to aid in easy interpretation and better understanding of analyzed data 
  
• Attend and participate in the regional forecast review with sales managers to discuss results of analysis (trends per customer and per product family, identify top drivers etc)
• Present sales forecast and gaps to the stakeholders (Marketing, Operation and Sales) gets their buy-in and commitment to any deliverable
• Conducts Pre SOP demand review meetings with sales team to discuss sales trend for production planning
• Request for new customer, supplier account creation and item creation in Copeland system
• Check availability of items in the system for shipment and approval
• Identifies continuous improvement project ideas
• Participate in continuous improvement project session to discuss opportunities to improve processes or standards
• Prepare documentation for new processes and reports

 EDUCATIONAL BACKGROUND

• Graduate of any 4 year business course
• Graduate of any engineering discipline course will also be considered
• Graduate of BS Information Technology or Computer Science is a plus

WORK EXPERIENCE OR TRAINING

• At least two (2) years’ experience gained from supply chain, engineering or manufacturing related business, plant operations
• At least two (2) years’ experience in product analysis &/or planning systems in an industrial setting
• Background in offshore service operations is an advantage
• Business systems applications skills such Sigma, Oracle and Demantra
• Computer applications skills such as MS Office- Excel, PowerPoint, MS Access, SQL

SKILLS AND ABILITIES

• Keen Analytical Skills
• Problem Identification & Solving Skills
• Multi-Tasking
• Ability to assume cross-trained function in the event of low utilization
• Ability to assume back up functions in the event of skills and capacity constraints.
• Excellent written and spoken communication skills in English. Ability to speak or write in another language is an advantage but not required, unless identified by the customer and support requirements
• Must be able to effectively and independently function while maintaining a positive energy level in an environment of constantly shifting demands.

OTHER WORK CONDITIONS

• Hybrid Work Arrangement (3x/week onsite)
• Mid-shift Work Schedule (will support APAC and IMEA)
• Must be amenable to work in Quezon City