Payroll & Financial Data Analyst

PSD Group; Taguig; Hybrid; PHP 738,000 - 1,199,000; Full time

Benefits offered by this job

Hybrid work arrangement

Job summary

CHAMP Cargosystems in Manila seeks a Payroll & Financial Data Analyst for a 6-month, hybrid role. You will handle high-volume data processing in Excel, bi-monthly payroll calculations, and statutory contributions for the Philippines.

The position emphasizes strict SOP adherence and data privacy compliance. Candidates should have 2+ years in Philippine payroll, advanced Excel skills (XLOOKUP, INDEXMATCH, SUMIFS), and experience with DOLE, SSS, PhilHealth, and Pag-IBIG rules.

Qualifications

• Advanced mastery of Excel formulas and functions (XLOOKUP, INDEXMATCH, nested IFs, SUMIFS)
• Proficiency in Power Query and Pivot Tables for data cleaning, merging, and ingestion
• Strong data entry accuracy and attention to detail
• Ability to follow SOPs and DOLE/company calculation logic precisely
• Experience with Philippine payroll calculations and tax rules is preferred
• Knowledge of DOLE labor standards and data privacy compliance

Responsibilities

• High-Volume Data Processing & Input in Excel for timecard and leave data
• End-to-end bi-monthly salary calculations with strict accuracy
• Calculate statutory contributions (SSS, PhilHealth, Pag-IBIG) and BIR tax withholdings
• Apply DOLE Premium Rates and multipliers and perform pre/post payroll audits
• Standardize and optimize Excel templates using XLOOKUP, SUMIFS, and dynamic arrays

Skills

Excel mastery

Payroll knowledge

Power Query

Pivot Tables

Data entry accuracy

SOP compliance

Attention to detail

Tools

Power Query

Pivot Tables

XLOOKUP/INDEXMATCH

Job description

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.