Junior Data Analyst

Tasks

• Build attendance dashboards and analytical reports
• Clean and validate attendance and payroll data
• Collaborate with HR and finance teams
• Collect attendance and payroll data
• Generate payroll summary sheets
• Maintain Excel ready payroll data files
• Prepare daily discrepancy matrices
• Prepare disciplinary and KPI reports
• Reconcile biometric data with HR records
• Track new hires exits and rehires

Perks/Benefits

• N/A

Skills/Tech-stack

Attendance tracking | Conditional Formatting | Dashboarding | Data Reconciliation | Data Validation | Data reporting | ERP | HR Data | HR data reporting | HRMIS | INDEX/MATCH | Leave management | Microsoft Excel | Oracle | Payroll Processing | Pivot Tables | SAP | VLOOKUP | XLOOKUP