Area Planning Assistant - Mandaue

Philip Morris International; Mandaue; On-site; PHP 100,000 - 400,000; Full time

Job summary

Join Philip Morris International as part of the Commercial Planning group where you will play a key role in supporting the Sales Team through data analysis and reporting. With responsibilities including sales data validation, compliance monitoring, and customer record management, you'll contribute to the company's commercial transformation efforts while enjoying competitive benefits and a progressive work culture.

Benefits

Guaranteed 14th month pay

HMO coverage for employee and qualified dependents

PHP 10,000 annual medical reimbursement

Retirement Plan

Leave Conversion

Qualifications

• At least 1-2 years of sales or finance reporting experience.
• Experience in building and analyzing data (forecasting, target setting).
• Highly proficient in Microsoft Excel (data validation, conditional formatting, etc.)

Responsibilities

• Provide commercial planning support to the Sales Team.
• Responsible for compliance to iSMS process including FG reconciliation.
• Generate data required for target setting and provide sales reports.

Skills

Data Analysis

Microsoft Excel

Strategic Thinking

Education

Graduate of a 4-year course

Job description

Be a part of a revolutionary change

Sales and Marketing at PMI feels like building a new business – but with the accumulated expertise of a global brand behind you. Bring us your curiosity and capacity to engage people and you can be part of the digital, Omni-channel team that’s driving our huge commercial transformation.

Purpose Of The Job

PMFTC is seeking talented people to join our Commercial Planning group.

Providing commercial planning support to the Sales Team (Sales Office and/or Satellite Sales Office and/or region and/or headquarters) to ensure efficient operations. Ensures that all tasks are performed in a timely manner ensuring accuracy of outputs and confidentiality.

Accountabilities

Your day to day tasks are the following:

Responsible for overall compliance to iSMS process, including tasks but not limited to:

Goods (FG) reconciliation

• Generate and provide data required for FG reconciliation
• Upload FG reconciliation report for approval of SM and Finance

Reconciliation

• Daily validation of load & stock summary reports from salesmen vis-a-vis stock balance in iSMS

Plan Maintenance

• For all Territory recuts/reassignments, ensure changes are encoded in iSMS

Customer Master Data

• Coordinate with the Field Sales Force and Supervisor
• Regularly review customer master data to ensure data accuracy and completeness of customer records
• Ensure all customer records adhere to company standards and no duplicate customer records
• Validate accuracy of uploaded customer documents vis-a-vis data input in iSMS
• Coordinate customer admission and deactivation

Reporting and Analysis

• Generate data required for target setting
• Provide accurate reports to Field Sales Management in accordance with standards, guidelines, and schedule
• Provide daily sales reports to HQ SI based on sales per salesman/ sales office (DSMT - Daily Sales Monitoring Template)
• Provide adhoc reports to operations upon request

iPAD Run and Support

• Ensure level 0 concerns are resolved following the knowledge base (KB) document
• Coordinate with Area Planning Support, Information System, and Sales Systems for iPAD related concerns such as IOS update and iSMS updates
• Responsible for the inventory of all iPAD devices in the sales office

Administration

• Maintain hardcopy records of stock summary, stock movement reports, load plans, CMR, CPF, etc.
• Conduct regular housekeeping of these hardcopy records following proper retention policy in reference to the Global Retention Schedule

Skills and Competencies

• Graduate of a 4-year course
• At least 1-2 years of sales or finance reporting experience
• Experience in building and analyzing data (forecasting, target setting)
• Perform comprehensive data analysis and make recommendations
• Highly proficient in Microsoft Excel (data validation, conditional formatting, etc.)
• Ability to think strategically

Work Location: Bacolod Sales Offices

Work Schedule: Mondays to Saturdays, with flexible hours starting as early as 8:30 AM

Compensation & Benefits:

• Guaranteed 14th month pay
• HMO coverage for employee and qualified dependents
• PHP 10,000 annual medical reimbursement
• Retirement Plan
• Leave Conversion

At PMI, we foster a diverse, equitable, and inclusive workplace. We see diversity as our greatest strength, and are committed to building an inclusive culture and workplace reflective of the world’s diversity. Our focus is on creating an environment where our employees from across the globe can be their true selves at work, contribute their best, support each other, and drive innovation and consumer-centricity to achieve a smoke-free future.

With huge change, comes huge opportunity. So, wherever you join us, you’ll enjoy the freedom to dream up and deliver better, brighter solutions and the space to move your career forward in endlessly different directions.