Key Responsibilities:

• 
  Collect, clean, and validate attendance and payroll data from biometric systems, HRMIS, and manual master rolls.

• 
  Prepare and update
  daily discrepancy matrices
  for all employees, highlighting mismatches and missing clock-ins.

• 
  Generate
  summary sheets
  showing paid, unpaid, excused, and off days for payroll and HR updates.

• 
  Reconcile data discrepancies between biometric systems and HR records, providing clear comments and status flags.

• 
  Format and maintain
  Excel-ready payroll data files
  for seamless HRMIS and ERP uploads.

• 
  Track
  new hires, exits, and rehires
  , ensuring dates and attendance records are properly updated.

• 
  Develop and maintain
  dashboards and analytical reports
  on attendance trends, absenteeism, sick offs, and leave utilization.

• 
  Prepare
  disciplinary and KPI reports
  to support HR actions and performance tracking.

• 
  Collaborate with the HR and Finance teams to ensure payroll accuracy, compliance, and timely processing.

• 
  Maintain strict confidentiality and data integrity across all HR and payroll data sets.

Key Skills and Competencies:

• 
  Advanced proficiency in
  Microsoft Excel
  (Pivot Tables, VLOOKUP/XLOOKUP, INDEX-MATCH, Conditional Formatting, Data Validation).

• 
  Strong understanding of
  payroll, attendance tracking, and leave management
  processes.

• 
  Experience with
  biometric attendance systems
  ,
  HRMIS
  , or
  ERP platforms
  (SAP, Oracle, etc.) preferred.

• 
  Excellent attention to detail, analytical thinking, and problem-solving skills.

• 
  Ability to interpret data and communicate insights effectively through dashboards and reports.

• 
  High integrity and discretion when handling sensitive employee data

Requirements

• 
  Bachelor’s degree in
  Data Analysis, Statistics, HR, Finance, Business Administration, or a related field
  .
• 
  Minimum
  2–4 years of experience
  in data analysis, payroll administration, or HR analytics.

• 
  Demonstrated experience reconciling attendance and payroll data is a strong advantage.

• 
  Familiarity with
  HR data reporting tools
  and dashboard creation is desirable.