Junior Data Analyst

CNT Promo & Ads Specialist, Inc.; Mandaluyong; On-site; PHP 350,000 - 520,000; Full time

Job summary

CNT Promo & Ads Specialist, Inc. is seeking an HR Data & Reporting Analyst to manage employee data, timekeeping, attendance, and leave information. The role will validate payroll data, monitor discrepancies, and produce Excel-based reports, dashboards, and presentations for management.

You will also analyze HR data to derive actionable insights, present findings to managers, and support HRIS enhancements and data migration projects using AI tools to boost efficiency.

Qualifications

• 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 advantageous.

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.
• 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.

Skills

XLOOKUP/VLOOKUP/INDEX-MATCH

IF/SUMIFS

Pivot Tables

Data cleaning/validation

Analytical thinking

Presentation to managers

Problem solving

Detail-oriented

Education

BS Information Technology

Computer Science

Information Systems

Tools

Excel

Power BI

SQL

Google Looker Studio

HRIS

Payroll/Timekeeping systems

Job description

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