Assistant Data Analyst

PAPH TRAVEL AND TOURS; Quezon City; On-site; PHP 335,000 - 558,000; Full time

Benefits offered by this job

Travel incentives

Career growth

Healthcare (HMO)

13th month pay

Annual bonus

Leaves: 5 SL, 5 VL

Job summary

PAPH TRAVEL AND TOURS is seeking a data analyst to support travel operations onsite in Quezon City. The role focuses on extracting and cleaning routine data from travel systems, while maintaining KPI dashboards for travel managers.

You will audit data quality, fix duplicates, and assist senior analysts with custom datasets for client presentations and supplier negotiations. Strong Excel, SQL, and BI tooling are essential.

Qualifications

• Bachelor's degree in Tourism Management, Information Technology, Computer Science, Business Administration, Statistics, or Mathematics.
• 1 to 2 years experience; fresh graduates with strong internship exposure in data or travel operations welcome.
• Strong MS Excel and basic SQL, with exposure to BI dashboards.

Responsibilities

• Data Extraction & Cleaning: Extract routine data (e.g., daily flight bookings, hotel room-night pickups, cancellation logs, refund requests) from travel systems using basic SQL and Excel.
• Dashboard Maintenance: Update weekly or monthly KPI reports and dashboards (Power BI / Tableau) for travel managers.
• Data Quality Checks: Audit PNR entries, ticketing logs, and transaction records to fix missing entries, duplicates, or system errors.
• Ad-Hoc Data Assistance: Assist senior analysts in gathering specific travel datasets for client presentations or supplier negotiations.

Skills

Attention to detail

English communication

Analytical mindset

Education

Bachelor’s degree in Tourism Management, Information Technology, Computer Science, Business Administration, Statistics, or Mathematics

Tools

MS Excel

SQL

Power BI / Tableau

Amadeus / Sabre / Galileo

Job description

Job Description

• Data Extraction & Cleaning: Extract routine data (e.g., daily flight bookings, hotel room-night pickups, cancellation logs, refund requests) from travel systems using basic SQL and Excel.

• Dashboard Maintenance: Update weekly or monthly KPI reports and dashboards (Power BI / Tableau) for travel managers.

• Data Quality Checks: Audit Passenger Name Record (PNR) entries, ticketing logs, and transaction records to fix missing entries, duplicates, or system errors.

• Ad-Hoc Data Assistance: Assist senior analysts in gathering specific travel datasets for client presentations or supplier negotiations.

Qualifications:

• Education: Bachelor’s degree in Tourism Management, Information Technology, Computer Science, Business Administration, Statistics, or Mathematics.

• Experience: 1 to 2 years (fresh graduates with strong internship exposure in data or travel operations are welcome).

Technical Skills:

• Intermediate to Advanced MS Excel (VLOOKUP/XLOOKUP, Pivot Tables, basic formulas).

• Foundation in SQL (simple queries, JOINs, filtering data).

• Exposure to Power BI or Tableau (reading and updating existing dashboards).

• Basic familiarity with travel distribution platforms (Amadeus, Sabre, or Galileo) is a distinct advantage.

• Soft Skills: Meticulous attention to detail, good verbal/written English communication, and strong curiosity to learn travel metrics.

Work Schedule: FULL ONSITE - 6 days a week | Shifting Schedule (No Night Shift)
Location: 61 C, Roosevelt Ave, Santa Cruz, Quezon City, 1104 Metro Manila

COMPANY BENEFITS
Performance Based Incentives:

• Travel Incentives: Opportunities to visit dream destinations like Europe, Korea, Japan, and more!

• Career Growth: Guaranteed salary adjustments based on performance evaluations (SEMI-ANNUAL)

Upon Regularization:

• Comprehensive Healthcare: HMO coverage upon regularization (plus dependent coverage after year 1)

• Annual Bonus: 1 year from regularization.

• 13th month Pay.

• LEAVES: 5 SL, 5 VL