Junior Data Analyst

About the role

This role involves collecting, cleaning, validating, and maintaining HR data including employee records, timekeeping, attendance and leave information. You will prepare and validate timekeeping and payroll data, monitor attendance and leave data, and investigate discrepancies. You will create and maintain Excel reports, trackers, dashboards and management presentations, analyze HR data and translate findings into actionable insights, and present reports to managers and stakeholders. You will serve as a point person for HR data and timekeeping concerns, coordinate with HR and other departments to ensure data accuracy and process compliance, use AI tools and automation to improve reporting efficiency, and support HRIS/system enhancement, data migration, testing and related projects.

Key responsibilities

• Collect, clean, validate, and maintain HR data including employee records, timekeeping, attendance and leave information
• Prepare and validate timekeeping and payroll data every payroll cut-off
• Monitor attendance and leave data and investigate discrepancies or unusual records
• Create and maintain Excel reports, trackers, dashboards and management presentations
• Analyze HR data and translate findings into clear, actionable insights
• Present reports and explain data findings to managers and stakeholders
• Prepare weekly and monthly HR reports and analytical presentation materials
• Serve as a point person for HR data and timekeeping concerns and coordinate resolution
• Coordinate with HR and other departments to ensure data accuracy and process compliance
• Use AI tools and automation to improve reporting efficiency and reduce repetitive tasks

About you

• Graduate of BS Information Technology, Computer Science, Information Systems, or another computer/data-related course
• Fresh graduates are welcome to apply
• 1–3 years of experience in data analysis, reporting, HR data, payroll, timekeeping, or related work is an advantage
• Strong XLOOKUP/VLOOKUP, INDEX-MATCH, IF, SUMIFS, Pivot Tables, data cleaning, and validation skills
• Strong analytical, problem-solving, organizational, and detail-oriented skills
• Able to explain data and present findings directly to managers and stakeholders
• Knowledge of AI tools for analysis, reporting, automation, and productivity
• Power BI, SQL, Google Looker Studio, HRIS, payroll/timekeeping systems, or data visualization experience is an advantage
• Adaptable, professional and able to handle confidential employee information with integrity