Group Underwriter I

HMSA; Honolulu (HI); Hybrid; USD 85,000 - 110,000; Full time

Job summary

HMSA in Hawaii seeks a data-driven analyst to calculate and analyze rates for large employer groups, using historical utilization and demographics to ensure accuracy and logical recommendations.

You will prepare rate renewals and filings, provide consultations to Marketing, support rate filing activities, and collaborate with underwriting and account management to adjust rates and present financial options.

Responsibilities

• Calculate and analyze rates for large employer groups using historical utilization and demographics to ensure accuracy and logical consistency.
• Extract and analyze historical data of accounts to support rate decisions and identify anomalies that justify adjustments.
• Prepare accurate rate renewals and rate filings using approved guidelines.
• Provide consultation and creative recommendations to Marketing on rate proposals.
• Support rate filing activities and respond to queries from Account Management and Sales.

Job description

1. Responsible for accurately calculating and analyzing rates for large employer groups using the historical utilization and demographics of the account. Extract and analyze historical data of the account to ensure accuracy and good logic. Analyze the overall composition of the group to ensure that the total risk is not excessive and identify any anomalies that may be present that would justify an adjustment. Produce accurate rate renewals and rate filings using pre-established guidelines approved by the State Insurance Commissioner. Provide consultation and creative recommendations to Marketing Department on the proposals produced. Support rate filing activities. Act as a resource for questions from accounts, Account Management, and Sales Department on rate renewal calculations and various financial arrangements. Collaborate with the underwriting and account management team to adjust rates and provide financial options as appropriate.
2. Accurately prepare and analyze reports as required by account (5500, utilization reports, financial reports, financial accountings, financial settlements, etc.). Prepare, analyze, and reconcile monthly billings for self-insured accounts based on the terms of the contract with the account. Answer underwriting questions from accounts and Account Management and Sales Department on statistical and financial reports.
3. Produce other data as needed to support the Account Planning process. Analyze and prepare rate proposals for new accounts based on information provided and be able to choose a course of action. Keeping HMSA's risk in mind.
4. Identify, research, and resolve data problems when they arise. Identify, research, track, and report paid/unpaid large case amounts as needed. Prepare and audit monthly recovery reports with supporting documentation and respond timely to open queries. Aggregate and organize data submissions and narratives for reinsurance audits and reinsurance renewal submissions.
5. Perform all other miscellaneous duties and responsibilities as directed or assigned.

#LI-Hybrid