Financial & Underwriting Analyst

Colonial Group; Atlanta (GA); On-site; USD 65,000 - 90,000; Full time

Job summary

Colonial Group is seeking a Financial Analyst to support the Consulting Team with a focus on claims experience, reserve calculations, and plan design alternatives. You will help summarize RFP responses, manage regulatory compliance, and organize financial data for client presentations.

Ideal candidates have strong Excel skills, clear communication, and the ability to work independently across multiple projects within a team environment.

Qualifications

• Bachelor's Degree or equivalent combination of education and experience.
• Two (2) or more years of related work experience.
• Must continue to meet Continuing Education requirements for license renewal.
• Valid Insurance License within 120 Days.

Responsibilities

• Prepares monthly, quarterly and annual claims utilization versus budget reports.
• Provides support for development of reserve calculations for self-funded health plans.
• Supports renewal process by inputting enrollment info, carrier renewals, pricing of benefit changes, and organizing financial data for client presentations.
• Supports marketing proposals by requesting RFPs, verifying benefits, premium rates and market competitiveness.
• Assists clients with maintaining compliance with state and municipality ordinances.
• Assists with benchmarking and trend analysis as needed.
• Serves as technical support to resolve financial issues.
• Engages in optimal usage of applicable software programs.
• Ensures data standards and integrity in the agency management system.

Skills

Verbal & written comms

Leadership

Planning & organizing

Independent work

Excel proficiency

Education

Bachelor's degree or equivalent

2+ years related experience

Insurance license within 120 days

Continuing education for license renewal

Job description

SUMMARY

Responsible for providing the Consulting Team with financial and analytic support on client projects, including, but not limited to, updating claims experience reports and reserve calculations, modeling plan design alternatives, summarizing RFP responses and maintaining state and municipality ordinances

ESSENTIAL DUTIES AND RESPONSIBILITIES

• Prepares monthly, quarterly and annual claims utilization versus budget reports;
• Provides support for development of reserve calculations for self-funded health plans;
• Supports clients’ health and welfare renewal process by inputting enrollment information, carrier renewals, pricing of benefit changes, and organizing financial data for presentations to clients;
• Provides support for marketing proposals by requesting RFPs, verifying benefits, premium rates and market competitiveness;
• Assists clients with maintaining compliance with state and municipality ordinances;
• Assists with benchmarking and trend analysis as needed;
• Serves as technical support, assisting other team members to resolve financial issues;
• Engages in optimal and appropriate usage of applicable software programs;
• Complies with agency management system data standards and data integrity (enters and maintains complete and accurate information);
• Other duties as assigned.

EDUCATION / EXPERIENCE

• Bachelor's Degreeor equivalent combination of education and experience
• Two (2) or more years of related work experience
• Must continue to meet Continuing Education requirements for license renewal
• Encouraged to complete Career Path requirements as communicated by supervisor
• Valid Insurance License within 120 Days

SKILLS

• Excellent verbal and written communications skills
• Good leadership, problem solving and time management skills
• Good planning, organizational and prioritization skills
• Ability and motivation to work independently
• Proficient in Microsoft Office products, particularly in Excel