Payroll & Financial Data Analyst

Payroll & Financial Data Analyst

Summary

Location: BGC, Taguig City – Philippines (Hybrid)

Day Rate: Negotiable

Duration: 6 months

About the Client

CHAMP Cargosystems provides the most comprehensive range of integrated IT solutions and distribution services for the air cargo transport chain. The portfolio spans core management systems, eCargo solutions and Insights.

The company serves over 200 airlines and GSAs, and links these with some 3,000 forwarders and GHAs worldwide. CHAMP's solutions help its customers and their clients adapt to critical and continuous changes in air transport logistics to meet global trade demands.

Headquartered in Luxembourg, we have over 400 employees located in offices in Frankfurt, London, Manila, Singapore, and Zurich, as well as Atlanta.

About the Role

They are currently looking for a Payroll & Financial Data Analyst to join their team.

Key Duties:

1. High-Volume Data Processing & Input (MS Excel):

• Rapidly collect, normalize, and input raw operational data (timecard logs, overtime sheets, on-call hours, and Sick/Vacation leave filings) into master Excel working papers.
• Perform end-to-end bi-monthly salary calculations (1st and 2nd pay period cutoffs) with strict precision, following established calculation protocols step-by-step.

2. Philippine Statutory, Tax & DOLE Premium Calculations:

• Calculate and review employee and employer statutory contributions in compliance with current SSS, PhilHealth, and PagIBIG rules.
• Compute monthly withholding taxes on compensation based on current BIR Tax Tables, including proper application of taxable vs. non-taxable income (e.g., De Minimis allowances, 13th-month threshold).
• Apply DOLE Premium Rates & Multipliers according to law and company policy.Instruction Following, Quality Control & Audit.
• Strictly adhere to standard operating guidelines and Mich's payroll processing workflows without skipping verification steps. o Build and maintain conditional checks, validation rules, and error flags in Excel to catch data discrepancies (e.g., missing time-ins, duplicate entries, negative net pay).
• Perform thorough pre-payroll and post-payroll self-audits prior to submitting work for final approval.

3. Workbook Optimization:

• Assist in standardizing, locking, and structuring Excel master templates to streamline data entry, automate cross-referencing (XLOOKUP, SUMIFS), and reduce manual processing friction for future cycles.

What we are looking for

• Proven track record of high focus and meticulous attention to detail when working with numbers under repetitive or high-volume conditions.
• Demonstrated ability to follow detailed instructions, SOPs, and DOLE/company calculation logic precisely without making assumptions or unauthorized alterations.
• Advanced mastery of Excel formulas and functions (XLOOKUP, INDEXMATCH, nested IFs, SUMIFS, dynamic arrays).
• Proficiency in Power Query and Pivot Tables for fast data cleaning, merging, and ingestion.
• Rapid, error-free numerical data entry skills.
• At least 2+ years of hands-on experience preparing or auditing Philippine local payroll.
• Deep practical knowledge of BIR tax rules (Form 1601-C calculations), SSS/PhilHealth/Pag-IBIG tables, and DOLE labor standards regarding variable pay components.
• Strict adherence to the Data Privacy Act (DPA) when handling sensitive employee pay and personal data.