Managing Consultant – Simulation/Modelling
TYLin
PythonTableau
Large Group Underwriter Consultant
Elevance Health
full-time
Posted on:
Location Type: Hybrid
Location: Indianapolis • California, Colorado, Illinois, Washington • 🇺🇸 United States
Visit company websiteSalary
💰 $83,200 - $143,520 per year
Job Level
Mid-LevelSenior
About the role
- Calculates renewal rates for large complex cases based on thorough analysis of experience, location, demographics, etc.
- Determines and provides guidance to medical underwriters concerning the risk selection of applicants applying for individual health coverage.
- Coordinates with other departments to ensure accuracy and consistency of overall account reporting.
- Proposes rates for prospective business utilizing a combination of other carrier experience, demographic data and manual rates.
- Performs post-sale reviews.
- Prepares or supervises preparation of annual settlements, ERISA reports, rate projections, or benefit change increments and decrements.
- Surveys existing product portfolios by market, monitors sales results, trends and needs, recommends product portfolio changes.
- Assists in establishing rating and administrative procedures.
- Participates in major multi-functional teams as underwriting representative.
- Assists in the technical development of underwriting associates, which may include monitoring reports and work flow to provide recommendations on productivity and efficiency improvements.
- Updates and monitors departmental processes and procedures in compliance with system, regulatory and business requirements.
Requirements
- Requires a BA/BS in a related field
- Minimum 5 years of related experience
- Intermediate Microsoft Excel experience to include advanced proficiency in formulas, PivotTables, VLOOKUPs, and macros is strongly preferred
- CPCU, CLU, LOMA, HIAA or other insurance related courses preferred
- Healthcare industry experience preferred
Benefits
- comprehensive benefits package
- incentive and recognition programs
- equity stock purchase
- 401k contribution
- paid holidays
- Paid Time Off
- medical benefits
- dental benefits
- vision benefits
- short and long term disability benefits
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
data analysisrisk selectionrate projectionspost-sale reviewsproduct portfolio managementadministrative proceduresmonitoring reportsproductivity improvementsregulatory compliancehealth coverage
Soft skills
guidancecoordinationcommunicationteam participationtechnical developmentrecommendationaccuracyconsistencyefficiencyanalysis
Certifications
CPCUCLULOMAHIAA
