Data Analyst

Field Outsource Asia Inc; Quezon City; On-site; PHP 334,800 - 558,000; Full time

Job summary

A data management company located in Quezon City is seeking a candidate proficient in Microsoft Excel to assist in data integration, commission calculation, and report generation. Candidates should be open to both genders and possess a strong understanding of Excel formulas. This position is crucial in ensuring data accuracy and compliance with governance standards.

Qualifications

• Open to male or female applicants.
• Proficient in Microsoft Excel, including lookup and conditional formulas.
• Able to read, understand, and edit existing formulas within templates.

Responsibilities

• Collect, clean, integrate, and prepare data from multiple sources.
• Perform commission and incentive computations ensuring accuracy.
• Work with Finance and Sales departments to verify sales data.

Skills

Microsoft Excel proficiency

VLOOKUP

SUMIF

Data integration

Job description

• Collect, clean, integrate, and prepare data from multiple sources such as retail POS, e-commerce platforms, CRM, supply-chain, marketing campaigns, and regional market reports.
• Collect and consolidate reports from Area Supervisors to create monthly reports.
• Perform commission and incentive computations for sales and beauty advisor teams across retail and e-commerce channels, ensuring accuracy and timeliness.
• Develop and maintain commission calculation templates, dashboards, and automated workflows to streamline monthly processes.
• Work closely with Finance and Sales departments to verify sales data, eligibility, and payout alignment with company policies.
• Reconcile computed commissions with finance records and resolve discrepancies promptly.
• Ensure data integrity and compliance with LUXASIA’s data governance standards.
• Consolidate brand rankings for all stores.

Qualifications:

• Open to male or female applicants.
• Proficient in Microsoft Excel, including:
• Lookup formulas (VLOOKUP, XLOOKUP)
• Conditional formulas (SUMIF, MATCH)
• Able to read, understand, and edit existing formulas within templates.