Provide analytical support to the Finance Department, prepare the annual premium and expense budgets as well as preparing analyses of variances to the budget. Duties involve running routine reports modifying existing reports writing new reports and analyzing data using SAS Excel and other tools as necessary.
1. The analyst also provides clarification as necessary regarding data and analysis to upper management other departments and outside entities including actuaries auditors and providers. Preparation of premium and medical cost projections for the annual budget. 2. Analysis of variances in IBNR and medical costs to budget. Use trend analysis to more accurately describe variances from expected (budget to actual). Prepare summary analyses of variances to budget for senior management. 3. Trends analysis (utilization and cost). Track component pieces of trending including unit cost and frequency in order to quantify causes of trend. 4. Analysis of variances in administrative expenses to budget by department. Prepare summary of final explanation of variances by department. 5. Various other duties and activities as assigned. Assist department with multiple requests for data and analysis from senior management.
Requirements: • Ability to analyze and manipulate data in the area of financial analysis. • Skill and proficiency in the use of advanced spreadsheets database and statistical software on personal computer. • Three or four years related experience. • Ability to communicate results and findings in a clear and concise manner. • Excellent written and oral communication skills. • Insurance industry experience preferred. • Work may involve extended hours to meet tight deadlines.
• EDUCATION: BS or higher degree in accounting finance mathematics or statistics.
The Franklin Paterson Company, Inc., invites you to take a fresh perspective on Job Search and Resume Sourcing for Consulting and Permanent Employment Jobs, tailored to meet the goals and objectives of the small to medium sized business