Senior Lead Analyst Forecasting

Copeland; Quezon City; Hybrid; PHP 600,000 - 1,000,000; Full time

Job summary

Copeland is seeking a Senior Lead Analyst, Forecasting to provide analytical and data support to Forecasting & Demand Planning Management, Regional Sales Team, and Vertical Team in a monthly cycle. The role covers Exports Air Conditioning, Export Refrigeration, Export Transport, Export Motors, and Cold Chain for strategic planning and marketing purposes.

The incumbent will consolidate data, apply calculations, create charts and reports, and participate in forecast reviews with sales managers to

Qualifications

• 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.

Responsibilities

• 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
• 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

Skills

Analytical skills

Problem solving

Multi-tasking

Cross-trained flexibility

Backup readiness

English communication

Independent work

Education

4-year business degree

Engineering degree

BS IT/CS (plus)

Tools

Sigma

Oracle

Demantra

MS Office

Excel

PowerPoint

MS Access

SQL

Job description

Hybrid

Quezon City, Manila, Philippines

Full time

JR118465

About Us

We are a global climate technologies company engineered for sustainability. We create sustainable and efficient residential, commercial and industrial spaces through HVACR technologies. We protect temperature-sensitive goods throughout the cold chain. And we bring comfort to people globally. Best-in-class engineering, design and manufacturing combined with category-leading brands in compression, controls, software and monitoring solutions result in next-generation climate technology that is built for the needs of the world ahead.

Whether you are a professional looking for a career change, an undergraduate student exploring your first opportunity, or recent graduate with an advanced degree, we have opportunities that will allow you to innovate, be challenged and make an impact. Join our team and start your journey today!

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

Our Commitment to Our People

Across the globe, we are united by a singular Purpose: Sustainability is no small ambition. That’s why everything we do is geared toward a sustainable future for our generation and all those to come. Through groundbreaking innovations, HVACR technology and cold chain solutions, we are reducing carbon emissions and improving energy efficiency in spaces of all sizes, from residential to commercial to industrial.

Our employees are our greatest strength. We believe that our culture of passion, openness, and collaboration empowers us to work toward the same goal - to make the world a better place. We invest in the end-to-end development of our people, beginning at onboarding and through senior leadership, so they can thrive personally and professionally.

Flexible and competitive benefits plans offer the right options to meet your individual/family needs. We provide employees with flexible time off plans, including paid parental leave (maternal and paternal), vacation and holiday leave.

Together, we have the opportunity and the power to continue to revolutionize the technology behind air conditioning, heating and refrigeration, and cultivate a better future. Learn more about us and how you can join our team!

Our Commitment to Inclusion & Belonging

At Copeland, we cultivate a strong sense of inclusion and belonging where individuals of all backgrounds, and with diverse perspectives, are embraced and treated fairly to enable a stronger workforce. Our employee resource groups play an important role in culture and community building at Copeland.

Equal Opportunity Employer

Copeland is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to sex, race, color, religion, national origin, age, marital status, political affiliation, sexual orientation, gender identity, genetic information, disability or protected veteran status. We are committed to providing a workplace free of any discrimination or harassment.

With $5B of global revenue, Copeland is a leading provider of compression products, electronics, software, and solutions across many applications within Heating, Ventilation, Air Conditioning, and Refrigeration (HVACR), where macro and regulatory trends towards environmental sustainability, leads to changes in HVACR technology. Other products include other heating applications, food service and retail, transportation, and healthcare/life sciences. This new business also has a solution portfolio that manages, monitors, and controls refrigeration units in the commercial setting, as well as software solutions that measure and monitor temperature conditions of refrigerated goods in transit, where there is a greater emphasis on energy management/sustainability solutions globally.