Finance Analyst Mid-Level (Reconciliation)

Work schedule: Nightshift (PH time)

Job Summary

The Finance Analyst 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.

Job Responsibilities

• 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

Required Skills

• 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.)

Education

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