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.

Schedule: Mid Shift

In this position you will be working within the Corporate Actuarial Department of a dynamic insurance company collaborating with finance, IT and partnering with fellow Business and Database Analyst team members, as well as Actuarial Analysts to carry out the functions necessary to support the actuarial reserving processes and corporate financial reporting.  Other functions specific to this team are managing SOX controls and managing statutory data updates. 

• Facilitate the timely, complete, and accurate delivery of premium and claim activity from IT/Finance to support the quarterly Actuarial Reserving and Statutory Reporting processes. 
• Identify, analyze, and draw conclusions on questions from Actuarial and  Finance Teams using available analysis and reporting tools. 
• Improve and streamline reconciliation processes to increase accuracy and efficiency. 
• Support the optimization of Data Quality procedures. 
• Facilitate and enhance SOX and other required audit reporting. 
• Facilitate and deliver adhoc projects and reports to support operational needs. 

• Strong knowledge of SQL database functionality.  Basic knowledge of Snowflake is a plus. 

• MS Excel (advanced spreadsheet knowledge, formulas, pivot tables, MS Query, macros, etc.) 

• Background in insurance, accounting, or reporting 

• Ability to stay organized, manage multiple priorities and respond to critical needs of the Actuarial and Finance departments. 

• Strong oral, written and technical communication skills. 

• Ability to perform in a fast paced environment, keeping track of details and seeing tasks through to completion 
• Knowledge of other MS Office products: Word, Access, Visio, Outlook 
• Ability to trouble shoot and problem solve 
• Ability to identify opportunities and strategies to improve existing process efficiency (proactive and active) 
• Ability to interact with senior management in a professional manner 
• Background in finance or actuarial science a plus

Bachelor’s degree in Mathematics, Computer Science, or related field.