Finance Analyst Mid - Reconciliation (Nightshift)
At a glance
Mid-level FP&A role at Arch Global Services (Philippines) Inc. Remote, Philippines · full-time.
Pay not stated FP&A salary
financeroles summary, based on the employer's posting.
What you'll do
- Compare policy premiums, commissions, receivables and other details across Arch and MGA financial systems
- Build exhibits that explain mismatches, and keep policy-level records tied to those summaries
- Track outstanding differences over time and work with accounting, underwriting, IT and MGA contacts to clear them
What you bring
- A bachelor's degree in finance, accounting, mathematics or another listed discipline
- Hands-on experience with financial systems and accounting work
- Strong Excel skills, including pivot tables and complex formulas such as VLOOKUP and SUMIF
- Careful analytical work, with clear written and verbal communication
Who this fits
This mid-level role suits someone who can investigate policy data carefully and coordinate with several groups to resolve discrepancies. The position is remote and designated for night shift.
From the employer
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.