Finance Analyst Mid - Reconciliation (Nightshift)

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.