Reconciliation & Data Automation Specialist

Magic Payment Inc.; Manila; Presencial; PHP 380.000 - 720.000; Jornada completa

Descripción de la vacante

Magic Payment Inc. in Manila seeks a detail‑oriented Reconciliation Specialist to perform daily, weekly, and monthly reconciliations for cash‑in and cash‑out transactions and to collaborate with Finance, Operations and IT to resolve variances.

The role emphasizes advanced Excel skills, data analysis, and creating reliable templates and dashboards; familiarity with payment gateways and SQL is a plus for automating processes.

Formación

• Bachelor’s degree in Finance, Accounting, Business, or related field.
• Strong understanding of payment flows, settlement cycles, and upstream provider transactions.
• Advanced Excel skills (pivot tables, VLOOKUP/XLOOKUP, SUMIFS, INDEX-MATCH, macros a plus).
• High attention to detail with excellent problem-solving and analytical abilities.
• Strong communication and collaboration skills to work effectively across teams.

Responsabilidades

• Perform daily, weekly, and monthly reconciliation for cash-in and cash-out transactions.
• Investigate and resolve reconciliation variances promptly to ensure accurate, complete data.
• Collaborate with Finance, Operations, and IT to identify, report, and rectify discrepancies.
• Maintain and improve reconciliation templates and dashboards using Excel or other analytical tools.
• Prepare reconciliation summaries and exception reports for management review.
• Support audit and compliance requirements by maintaining organized and traceable reconciliation records.
• Continuously identify opportunities to automate or streamline the reconciliation process for efficiency.

Conocimientos

Attention to detail

Analytical thinking

Team collaboration

Problem solving

Educación

Bachelor’s degree in Finance, Accounting, Business, or related field

Herramientas

Excel

SQL

Power Query

Power Pivot

VBA

Descripción del empleo

Magic Payment Inc. in Manila seeks a detail‑oriented Reconciliation Specialist to perform daily, weekly, and monthly reconciliations for cash‑in and cash‑out transactions and to collaborate with Finance, Operations and IT to resolve variances.

The role emphasizes advanced Excel skills, data analysis, and creating reliable templates and dashboards; familiarity with payment gateways and SQL is a plus for automating processes.