Area Planning Assistant - Guiguinto

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

Job summary

A leading company in the tobacco industry is seeking a Commercial Planner to provide support to their Sales Team in Guiguinto. The role involves data reconciliation, reporting, and ensuring compliance with company standards. Candidates should have a degree and relevant experience in sales or finance reporting, with strong analytical and Excel skills. Join PMI to be part of a diverse and inclusive workplace committed to innovation.

Benefits

Guaranteed 14th month pay

HMO coverage for employee and dependents

PHP 10,000 annual medical reimbursement

Retirement Plan

Leave Conversion

Qualifications

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

Responsibilities

• Provide commercial planning support to the sales team ensuring accurate outputs.
• Maintain records and ensure data accuracy in iSMS.
• Generate daily sales reports and provide data for target setting.

Skills

Sales reporting

Finance reporting

Data analysis

Strategic thinking

Microsoft Excel

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 & load and stock summary reports from salesman 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 to 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 based (KB) document
• Coordinate with Area Planning Support, Information System, and Sales Systems for iPAD related concerns such as IOS updates and iSMS updates
• Responsible for the inventory of all iPAD devices in the sales office

Administration

• Maintain hardcopy records such as stock summary, stock movement reports, load plans, CMR, CPF, etc.
• Conduct regular housekeeping of these records following proper retention policies as per the Global Retention Schedule

Skills and Competencies:

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

Work Location: Guiguinto Sales Offices

Work Schedule: Mondays to Saturdays, flexible start as early as 8:30 AM

Compensation & Benefits:

• Guaranteed 14th month pay
• HMO coverage for employee and 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 where employees can be their true selves, contribute their best, support each other, and drive innovation towards a smoke-free future.

With huge change comes huge opportunity. Join us to explore and deliver brighter solutions and advance your career in various directions.

11106