Finance Analyst Mid - Reconciliation (Nightshift)

Arch Global Services (Philippines) Inc.; Taguig; On-site; PHP 400,000 - 600,000; Full time

Job summary

AGSI is seeking a Finance Analyst (Mid) for night shift to reconcile policy data between Arch’s financial systems and MGA systems. You will create exhibits showing reconciling differences and work across teams to clear them.

The role requires strong Excel skills and experience with financial systems, plus clear written and verbal communication to resolve issues efficiently.

Qualifications

• BS in Finance, Accounting, Mathematics, Economics, Statistics or related discipline.
• Strong analytical skills with attention to detail and accuracy.
• Working knowledge and experience with financial systems.
• Strong verbal and written communication skills.
• Excel including complex functions and pivot tables (e.g., sumproduct, VLOOKUP, SUMIF).

Responsibilities

• Reconcile policy level premium, commissions, open receivables and other policy details between Arch’s systems and the MGA’s systems.
• Prepare exhibits summarizing reconciling differences with explanations describing the cause.
• Maintain policy level detail reflecting the summarized differences in the exhibits.
• Track and age differences.
• Collaborate with program accountant, Arch underwriter, Arch IT and MGA to resolve open differences.

Skills

Microsoft Excel

Financial Systems

Analytical skills

Communication skills

Education

BS in Finance, Accounting, Mathematics, Economics, Statistics or related discipline

Tools

Pivot Tables

Job description

Finance Analyst Mid - Reconciliation (Nightshift)

• Full-time

AGSI was incorporated in April 2016. We are committed to supporting the goals of Arch divisions through exceptional service delivery. We pride ourselves on maintaining flexibility and responsiveness to adapt to business unit and industry demands while focusing on sound project management. We are dedicated to growing and developing our employees as we build strong teams with strategic leadership.

Arch’s delegated authority programs are written by third party agencies referred to as Agencies or Managing General Agencies (MGA’s). Arch has a regulatory requirement to audit the MGA. The candidate will reconcile policy data between Arch financial systems and the systems of the MGA for the various programs. The candidate will create exhibits to identify the reconciling differences and work with various groups to resolve and clear the differences.

Responsiblities:

• Reconcile policy level premium, commissions, open receivables and other policy details between Arch’s systems and the MGA’s systems.
• Prepare exhibits summarizing the various reconciling differences with explanations describing the cause for the difference
• Maintain policy level detail which reflect the summarized differences in the exhibits
• Track and age differences
• Work with program accountant, Arch underwriter, Arch IT and MGA to resolve open differences
  • Technical Skills: Microsoft Excel, Microsoft Office, Financial Systems, Accounting experience
  • Strong analytical skills with the ability to collect and organize significant amounts of information with attention to detail and accuracy.
  • Working knowledge and experience with financial systems.
  • Strong verbal and written communication skills.
  • Strong knowledge of Excel including complex functions and pivot tables to analyze data (sumproduct, vlookup, sumif, etc.)
  • BS in Finance, Accounting, Mathematics, Economics, Statistics or related discipline.