Finance Analyst Mid - Reconciliation (Nightshift)

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.